[
https://issues.apache.org/jira/browse/HIVE-27091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng resolved HIVE-27091.
--------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
> 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
> Fix For: 4.0.0
>
> Time Spent: 0.5h
> 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)
