INVALID_TABLE_PROPERTY：对于雅典娜上的输入字符串：&quot；0-23&quot；(Property：projection.hour.digits)雅典娜、字符串

2023-09-03 12:30:44 作者：爱而不得最心酸

运行此查询时出错

雅典娜查询

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

投影分区

位于此路径上的数据： S3://bucket/dbname/tablename/id/date=2022/03/07/hour=13/

错误

INVALID_TABLE_PROPERTY：输入字符串：0-23&qot；(Property：projection.hour.digits)(表数据库恒温器)

表属性

 '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',

INVALID_TABLE_PROPERTY：对于雅典娜上的输入字符串：&quot；0-23&quot；(Property：projection.hour.digits)雅典娜、字符串

推荐答案