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.

Select Quesry ResultSet as named Data Set

Solved Go to solution
Highlighted

Select Quesry ResultSet as named Data Set

New Contributor

I want to have temporary data set from Hive Select statement, like we can have in SQL as In Below query, I can name result set to COL_VEH_TYPE in SQL.

(select CLAIMNUMBER,EXP_ID,EXP_COVERAGE,VEHICLE_STYLE From orc_claiminfo Where EXP_COVERAGE = "Collision") COL_VEH_TYPE

What it would be in Hive QL??

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Select Quesry ResultSet as named Data Set

@Mamta Chawla will Hive's CTE syntax help in your case? https://cwiki.apache.org/confluence/display/Hive/C...

2 REPLIES 2

Re: Select Quesry ResultSet as named Data Set

@Mamta Chawla will Hive's CTE syntax help in your case? https://cwiki.apache.org/confluence/display/Hive/C...

Re: Select Quesry ResultSet as named Data Set

New Contributor

Thanks Scott, I got it.

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