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.