[
https://issues.apache.org/jira/browse/IOTDB-957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Boris Zhu reassigned IOTDB-957:
-------------------------------
Assignee: Boris Zhu
> SQL Arithmetic Operators
> ------------------------
>
> Key: IOTDB-957
> URL: https://issues.apache.org/jira/browse/IOTDB-957
> Project: Apache IoTDB
> Issue Type: New Feature
> Components: Planner/SQLParser
> Reporter: Jialin Qiao
> Assignee: Boris Zhu
> Priority: Major
>
> [https://github.com/apache/iotdb/issues/1855]
> copy from github issue:
> 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 message was sent by Atlassian Jira
(v8.3.4#803005)
