Skip to main content
ChineduLB
Silver ⭐️⭐️⭐️
September 16, 2019
Solved

Store intermediate Query Result to variable in Beeline-Hive

Is there a way to store intermediate query results in Beeline - Hive

something like below in pseudo code. within a beeline session

beeline -u  -e"

 set var1 = select max(date) from tableA;

 set var2 = select count(emps) from tableB;

set var3 = select min(date) from tableC;

Insert into table TableD select var1, var2, var2

" --...

EricL
EricLAnswer
Platinum ⭐️⭐️
September 16, 2019
@ChineduLB

No you can't, you can only save data into temp tables, or simply use sub-query instead.

Cheers
Eric

1 reply

EricL
Platinum ⭐️⭐️
EricLAnswer
Platinum ⭐️⭐️
September 16, 2019
@ChineduLB

No you can't, you can only save data into temp tables, or simply use sub-query instead.

Cheers
Eric
Translate