Vineet Garg created HIVE-23147:
----------------------------------
Summary: get_partitions_with_sepcs fail for POSTGRES
Key: HIVE-23147
URL: https://issues.apache.org/jira/browse/HIVE-23147
Project: Hive
Issue Type: Sub-task
Affects Versions: 4.0.0
Reporter: Vineet Garg
Query to fetch partition related data looks like following:
{code:sql}
SELECT "sds"."output_format",
"serdes"."name",
"serdes"."slib",
"sds"."location",
"sds"."input_format",
"sds"."num_buckets",
"sds"."is_compressed",
"serdes"."serde_id",
"sds"."cd_id",
"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........
{code}
This fails for postgres because table references are not quoted.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
