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