You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "ccliushou (via GitHub)" <gi...@apache.org> on 2023/07/22 00:19:17 UTC
[GitHub] [iotdb] ccliushou opened a new issue, #10650: 条件分组查询存在错误[Bug]
ccliushou opened a new issue, #10650:
URL: https://github.com/apache/iotdb/issues/10650
### Search before asking
- [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.
### Version
version 1.1.1 (Build: d123b8e-dev)
### Describe the bug and provide the minimal reproduce step
执行：
SELECT __endTime, MIN_TIME(920A3.err.工单异常.输送1) as __startTime,
MIN_VALUE(920A3.err.工单异常.输送1) as min,
MAX_VALUE(920A3.err.工单异常.输送1) as max
FROM root.rczz
where Time >= 2023-06-09T00:00:00 and Time <=2023-06-12T00:00:00
group by condition(920A3.err.工单异常.输送1 > 0, KEEP >= 2, ignoreNull = true)
服务端报错：
日志文件：
[log_datanode_all.zip](https://github.com/apache/iotdb/files/12135236/log_datanode_all.zip)
数据文件（tools/export-tsfile.sh -h 192.168.68.128 -p 6667 -u root -pw root -td /iotdb/logs/export_tsfile -q "select * from root.rczz.920A3.err.工单异常 where Time >= 2023-06-09T00:00:00 and Time <=2023-06-12T00:00:00 "）
[export_tsfile.zip](https://github.com/apache/iotdb/files/12135237/export_tsfile.zip)
### What did you expect to see?
得到正常的查询结果
### What did you see instead?
### Anything else?
_No response_
### Are you willing to submit a PR?
- [ ] I'm willing to submit a PR!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] ccliushou closed issue #10650: 条件分组查询存在错误[Bug]
Posted by "ccliushou (via GitHub)" <gi...@apache.org>.
ccliushou closed issue #10650: 条件分组查询存在错误[Bug]
URL: https://github.com/apache/iotdb/issues/10650
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] ccliushou commented on issue #10650: 条件分组查询存在错误[Bug]
Posted by "ccliushou (via GitHub)" <gi...@apache.org>.
ccliushou commented on issue #10650:
URL: https://github.com/apache/iotdb/issues/10650#issuecomment-1646362137
找到原因了：因为之前往lib目录拷贝了 rewrite-tsfile-tool-1.0.1-SNAPSHOT 和 iotdb-antlr-1.0.1-SNAPSHOT 这两个文件。删除后就ok了。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org