[
https://issues.apache.org/jira/browse/HIVE-9208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14276063#comment-14276063
]
Eugene Koifman commented on HIVE-9208:
--------------------------------------
I think there are other places in the schema that have the same issue. This
needs to be made consistent for all tables. Unfortunately columns that seem to
store partition name are named differently in different tables.
some that look like potential candidates (but not an exhaustive list)
part_col_stats.partition_name
partition_events.partition_name
partition_keys.pkey_name
partition_params.param_value
> 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)
