Hi Sonu,

You can connect Excel to the Hive data warehouse of an Hadoop cluster with ODBC driver.

Please check the following article for more detailed information:

https://azure.microsoft.com/en-in/documentation/articles/hdinsight-connect-excel-hive-odbc-driver/

You can also refer useful youtube videos:

https://www.youtube.com/watch?v=LfS5NX2UARA

https://www.youtube.com/watch?v=If12mDt6Pzs

Hope this helps.

Thanks.