Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Store intermediate Query Result to variable in Beeline-Hive

avatar
Contributor

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