[
https://issues.apache.org/jira/browse/HIVE-9208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14286066#comment-14286066
]
Eugene Koifman commented on HIVE-9208:
--------------------------------------
Most of the diffs change varchar(767) to nvarchar(767), but in some cases the
starting types are varchar(128) or varchar(4000). Are you sure these are
partition keys?
> 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-9208.2.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)
