You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ng...@apache.org on 2022/07/15 00:31:35 UTC
[hive] branch master updated: HIVE-26390: TxnHandler.getTxnDbsUpdated() SQL syntax error on Postgres. (#3437)
This is an automated email from the ASF dual-hosted git repository.
ngangam pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new b51dcfe87b8 HIVE-26390: TxnHandler.getTxnDbsUpdated() SQL syntax error on Postgres. (#3437)
b51dcfe87b8 is described below
commit b51dcfe87b8ab85cc756622c672aeda61060fe90
Author: cmunkey <49...@users.noreply.github.com>
AuthorDate: Thu Jul 14 17:31:24 2022 -0700
HIVE-26390: TxnHandler.getTxnDbsUpdated() SQL syntax error on Postgres. (#3437)
The column name "T2W_DATABASE" needs to be quoted.
Co-authored-by: Francis Pang <fp...@cloudera.com>
---
.../src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
index dec309243d6..9e270fc731d 100644
--- a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
+++ b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
@@ -1682,7 +1682,7 @@ abstract class TxnHandler implements TxnStore, TxnStore.MutexAPI {
try {
try (Statement stmt = dbConn.createStatement()) {
- String query = "SELECT DISTINCT T2W_DATABASE " +
+ String query = "SELECT DISTINCT \"T2W_DATABASE\" " +
" FROM \"TXN_TO_WRITE_ID\" \"COMMITTED\"" +
" WHERE \"T2W_TXNID\" = " + txnId;