Athena - GENERIC_INTERNAL_ERROR: No value present

0

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

asked 2 years ago98 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions