I am getting the following error when querying a partitioned table.
select * from cdqwms where date between '2024-01-01' and '2024-01-02'
INVALID_TABLE_PROPERTY: Must provide a comma-separated enumeration to build a projected enum partition column! (property: projection.env.values)
CREATE EXTERNAL TABLE cdqwms(
completeness decimal(38,18) COMMENT 'from deserializer',
consistency decimal(38,18) COMMENT 'from deserializer',
currency decimal(38,18) COMMENT 'from deserializer',
publication_event_id string COMMENT 'from deserializer',
uniqueness decimal(38,18) COMMENT 'from deserializer')
PARTITIONED BY (
env string COMMENT 'The environment of the source of the cdq output',
date string COMMENT 'The date, yyyy-MM-dd, of the cdqwms output')
ROW FORMAT SERDE
'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
'case.insensitive'='TRUE',
'dots.in.keys'='FALSE',
'ignore.malformed.json'='TRUE')
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
's3://x/x/x/'
TBLPROPERTIES (
'classification'='json',
'projection.date.format'='yyyy-MM-dd',
'projection.date.interval'='1',
'projection.date.interval.unit'='DAYS',
'projection.date.range'='2024-03-05,NOW+1DAY',
'projection.date.type'='date',
'projection.enabled'='true',
'projection.env.type'='enum',
'projection.env.values'='',
'storage.location.template'='s3://x/x/x/env=${env}/date=${date}/',
'typeofdata'='file')