Select Quesry ResultSet as named Data Set

[#1]

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??

[#2 · Accepted solution]

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

[#3]

Thanks Scott, I got it.