Impala Table alternative on Azure

Question

Hi Team,

I have a one-premise data pipeline, where we have cleaned data stored, On top of it we are creating IMPALA tables that connect to the tableau server so that when end-users change any filters or request any data from a table, Impala table can quickly go and fetch the data.

We planing on migrating this system to Azure, So I was what is the alternative tool I can use in Azure, which will give me the same flexibility as Impala. Please suggest

Answer 1

Hello @Imran Mondal ,

Thanks for the ask and using the Microsoft Q&A platform

Azure HDInsight - Interactive Query (Apache Hive with LLAP) is the closest alternative for Impala on Azure.

What is Interactive Query In Azure HDInsight?

Interactive Query (also called Apache Hive LLAP, or Low Latency Analytical Processing) is an Azure HDInsight cluster type. Interactive Query supports in-memory caching, which makes Apache Hive queries faster and much more interactive. Customers use Interactive Query to query data stored in Azure storage & Azure Data Lake Storage in super-fast manner. Interactive query makes it easy for developers and data scientist to work with the big data using BI tools they love the most. HDInsight Interactive Query supports several tools to access big data in easy fashion.

For migration, you can checkout this article: Migrate on-premises Apache Hadoop clusters to Azure HDInsight - motivation and benefits

Hope this helps. Do let us know if you any further queries.

------------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

You can use CDW experience in Cloudera Data Platform on Azure and choose Impala Virtual Warehouse. You will not have to re-write the queries and save time on migration.