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

Supporting Quoted Identifiers in Column Names

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Reopened
    • Major
    • Resolution: Unresolved
    • None
    • 0.13.0
    • Query Processor
    • None
    • Incompatible change
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            rhbutani Harish Butani Assign to me
            rhbutani Harish Butani

            Dates

              Created:
              Updated:

              Slack

                Issue deployment