[hive] branch master updated: HIVE-26000: DirectSQL to pruning partitions fails with postgres backend for Skewed-Partition tables (Naresh PR via Zoltan and Naveen)

[ng...@apache.org]

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 9e19277  HIVE-26000: DirectSQL to pruning partitions fails with postgres backend for Skewed-Partition tables (Naresh PR via Zoltan and Naveen)
9e19277 is described below

commit 9e19277a66e58a9483705d3793620842a510d76c
Author: Naresh PR <pr...@gmail.com>
AuthorDate: Wed Mar 2 13:31:47 2022 -0800

    HIVE-26000: DirectSQL to pruning partitions fails with postgres backend for Skewed-Partition tables (Naresh PR via Zoltan and Naveen)
---
 .../java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java  | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java
index 72905ca..e26ea2e 100644
--- a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java
+++ b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java
@@ -399,7 +399,7 @@ class MetastoreDirectSqlUtils {
     String queryText;
     queryText =
           "select " + SKEWED_COL_VALUE_LOC_MAP + ".\"SD_ID\","
-        + " " + SKEWED_STRING_LIST_VALUES + ".STRING_LIST_ID,"
+        + " " + SKEWED_STRING_LIST_VALUES + ".\"STRING_LIST_ID\","
         + " " + SKEWED_COL_VALUE_LOC_MAP + ".\"LOCATION\","
         + " " + SKEWED_STRING_LIST_VALUES + ".\"STRING_LIST_VALUE\" "
         + "from " + SKEWED_COL_VALUE_LOC_MAP + ""