hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eugene Koifman (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20458) hive-schema-3.1.0.postgres.sql - some tables are not quoted
Date Fri, 24 Aug 2018 20:26:00 GMT

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

Mime
View raw message