You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2021/09/10 20:45:00 UTC

[jira] [Created] (HIVE-25515) Allow optional "AS" in column aliases in Values clause

Steve Carlin created HIVE-25515:
-----------------------------------

             Summary: Allow optional "AS" in column aliases in Values clause
                 Key: HIVE-25515
                 URL: https://issues.apache.org/jira/browse/HIVE-25515
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2
            Reporter: Steve Carlin


The following query does not work:
with v as (values (1 as x), (1), (1), (1), (1), (1), (1), (1), (1), (1)) 
select v.x from v, v v2, v v3, v v4, v v5, v v6;
...because of the "1 as x" clause.  The "as" should be allowed but optional.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)