[
https://issues.apache.org/jira/browse/HIVE-24633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-24633:
----------------------------------
Labels: pull-request-available (was: )
> Support CTE with column labels
> ------------------------------
>
> Key: HIVE-24633
> URL: https://issues.apache.org/jira/browse/HIVE-24633
> Project: Hive
> Issue Type: Improvement
> Components: Parser
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {code}
> with cte1(a, b) as (select int_col x, bigint_col y from t1)
> select a, b from cte1{code}
> {code}
> a b
> 1 2
> 3 4
> {code}
> {code}
> <query expression> ::=
> [ <with clause> ] <query expression body>
> [ <order by clause> ] [ <result offset clause> ] [ <fetch first clause> ]
> <with clause> ::=
> WITH [ RECURSIVE ] <with list>
> <with list> ::=
> <with list element> [ { <comma> <with list element> }... ]
> <with list element> ::=
> <query name> [ <left paren> <with column list> <right paren> ]
> AS <table subquery> [ <search or cycle clause> ]
> <with column list> ::=
> <column name list>
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
