[HIVE-15583] CTAS query removes leading underscore from column names with CBO

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.2.0
• Component/s: CBO
• Target Version/s: 2.2.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 11/Jan/17 13:43
• Updated: 27/Feb/24 22:23
• Resolved: 14/Jan/17 10:22

Description

L209 in PlanModifierForASTConv.java:

      if (colAlias.startsWith("_")) {
        colAlias = colAlias.substring(1);
        colAlias = getNewColAlias(newSelAliases, colAlias);
      }

I would like to explore if we can just remove this limitation.

For instance, due to this issue, when we create a table with Druid storage handler, we need to add an additional underscore for column names as Druid is expecting columns with a certain name.

Issue Links

• is related to: HIVE-12029 CTAS query can not use `_c` in the prefix of the column alias