Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Store intermediate Query Result to variable in Beeline-Hive

Solved Go to solution
Highlighted

Store intermediate Query Result to variable in Beeline-Hive

Explorer

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

Accepted Solutions

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

Guru
@ChineduLB

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

Cheers
Eric
1 REPLY 1

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

Guru
@ChineduLB

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

Cheers
Eric
Don't have an account?
Coming from Hortonworks? Activate your account here