[HIVE-12029] CTAS query can not use `_c` in the prefix of the column alias

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 04/Oct/15 23:45
• Updated: 27/Feb/24 22:24

Description

The inconsistency sounds like a bug

hive> create table t as select key as `_k1` from src;
hive> desc t;
OK
_k1                 string
Time taken: 0.037 seconds, Fetched: 1 row(s)

hive> create table t as select key as `_c1` from src;
hive> desc t;
OK
key                 string
Time taken: 0.031 seconds, Fetched: 1 row(s)

Issue Links

• relates to: HIVE-15583 CTAS query removes leading underscore from column names with CBO