Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

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