[jira] [Assigned] (IOTDB-957) SQL Arithmetic Operators

["Boris Zhu (Jira)" <ji...@apache.org>]

     [ 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)