cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abhi1488 Frequent Visitor
Frequent Visitor

Unable to load Hive tables in PowerBI

 

Hi,

 

I am trying to connect Power BI with Hive table; for this I am using 64 bit MapR ODBC driver. I have created the DSN on my system and it test successfully. However when I try to connect hive; it connect successfully but once I select a table to load it throws folllowing error:

 

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

Details:

    DataSourceKind=Odbc

    DataSourcePath=dsn=<DSN NAME>

    OdbcErrors=Table

 

With the same dsn, I am able to load the data in Tableau and Teradata Sql Assistant. Moreover, if I define my query (SELECT * FROM TABLE) in the advance option then I am able to load data from hive in Power BI.

 

Any idea what might be the reason behind such behaviour

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
abhi1488 Frequent Visitor
Frequent Visitor

Re: Unable to load Hive tables in PowerBI

Thanks,

 

I downgraded my MapR Hive driver to 2.15 version and it worked successfully.

View solution in original post

3 REPLIES 3
abhi1488 Frequent Visitor
Frequent Visitor

Re: Unable to load Hive tables in PowerBI

Any help on this??

Moderator v-yuezhe-msft
Moderator

Re: Unable to load Hive tables in PowerBI

@abhi1488,

Do you use the 64-bit and latest version of Power BI Desktop(2.50.4859.502) to connect to the data source? Please follow the guide in this blog to connect to Hive data source by installing Microsoft Hive ODBC Driver and check if you get any errors.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
abhi1488 Frequent Visitor
Frequent Visitor

Re: Unable to load Hive tables in PowerBI

Thanks,

 

I downgraded my MapR Hive driver to 2.15 version and it worked successfully.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 6 members 2,935 guests
Please welcome our newest community members: