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

Supporting Quoted Identifiers in Column Names

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Incompatible change
    • Release Note:
      Hide
      The default behavior for quoted identifiers has been changed. Now at the language level any Column Name that is specified within back-ticks(`) is treated literally. This is inline with standard sql behavior for quoted identifiers. Within back-tick strings use double back-ticks to escape.

      To revert to old behavior(that of interpreting back-ticked names as regular expressions) use the new parameter: hive.support.quoted.identifiers; set to the value 'none'.
      Show
      The default behavior for quoted identifiers has been changed. Now at the language level any Column Name that is specified within back-ticks(`) is treated literally. This is inline with standard sql behavior for quoted identifiers. Within back-tick strings use double back-ticks to escape. To revert to old behavior(that of interpreting back-ticked names as regular expressions) use the new parameter: hive.support.quoted.identifiers; set to the value 'none'.

      Description

      Hive's current behavior on Quoted Identifiers is different from the normal interpretation. Quoted Identifier (using backticks) has a special interpretation for Select expressions(as Regular Expressions). Have documented current behavior and proposed a solution in attached doc.

      Summary of solution is:

      • Introduce 'standard' quoted identifiers for columns only.
      • At the langauage level this is turned on by a flag.
      • At the metadata level we relax the constraint on column names.

        Attachments

        1. HIVE-6013.1.patch
          99 kB
          Harish Butani
        2. HIVE-6013.2.patch
          102 kB
          Harish Butani
        3. HIVE-6013.3.patch
          101 kB
          Harish Butani
        4. HIVE-6013.4.patch
          102 kB
          Harish Butani
        5. HIVE-6013.5.patch
          102 kB
          Harish Butani
        6. HIVE-6013.6.patch
          105 kB
          Harish Butani
        7. HIVE-6013.7.patch
          123 kB
          Harish Butani
        8. QuotedIdentifier.html
          20 kB
          Harish Butani

          Issue Links

            Activity

              People

              • Assignee:
                rhbutani Harish Butani
                Reporter:
                rhbutani Harish Butani
              • Votes:
                0 Vote for this issue
                Watchers:
                11 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: