Hive Connection - Direct Query

[pritee_more]

 Hello,

I need to connect to Hive with Direct Query. Currently I am using Hortonworks Hive ODBC Driver for connection, However only Import option is availble and Direct Query oprion is not availble with this method.

Is there any other way to connect to Hive using Direct Query(Live Connection) ?

Any suggestions/pointers will be really helpful.

Thank you.

[Anonymous]

Hi @pritee_more,

ODBC connector not support live connect modes.(live connection and direct query)
You can submit this requirement to ideas forum.

Regards,

XIaoxin Sheng

[pritee_more]

Hi @Anonymous,

Thank you for your quick responce. Yes, ODBC Connector does not support Direct Query. But is there any other way to connect to Hive with Live connection(Direct Query) ?

I tried using "HDInsights Interactive Query(Beta)", but it is not working (may be this is not suitable connection type)

So, is there any other connection method for Hive Live connection ?

Thank you.

[Anonymous]

HI @pritee_more,

Below link told about which type of datasource support in directquery mode.

Data sources supported by DirectQuery in Power BI

Obviously odbc connector not support live mode, maybe you can try to use odbc to create report and publish to power bi service.

Then get date from power bi service, it will switch to live mode.(not the real live connection, it update records until records are same as dataset which cached in power bi service, follow original report's refresh plan) 

Regards,

Xiaoxin Sheng

[pritee_more]

hi @Anonymous,

Thank you for the link, it is helpful.

In your solution -

 "you can try to use odbc to create report and publish to power bi service.

Then get date from power bi service, it will switch to live mode.(not the real live connection, it update records until records are same as dataset which cached in power bi service, follow original report's refresh plan)"

Here, we will need to schedule the data refresh for dataset, right?

So, report will refresh only cached data in power bi. For new data we first need to refresh the dataset (using manual or scheduled refresh) and then only we can get latest data(on report) from database? Is this what your saying?

Thank you,

Pritee More

[Anonymous]

Hi @pritee_more,

Yes, when you use live connection to power bi service. It will update to date records based on datasets who cached in power bi service.

BTW, you can also submit an idea about live mode for hive datasource.

Notice: above live mode means live connect power bi service, not means live connection to database.

Regards,

Xiaoxin Sheng

[pritee_more]

Hello,

Is there possible to connect to Hive with Direct Query connection.

Currently I am using Hortnworks Hive ODBC Driver to connect and only Import option is availble. Direct Query is not availble.

Is there any other way to connect to Hive using Direct Query(Live Connection)

Any help or pointer will be appreciated.

Thank You.