Store intermediate Query Result to variable in Beeline-Hive

ChineduLB — Mon, 16 Sep 2019 21:07:32 GMT

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

" --...

Re: Store intermediate Query Result to variable in Beeline-Hive

EricL — Mon, 16 Sep 2019 22:14:12 GMT

@ChineduLB

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

Cheers
Eric