-
Notifications
You must be signed in to change notification settings - Fork 4.8k
-
Notifications
You must be signed in to change notification settings - Fork 4.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
3.3.2.0 Community聚合运算出问题 #27662
Labels
Comments
YukiYlf
added
help wanted
Extra attention is needed
question
Further information is requested
labels
Sep 4, 2024
select time , min(cast(pressure as float)) as min_pr, min(cast(pressure as float)) as min_pr1, num from iot.device_property_20015 where time >= '2024-08-30' and time < '2024-09-04' partition by num interval(10m) FILL(none) limit 100 奇怪是,只能做一个,比如最大,或者最小,或者平均 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
select
time ,
min(cast(pressure as float)) as min_pr,
num
from iot.device_property_20015 where time >= '2024-08-30' and time < '2024-09-04'
partition by num interval(10m) FILL(none)
limit 100
正确的
改成
select
time ,
min(cast(pressure as float)) as min_pr,
max(cast(pressure as float)) as max_pr,
num
from iot.device_property_20015 where time >= '2024-08-30' and time < '2024-09-04'
partition by num interval(10m) FILL(none)
limit 100
错误:
] 错误: Internal error:
Invalid usage of expr: time
全部: 19msThe text was updated successfully, but these errors were encountered: