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