[
https://issues.apache.org/jira/browse/IOTDB-448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17028827#comment-17028827
]
Xiangdong Huang commented on IOTDB-448:
---------------------------------------
OK now I find a solution: using OR keyword: where pressure = 100 or pressure =
150 or ...
At least it works.
> Support "IN" operator in the WHERE clause
> -----------------------------------------
>
> Key: IOTDB-448
> URL: https://issues.apache.org/jira/browse/IOTDB-448
> Project: Apache IoTDB
> Issue Type: New Feature
> Components: Core/Engine, Planner/SQLParser
> Reporter: Xiangdong Huang
> Priority: Major
>
> Hi,
> while I am trying to upgrade an application's database from MySQL to IoTDB, a
> new operator in the SELECT statment is needed:
> MySQL:
> SELECT * FROM STATION_TABLE WHERE observationTime = '2016-11-30 10:00:00' AND
> pressure IN (100,1000,150,200,250,300,400,500,700,850,925);
> Using the SQL, if a station has data that pressure in such range, the
> station's data will be returned.
> Therefore, we need an "IN" operator in the WHERE clause, like:
> SELECT * FROM root.station.* where time = 2016-11-30 10:00:00 and pressure
> IN (100,1000,150,200,250,300,400,500,700,850,925) group by device;
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
