Not able to connect Hive tables-ODBC error

[karthee]

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 to connect hive, it connect successfully but once I select a table or DSN to load it throws the folllowing error:

DataSource.Error: ODBC: ERROR [HY000] [MapR][HiveODBC] (35) Error from Hive: error code: '0' error message: 'MetaException(message:Got exception: org.apache.thrift.transport.TTransportException null)'.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=Hive
OdbcErrors=Table

But if I define my query (SELECT * FROM TABLE) in the advance option(SQL Statement) then I am able to load data from hive in PowerBI.

I tried with latest Microsoft ODBC driver and MapR Hive ODBC connector.

Please help me to sort this out.

Thanks,

karthee

[v-yulgu-msft]

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]

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