You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/11/03 07:34:09 UTC
[GitHub] [iotdb] SimonSimCity opened a new issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
SimonSimCity opened a new issue #4311:
URL: https://github.com/apache/iotdb/issues/4311
**Describe the bug**
When combining an aggregate query with nested expressions, I get an error - e.g.:
```
Msg: 401: Error occurred while parsing SQL to physical plan: line 1:39 mismatched input '+' expecting {'*', '.', ')'}
```
Or:
```
Msg: 401: Error occurred while parsing SQL to physical plan: line 1:7 extraneous input '(' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, INTO, SET, WHERE, FROM, TO, BY, DEVICE, CONFIGURATION, DESCRIBE, SLIMIT, LIMIT, UNLINK, OFFSET, SOFFSET, FILL, LINEAR, PREVIOUS, PREVIOUSUNTILLAST, METADATA, TIMESERIES, TIMESTAMP, PROPERTY, WITH, DATATYPE, COMPRESSOR, STORAGE, GROUP, LABEL, INT32, INT64, FLOAT, DOUBLE, BOOLEAN, TEXT, PLAIN, PLAIN_DICTIONARY, RLE, DIFF, TS_2DIFF, GORILLA, REGULAR, ADD, UPSERT, VALUES, NOW, LINK, INDEX, USING, TRACING, ON, OFF, SYSTEM, READONLY, WRITABLE, DROP, MERGE, LIST, USER, PRIVILEGES, ROLE, ALL, OF, ALTER, PASSWORD, REVOKE, LOAD, WATERMARK_EMBEDDING, UNSET, TTL, FLUSH, TASK, INFO, VERSION, REMOVE, MOVE, CHILD, PATHS, DEVICES, COUNT, NODES, LEVEL, MIN_TIME, MAX_TIME, MIN_VALUE, MAX_VALUE, AVG, FIRST_VALUE, SUM, LAST_VALUE, LAST, DISABLE, ALIGN, COMPRESSION, TIME, ATTRIBUTES, TAGS, RENAME, GLOBAL, FULL, CLEAR, CACHE, TRUE, FALSE, UNCOMPRESSE
D, SNAPPY, GZIP, LZ4, PARTITION, SNAPSHOT, FOR, SCHEMA, DESC, ASC, TOP, '*', OPERATOR_IN, '-', '[', INT, EXPONENT, DURATION, DATETIME, ID, DOUBLE_QUOTE_STRING_LITERAL, SINGLE_QUOTE_STRING_LITERAL}
```
**To Reproduce**
Steps to reproduce the behavior:
1. Add some timelines with data
2. Run a query combining an aggregate query with nested expressions
4. See error
**Expected behavior**
A result should be given containing the calculated values.
**Desktop (please complete the following information):**
- OS: Linux
- Browser n\a
- Version 0.12.2
**Additional context**
I have more than 3 time series with data from `2021-10-18` until today where I ran the following queries:
```
SELECT avg(mp3.1_0_31_7_0.temperature) + avg(mp4.1_0_31_7_0.temperature), avg(mp5.1_0_31_7_0.temperature) from root.test WHERE (time > 2021-11-01T00:05:00.000 and time < 2021-11-01T00:06:00.000) group by ([2021-11-01T00:05:00.000, 2021-11-01T00:06:10.000),1s)
SELECT (avg(mp3.1_0_31_7_0.temperature) + avg(mp4.1_0_31_7_0.temperature)), avg(mp5.1_0_31_7_0.temperature) from root.test WHERE (time > 2021-11-01T00:05:00.000 and time < 2021-11-01T00:06:00.000) group by ([2021-11-01T00:05:00.000, 2021-11-01T00:06:10.000),1s)
```
If there's anything I missed, please let me know. I want to use these queries as continuous query. If there's something I should keep in mind for that, I would appreciate if you'd let me know.
--
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] SteveYurongSu edited a comment on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu edited a comment on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
@SimonSimCity Thanks for reporting this!
In the 0.12.x / master versions, we have not supported the arithmetic operations of the aggregation queries.
The feature is already in development and will be released in 0.13.x, please stay tuned!
--
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] SteveYurongSu commented on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu commented on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
--
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] SteveYurongSu edited a comment on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu edited a comment on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
@SimonSimCity Thanks for reporting this!
In the 0.12.x / master versions, we have not supported the arithmetic operations of the aggregation queries.
The feature is already in development and will be released in 0.13.x, please stay tuned!
--
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] SteveYurongSu commented on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu commented on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
Thanks for reporting this!
In the 0.12.x / master versions, we have not supported the arithmetic operations of the aggregation queries.
The feature is already in development and will be released in 0.13.x, please stay tuned!
--
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] SteveYurongSu edited a comment on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu edited a comment on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
@SimonSimCity Thanks for reporting this!
In the 0.12.x / master versions, we have not supported the arithmetic operations of the aggregation queries.
The feature is already in development and will be released in 0.13.x, please stay tuned!
--
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] SteveYurongSu edited a comment on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu edited a comment on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
@SimonSimCity Thanks for reporting this!
In the 0.12.x / master versions, we have not supported the arithmetic operations of the aggregation queries.
The feature is already in development and will be released in 0.13.x, please stay tuned!
--
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] SteveYurongSu commented on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu commented on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-958838717
Thanks for reporting this!
In the 0.12.x / master versions, we have not supported the arithmetic operations of the aggregation queries.
The feature is already in development and will be released in 0.13.x, please stay tuned!
--
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] SimonSimCity commented on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SimonSimCity commented on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-960720166
Looks like the implementation for this feature request will be provided in https://github.com/apache/iotdb/pull/4303
--
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] SteveYurongSu commented on issue #4311: [v0.12.2] Error when using aggregate query and nested expressions
Posted by GitBox <gi...@apache.org>.
SteveYurongSu commented on issue #4311:
URL: https://github.com/apache/iotdb/issues/4311#issuecomment-962730777
> Looks like the implementation for this feature request will be provided in #4303
#4303 enhanced down-frequency aggregate queries[1], which are different from aggregate queries in nested expressions. The implementation of aggregate queries in nested expressions has just startup, the feature will be provided in the master branch and likely will be released on rel/0.13. 😆
[1] [Down-frequency aggregate queries](https://iotdb.apache.org/UserGuide/Master/IoTDB-SQL-Language/DML-Data-Manipulation-Language.html#down-frequency-aggregate-query)
--
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