Solved: Re: Error: Help with ODBC Cloudera connection

jasongkelly · ‎03-13-2020

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

v-xuding-msft · ‎03-15-2020

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.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-xuding-msft · ‎03-15-2020

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.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.