You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Yibing Shi (JIRA)" <ji...@apache.org> on 2017/05/11 12:41:04 UTC

[jira] [Created] (HIVE-16646) Alias in transform ... as clause shouldn't be case sensitive

Yibing Shi created HIVE-16646:
---------------------------------

             Summary: Alias in transform ... as clause shouldn't be case sensitive
                 Key: HIVE-16646
                 URL: https://issues.apache.org/jira/browse/HIVE-16646
             Project: Hive
          Issue Type: Bug
          Components: hpl/sql
            Reporter: Yibing Shi


Create a table like below:
{code:sql}
CREATE TABLE hive_bug(col1 string);
{code}

Run below query in Hive:
{code}
from hive_bug select transform(col1) using '/bin/cat' as (AAAA string);
{code}

The result would be:
{noformat}
0: jdbc:hive2://localhost:10000> from hive_bug select transform(col1) using '/bin/cat' as (AAAA string);
......
INFO  : OK
+-------+--+
| AAAA  |
+-------+--+
+-------+--+
{noformat}

The output column name is *AAAA* instead of the lowercase aaaa.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)