Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Select Quesry ResultSet as named Data Set

avatar
Rising Star

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

avatar
2 REPLIES 2

avatar

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

avatar
Rising Star

Thanks Scott, I got it.