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

MetaStore DB schema inconsistent for MS SQL Server in use of varchar/nvarchar

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 0.14.0
    • None
    • Metastore
    • None

    Description

      hive-schema-0.15.0.mssql.sql has PARTITIONS.PART_NAME as NVARCHAR but COMPLETED_TXN_COMPONENTS.CTC_PARTITON, COMPACTION_QUEUE.CQ_PARTITION, HIVE_LOCKS.HL_PARTITION, TXN_COMPONENTS.TC_PARTITION all use VARCHAR. This cannot be right since they all store the same value.

      the same is true of hive-schema-0.14.0.mssql.sql and the two corresponding hvie-txn-schema-... files.

      Attachments

        1. HIVE-9208.1.patch
          5 kB
          Xiaobing Zhou
        2. HIVE-9208.2.patch
          6 kB
          Xiaobing Zhou

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-9456 Make Hive support unicode with MSSQL as Metastore backend

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-8550 Hive cannot load data into partitioned table with Unicode key

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              xiaobingo Xiaobing Zhou
              ekoifman Eugene Koifman
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: