Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15583

CTAS query removes leading underscore from column names with CBO

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.0
    • Component/s: CBO
    • Labels:
      None
    • Target Version/s:

      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.

        Attachments

        1. HIVE-15583.patch
          0.9 kB
          Jesus Camacho Rodriguez
        2. HIVE-15583.01.patch
          116 kB
          Jesus Camacho Rodriguez

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: