INVALID_TABLE_PROPERTY：对于输入字符串：“0-23” （属性：projection.hour.digits）在 Athena 上
运行此查询时出错
在 Athena 上查询
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”（属性：projection.hour.digits）（表 db.恒温器）
表属性
'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',
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',
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我写了范围
'projection.hour.range' = '0-23'但它应该是这样的
'projection.hour.range' = '0,23'I had written range
'projection.hour.range' = '0-23'But it should have like this
'projection.hour.range' = '0,23'