CODEWITHSUNDEEP
aws-gluedatabase-partitioningamazon-athena
Danish
Danish

Reputation: 287

INVALID_TABLE_PROPERTY: For input string: "0-23" (property: projection.hour.digits) on Athena

Having error while running this query

Query on Athena

SELECT * FROM "db"."thermostat" 
where id='95686' 
and "date" = '2022/03/07'
AND hour =13

Projection Partition

Data located on this path: s3://bucket/dbname/tablename/id/date=2022/03/07/hour=13/

Error

INVALID_TABLE_PROPERTY: For input string: "0-23" (property: projection.hour.digits) (table db.thermostat)

Table Properties

 'projection.enabled' = 'true',
  'projection.id.type' = 'injected', 
  'projection.date.format' = 'yyyy/MM/dd', 
  'projection.date.interval' = '1', 
  'projection.date.interval.unit' = 'DAYS', 
  'projection.date.range' = '2019/11/27, NOW-1DAYS', 
  'projection.date.type' = 'date', 
  'projection.hour.type' = 'integer',
  'projection.hour.range' = '0-23',
  'projection.hour.digits' = '2',

Upvotes: 3

Views: 911

Answers (1)

Danish
Danish

Reputation: 287

I had written range 'projection.hour.range' = '0-23'

But it should have like this 'projection.hour.range' = '0,23'

Upvotes: 3

Related Questions