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:
[email protected]
