How to use hive #temp table and insert statement in qlik

[Qlik1_User1]

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;

[Taoufiq_Zarra]

@Qlik1_User1  do you mean Resident Table, like :

SQLTABLE:
select * from ...

TmpTable:
noconcatenate

load .. resident SQLTABLE;

drop table SQLTABLE; // if you want
...

[Qlik1_User1]

@Taoufiq_Zarra No, want to create Hive temp table in Qlik..

[Taoufiq_Zarra]

TmpTable:
noconcatenate

load .. resident SQLTABLE;

drop table SQLTABLE; // if you want

TmpTable is a temp table that you can deleted after

[Qlik1_User1]

@Taoufiq_Zarra further manipulation , updation and multiple joins are required so that's why need to create hive temp table.

[Taoufiq_Zarra]

@Qlik1_User1  can you share a sample data and elaborate

[Qlik1_User1]

@Taoufiq_Zarra Like this

CONNECT ...

// create temp table (no data returned)

SQL

SELECT * into #temp

FROM mytable;

[Kushal_Chawda]

@Qlik1_User1  do you want to create temp table in Hive from Qlik?

[Qlik1_User1]

@Kushal_Chawda 

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.

[Kushal_Chawda · Accepted solution]

@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