[ 
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)

Reply via email to