[jira] [Updated] (HIVE-20458) hive-schema-3.1.0.postgres.sql - some tables are not quoted

["Eugene Koifman (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-20458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eugene Koifman updated HIVE-20458:
----------------------------------
    Description: 
a number of tables related to transactional metadata are not quoted in this script:

COMPACTION_QUEUE, HIVE_LOCKS, etc

this causes Postgres to create the tables in lower case.  The table creation scripts should follow the same convention as other tables.  Changing this would require an upgrade script to change existing tables

hive-schema...mysql.sql also doesn't quote Create Table for acid meta tables


  was:
a number of tables related to transactional metadata are not quoted in this script:

COMPACTION_QUEUE, HIVE_LOCKS, etc

this causes Postgres to create the tables in lower case.  The table creation scripts should follow the same convention as other tables.

hive-schema...mysql.sql also doesn't quote Create Table for acid meta tables



> hive-schema-3.1.0.postgres.sql - some tables are not quoted
> -----------------------------------------------------------
>
>                 Key: HIVE-20458
>                 URL: https://issues.apache.org/jira/browse/HIVE-20458
>             Project: Hive
>          Issue Type: Improvement
>          Components: Standalone Metastore, Transactions
>    Affects Versions: 3.0.0
>            Reporter: Eugene Koifman
>            Priority: Major
>
> a number of tables related to transactional metadata are not quoted in this script:
> COMPACTION_QUEUE, HIVE_LOCKS, etc
> this causes Postgres to create the tables in lower case.  The table creation scripts should follow the same convention as other tables.  Changing this would require an upgrade script to change existing tables
> hive-schema...mysql.sql also doesn't quote Create Table for acid meta tables



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)