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 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

Need Help

3 Replies

  • 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

  • DanielZS's avatar
    DanielZS
    New Member
    11 months ago

    Hello. Did you try the Zappysys ODBC Apache Hive connector?

    It is a third-party ODBC connector. It can connect to Apache Hive. Let me know if it works for you.