Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Facing error while fetching data from ODBC(HIVE)

Hi,Need help on this issue.

1.I am trying to get data from hive,for this i am using ODBC connector as source connector in POWER BI.

2.If it is directly fetching data from table then there is no issue on this in POWER BI.

3.But when i am using one query i.e having temporary tables.please refer below query.

HIVE:

create table if not exists TEMP1 as select * from Table1

select * from TEMP1

NOTE: Query is working fine in HIVE,in zeppline i have verified its working fine.but while using above query facing issue while fetching data from HIVE(ODBC) in power BI.

 

 

Please help me on this.

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I doubt you can run this from power bi.

    Power bi will run query for resultset I doubt this will work in that case

     

    Try if with works 

     

    With TEMP1 as ( select * from Table1)

    select * from TEMP1