Support Questions
Find answers, ask questions, and share your expertise

Select Quesry ResultSet as named Data Set

Solved Go to solution
Highlighted

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

Accepted Solutions
Highlighted

Re: Select Quesry ResultSet as named Data Set

2 REPLIES 2
Highlighted

Re: Select Quesry ResultSet as named Data Set

Re: Select Quesry ResultSet as named Data Set

Thanks Scott, I got it.

Don't have an account?