[
https://issues.apache.org/jira/browse/HIVE-24633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa updated HIVE-24633:
----------------------------------
Description:
{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}
was:
{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}
> 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
>
> {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)
