25-04-23 02:24 PM
Hi,
Has anyone integrated with Hadoop hive to run a query and fetch the results? We are looking at an automation with a report in PowerBI and sourced to hadoop and we are trying to fetch the data directly from Data Source without having t use the PowerBI Dashboard.
Please reach out if any questions
Best Regards,
25-04-23 05:43 PM
Hello @Sricharan Kattamanchi Anadamoorthy
My understanding is that there's an ODBC driver for Hive. Below is an article that discusses working with Hive from C# using ODBC. Given this information, you could probably make use of the Data - ODBC VBO to connect to Hive if you have all the necessary connection details.
https://www.c-sharpcorner.com/article/query-apache-hive-with-c-sharp-and-odbc/
Cheers,