[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-22546: -- Fix Version/s: 4.0.0 Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master. Thanks for the patch [~zchovan]! > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, > HIVE-22546.3.patch, HIVE-22546.4.patch, HIVE-22546.5.patch, > HIVE-22546.6.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.6.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, > HIVE-22546.3.patch, HIVE-22546.4.patch, HIVE-22546.5.patch, > HIVE-22546.6.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.5.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, > HIVE-22546.3.patch, HIVE-22546.4.patch, HIVE-22546.5.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.3.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, > HIVE-22546.3.patch, HIVE-22546.4.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.4.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, > HIVE-22546.4.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.3.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.2.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.2.patch, HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Component/s: Database/Schema > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug > Components: Database/Schema >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Affects Version/s: 4.0.0 Status: Patch Available (was: Open) > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug >Affects Versions: 4.0.0 >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
[ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zoltan Chovan updated HIVE-22546: - Attachment: HIVE-22546.patch > Postgres schema not using quoted identifiers for certain tables > --- > > Key: HIVE-22546 > URL: https://issues.apache.org/jira/browse/HIVE-22546 > Project: Hive > Issue Type: Bug >Reporter: Zoltan Chovan >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22546.patch > > > In the latest postgresql schema > (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql) > the following tables have lowercase table and column names: > {code:java} > aux_table > compaction_queue > completed_compactions > completed_txn_components > hive_locks > materialization_rebuild_locks > min_history_level > next_compaction_queue_id > next_lock_id > next_txn_id > next_write_id > repl_txn_map > runtime_stats > txn_components > txn_to_write_id > txns > write_set{code} > As these tables are referenced from the Hive sys database, the queries to > these tables will fail with a "Table not found" error. > The problem is that the table and column names are not enclosed in quotes, so > postgres will turn these identifiers into lowercase. > -- This message was sent by Atlassian Jira (v8.3.4#803005)