Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How can we create a temp table in Qlik (DB source is hive) , below code is not working.
Please suggest.
SQL
SELECT * into #temp
FROM mytable;
@Qlik1_User1 why do you want to create it from Qlik sense? You can just write hive scripts to create temp table and read that temp table in Qlik sense
@Qlik1_User1 do you mean Resident Table, like :
SQLTABLE:
select * from ...
TmpTable:
noconcatenate
load .. resident SQLTABLE;
drop table SQLTABLE; // if you want
...
@Taoufiq_Zarra No, want to create Hive temp table in Qlik..
TmpTable:
noconcatenate
load .. resident SQLTABLE;
drop table SQLTABLE; // if you want
TmpTable is a temp table that you can deleted after
@Taoufiq_Zarra further manipulation , updation and multiple joins are required so that's why need to create hive temp table.
@Qlik1_User1 can you share a sample data and elaborate
@Taoufiq_Zarra Like this
CONNECT ...
// create temp table (no data returned)
SQL
SELECT * into #temp
FROM mytable;
@Qlik1_User1 do you want to create temp table in Hive from Qlik?
So my requirement is to create a temp Hive table from original hive table and make updation in temp table and further use temp table in Qlik load scripts.
All things needs to be done in Qliksense.
Like below
But its not working.
@Qlik1_User1 why do you want to create it from Qlik sense? You can just write hive scripts to create temp table and read that temp table in Qlik sense