Forum Discussion
Error: Help with ODBC Cloudera connection
I am setting up an ODBC connection using the HIVE ODBC Driver 2.6.1. The connection test is successful. I can also view the database and all the tables. However, when I try to load the table into PowerBI, Excel or Access I get this error:
DataSource.Error: ODBC: ERROR [HY000] [Cloudera][Hardy] (35) Error from server: error code: '0' error message: 'MetaException(message:java.lang.NullPointerException)'.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=EDL
OdbcErrors=Table
Hi jasongkelly ,
Do you use the 64-bit and latest version of Power BI Desktop(2.79.5768.721) to connect to the data source? Please follow the guide in this document to connect to Hive data source by installing Microsoft Hive ODBC Driver and check if you get any errors.
2 Replies
- v-xuding-msftCommunity Support
Hi jasongkelly ,
Do you use the 64-bit and latest version of Power BI Desktop(2.79.5768.721) to connect to the data source? Please follow the guide in this document to connect to Hive data source by installing Microsoft Hive ODBC Driver and check if you get any errors.
- avinashtumuluNew Member
Where is the documentation for downloading the driver in MSDocs? Kindly point me to the documentation.