[
https://issues.apache.org/jira/browse/HIVE-9208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiaobing Zhou updated HIVE-9208:
--------------------------------
Attachment: HIVE-9208.1.patch
Made a patch. [~ekoifman] can you have it reviewed, thanks!
> MetaStore DB schema inconsistent for MS SQL Server in use of varchar/nvarchar
> -----------------------------------------------------------------------------
>
> Key: HIVE-9208
> URL: https://issues.apache.org/jira/browse/HIVE-9208
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.14.0
> Reporter: Eugene Koifman
> Assignee: Xiaobing Zhou
> Attachments: HIVE-9208.1.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
