I created a table with partition projection
This is the setup:
PARTITIONED BY (
`userid` string,
`taskid` string,
`accountid` string,
`month` int,
`year` int)
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
's3://bucketName/'
TBLPROPERTIES (
'has_encrypted_data'='false',
'projection.accountid.type'='inject',
'projection.enabled'='true',
'projection.month.digits'='2',
'projection.month.range'='1,12',
'projection.month.type'='integer',
'projection.taskid.type'='inject',
'projection.userid.type'='inject',
'projection.year.range'='2018,2051',
'projection.year.type'='integer',
'storage.location.template'='s3://bucketName/userid=${userid}/taskid=${taskid}/accountid=${accountid}/month=${month}-${year}/',
activae query
where userid='626b4b4e-9518-46cd-a7af-0ebda24425bd' and taskid='6d45c163-d5f5-4a44-9aa5-f80e8f8152e4' and accountid = 'blabla-blabla@abc.com'
and "month" = 12 and "year" = 2020
got
GENERIC_INTERNAL_ERROR: No value present
query id - Query Id: de3b869c-6d1a-4b10-989f-be79356569a1
Any idea why?
Thanks