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 2020/10/26 00:32:35 UTC
[GitHub] [iotdb] thart-hnrg opened a new issue #1855: SQL Arithmetic Operators
thart-hnrg opened a new issue #1855:
URL: https://github.com/apache/iotdb/issues/1855
SQL queries should support SQL arithmetic operators.
Currently
If I run a query such as "select m1+m2 from XYZ.myseries" I get no results.
If I run a query such as "select m3 from XYZ.myseries where mt+ma > 10" I get an exception;
org.apache.iotdb.jdbc.IoTDBSQLException: 401: Filter has some time series don't correspond to any known time series
If I put the arithmetic in bvrckets I get this exception;
org.apache.iotdb.jdbc.IoTDBSQLException: 401: meet error while parsing SQL to physical plan: {}line 3:12 no viable alternative at input 'ma+mt)'
The query should process arithmetic operators.
I am using measurements to send alarms when thresholds are exceeded. Some threshholds are percentages but measurements are stored as true values so I need to calculate a percentage (this is just one example).
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] SteveYurongSu commented on issue #1855: SQL Arithmetic Operators
Posted by GitBox <gi...@apache.org>.
SteveYurongSu commented on issue #1855:
URL: https://github.com/apache/iotdb/issues/1855#issuecomment-733017439
> SQL queries should support SQL arithmetic operators.
>
> Currently
> If I run a query such as "select m1+m2 from XYZ.myseries" I get no results.
>
> If I run a query such as "select m3 from XYZ.myseries where mt+ma > 10" I get an exception;
> org.apache.iotdb.jdbc.IoTDBSQLException: 401: Filter has some time series don't correspond to any known time series
>
> If I put the arithmetic in bvrckets I get this exception;
> org.apache.iotdb.jdbc.IoTDBSQLException: 401: meet error while parsing SQL to physical plan: {}line 3:12 no viable alternative at input 'ma+mt)'
>
> The query should process arithmetic operators.
>
> I am using measurements to send alarms when thresholds are exceeded. Some threshholds are percentages but measurements are stored as true values so I need to calculate a percentage (this is just one example).
Hi, I wrote a requirement doc for arithmetic operations in SELECT clauses, you can find the doc [here](https://cwiki.apache.org/confluence/display/IOTDB/Arithmetic+Operations+In+SELECT+Clauses). Please leave your opinion here if you have further ideas :)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] ope-nz commented on issue #1855: SQL Arithmetic Operators
Posted by GitBox <gi...@apache.org>.
ope-nz commented on issue #1855:
URL: https://github.com/apache/iotdb/issues/1855#issuecomment-741454707
Thanks @SteveYurongSu those requirements look great, I dont have any additional requirements beyond what you have documented in the doc.
BTW I am the user who created the original issue, I didnt realise I was logged in with a different account at the time.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] qiaojialin edited a comment on issue #1855: SQL Arithmetic Operators
Posted by GitBox <gi...@apache.org>.
qiaojialin edited a comment on issue #1855:
URL: https://github.com/apache/iotdb/issues/1855#issuecomment-716415281
Hi, thanks for your advise 👍 I have created an issue in the jira. We will support this in the future.
https://issues.apache.org/jira/browse/IOTDB-957
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] qiaojialin commented on issue #1855: SQL Arithmetic Operators
Posted by GitBox <gi...@apache.org>.
qiaojialin commented on issue #1855:
URL: https://github.com/apache/iotdb/issues/1855#issuecomment-716415281
Hi, thanks for your advise 👍 I have created an issue in the jira. We will support this in the future.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou commented on issue #1855: SQL Arithmetic Operators
Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #1855:
URL: https://github.com/apache/iotdb/issues/1855#issuecomment-1003292235
This feature is added in v0.13 version, which will be released soon.
https://iotdb.apache.org/UserGuide/Master/IoTDB-SQL-Language/DML-Data-Manipulation-Language.html#arithmetic-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
[GitHub] [iotdb] HTHou closed issue #1855: SQL Arithmetic Operators
Posted by GitBox <gi...@apache.org>.
HTHou closed issue #1855:
URL: https://github.com/apache/iotdb/issues/1855
--
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