[HIVE-27091] Add double quotes for tables in PartitionProjectionEvaluator - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.0.0-beta-1
Component/s: Standalone Metastore
Labels:
- pull-request-available

Description

When PartitionProjectionEvaluator requests partitions against PostgreSQL, there throws exception:

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

Attachments

Issue Links

links to

GitHub Pull Request #4071

Activity

People

Assignee:: Zhihua Deng

Reporter:: Zhihua Deng

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 17/Feb/23 09:42

Updated:: 15/Aug/23 06:33

Resolved:: 02/Mar/23 03:39

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

0.5h