Forum Discussion

karthee's avatar
karthee
New Member
8 years ago

Not able to connect Hive tables-ODBC error

Hi,   I am trying to connect PowerBI Desktop 64 Bit(2.60) with Hive database.I am using 64 bit MapR ODBC connector(2.1.5). I have created the DSN on my system and it tested successfully.when I try ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi karthee,

 

Since you used MapR Hive driver 2.15 version, please make sure there is no any other version installed on your machine. If there is, please uninstall other versions completedly.

 

Besides, please test connection to ODBC driver using UDL file. Here is an example. If connection works fine in  UDL file, please copy the generated connection string and use it connect to Hive data soucre in Power BI desktop. If issue persists, you'd better contact the MapR Driver support team for further analysis.

 

Regards,

Yuliana Gu

karthee's avatar
karthee
New Member
8 years ago

Hi Yuliana Gu,

 

Thanks for the support.

 

I tried all your suggestions, but nothing helped me, after this i tried with Hortonworks ODBC driver(2.1.12), with this ODBC i had a successful connection with the Hive, it's populating all the schema and the tables in it, but i can't load any table from it,it throws this exception:

 

DataSource.Error: ODBC: ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'MetaException(message:java.lang.NullPointerException)'.

Details: DataSourceKind=Odbc

DataSourcePath=dsn=Hive_Horton

OdbcErrors=Table 

 

I have already logged the ticket with MapR.

 

If you have any suggestions please let me know.

 

Thanks,

Karthi