Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Select Quesry ResultSet as named Data Set

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

2 REPLIES 2

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

Thanks Scott, I got it.