You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2023/02/17 09:47:00 UTC
[jira] [Updated] (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 ]
ASF GitHub Bot updated HIVE-27091:
----------------------------------
Labels: pull-request-available (was: )
> 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
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)