由网友(爱而不得最心酸)分享简介:运行此查询时出错雅典娜查询SELECT * FROM "db"."thermostat" where id='95686' and "date" = '2022/03/07'AND hour =13投影分区位于此路径上的数据:S3://bucket/dbname/tablename/id/date=202...![教主之家定制版本 教主之家定制版下载v1.0 独家定制版 乐游网安卓下载](https://p.xsw88.cn/allimgs/daicuo/20230903/3668.png)
运行此查询时出错
雅典娜查询
SELECT * FROM "db"."thermostat"
where id='95686'
and "date" = '2022/03/07'
AND hour =13
![教主之家定制版本 教主之家定制版下载v1.0 独家定制版 乐游网安卓下载](https://p.xsw88.cn/allimgs/daicuo/20230903/3668.png)
投影分区
位于此路径上的数据: 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',
推荐答案
我写了范围
'projection.hour.range' = '0-23'
'projection.hour.range' = '0,23'
相关推荐
最新文章