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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.2, 2.4.0, 3.0.0
• Component/s: hpl/sql
• Assignee: Yibing Shi
• Reporter: Yibing Shi
• Created: 11/May/17 12:40
• Updated: 22/May/18 23:58
• Resolved: 12/May/17 13:04

Description

Create a table like below:

CREATE TABLE hive_bug(col1 string);

Run below query in Hive:

from hive_bug select transform(col1) using '/bin/cat' as (AAAA string);

The result would be:

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

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