[ https://issues.apache.org/jira/browse/HIVE-6669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14162457#comment-14162457 ]
Damien Carol commented on HIVE-6669: ------------------------------------ [~alangates] I think we should use char {{"}} like in the others upgrade scripts of the metastore. {code:sql} CREATE TABLE "BUCKETING_COLS" ( "SD_ID" bigint NOT NULL, "BUCKET_COL_NAME" character varying(256) DEFAULT NULL::character varying, "INTEGER_IDX" bigint NOT NULL ); {code} Link here https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.14.0.postgres.sql#L22 > sourcing txn-script from schema script results in failure for mysql & oracle > ---------------------------------------------------------------------------- > > Key: HIVE-6669 > URL: https://issues.apache.org/jira/browse/HIVE-6669 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.14.0 > Reporter: Prasad Mujumdar > Assignee: Alan Gates > Priority: Blocker > Attachments: HIVE-6669.patch > > > This issues is addressed in 0.13 by in-lining the the transaction schema > statements in the schema initialization script (HIVE-6559) > The 0.14 schema initialization is not fixed. This is the followup ticket for > to address the problem in 0.14. -- This message was sent by Atlassian JIRA (v6.3.4#6332)