Support Questions

Find answers, ask questions, and share your expertise

Store intermediate Query Result to variable in Beeline-Hive

avatar
Rising Star

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

" --...

1 ACCEPTED SOLUTION

avatar
Super Guru
@ChineduLB

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

Cheers
Eric

View solution in original post

1 REPLY 1

avatar
Super Guru
@ChineduLB

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

Cheers
Eric