You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zhihua Deng (Jira)" <ji...@apache.org> on 2023/02/17 09:43:00 UTC
[jira] [Assigned] (HIVE-27091) Add double quotes for tables in PartitionProjectionEvaluator
[ https://issues.apache.org/jira/browse/HIVE-27091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhihua Deng reassigned HIVE-27091:
----------------------------------
> 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
> Priority: Major
>
> 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)