[jira] [Created] (HIVE-15198) Capitalisation of columns/aliases is lost in query results

["Michael O'Kane (JIRA)" <ji...@apache.org>]

Michael O'Kane created HIVE-15198:
-------------------------------------

             Summary: Capitalisation of columns/aliases is lost in query results
                 Key: HIVE-15198
                 URL: https://issues.apache.org/jira/browse/HIVE-15198
             Project: Hive
          Issue Type: Bug
            Reporter: Michael O'Kane


RDBMS systems, while generally case-insensitive, retain case information for table metadata, e.g. under postgres

{code}
root=# create table foo as select 1 as "FOO" from users;
SELECT 7
root=# select * from foo;
 FOO 
-----
1
1
...
{code}

Hive displays a deviation from this behaviour in that:
1) Persisted table metadata (i.e. from CREATE/ALTER) table is physically coerced to lower case upon writing to the DB
2) Transient metadata (i.e. column aliases) are displayed as lower case, regardless of the case provided by the query.

In hive:

{code}0: jdbc:hive2://localhost:10000/default> create table foo as select 1 as FOO from users;
...
0: jdbc:hive2://localhost:10000/default> select * from foo;
+----------+--+
| foo.foo  |
+----------+--+
| 1        |
| 1        |
...
0: jdbc:hive2://localhost:10000/default> select foo as FOO from foo;
+------+--+
| foo  |
+------+--+
| 1    |
| 1    |
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)