question Re: Select Quesry ResultSet as named Data Set in Archives of Support Questions (Read Only)

Select Quesry ResultSet as named Data Set

colorsoflife — Thu, 17 Dec 2015 02:53:08 GMT

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

Re: Select Quesry ResultSet as named Data Set

SQLShaw — Thu, 17 Dec 2015 03:01:22 GMT

@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

colorsoflife — Thu, 17 Dec 2015 05:32:31 GMT

Thanks Scott, I got it.