Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20458

hive-schema-3.1.0.postgres.sql - some tables are not quoted

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • Standalone Metastore, Transactions
    • None

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            ekoifman Eugene Koifman
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: