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

TBLPROPERTIES does not allow empty string values when Metastore is backed by Oracle database.

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.0.0
    • Component/s: Metastore
    • Labels:
      None

      Description

      DDL commands like:

      ALTER TABLE test SET TBLPROPERTIES('serialization.null.format'='');

      are silently ignored if the database backing Metastore is Oracle. This appears to be because Oracle treats an empty string as null.

      Unlike when using MySql, no entry is created in the TBL_PARAMS table.

      Steps to reproduce:
      Create a table with a string field.
      eg table mytable, field mystringfield.
      ALTER TABLE mytable SET TBLPROPERTIES('serialization.null.format'='');
      DESCRIBE FORMATTED mytable;

      with mysql backed Metastore, the entry will be displayed:
      serialization.null.format
      and an entry is created in the TBL_PARAMS for the parameter.

      With Oracle backed metastore, it is not, and no entry is created in TBL_PARAMS.

        Attachments

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment