Facing error while fetching data from ODBC(HIVE)

[adityapv]

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.

[amitchandak]

@adityapv , 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