You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Zhihua Deng (Jira)" <ji...@apache.org> on 2023/02/17 09:43:00 UTC

[jira] [Created] (HIVE-27091) Add double quotes for tables in PartitionProjectionEvaluator

Zhihua Deng created HIVE-27091:
----------------------------------

             Summary: Add double quotes for tables in PartitionProjectionEvaluator
                 Key: HIVE-27091
                 URL: https://issues.apache.org/jira/browse/HIVE-27091
             Project: Hive
          Issue Type: Bug
          Components: Standalone Metastore
            Reporter: Zhihua Deng
            Assignee: Zhihua Deng


When PartitionProjectionEvaluator requests partitions against PostgreSQL, there throws exception:
{noformat}
javax.jdo.JDODataStoreException: Error executing SQL query "select "SDS"."LOCATION","PARTITIONS"."CREATE_TIME","SDS"."SD_ID","PARTITIONS"."PART_ID" from PARTITIONS left outer join SDS on PARTITIONS."SD_ID" = SDS."SD_ID"   left outer join SERDES on SDS."SERDE_ID" = SERDES."SERDE_ID" where "PART_ID" in (92731,92732,92733,92734,92735,92736) order by "PART_NAME" asc".
…
Caused by: org.postgresql.util.PSQLException: ERROR: relation "partitions" does not exist{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)