[
https://issues.apache.org/jira/browse/IOTDB-217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jialin Qiao closed IOTDB-217.
-----------------------------
Fix Version/s: 0.10.0-SNAPSHOT
Resolution: Fixed
> A new predicate of time
> -----------------------
>
> Key: IOTDB-217
> URL: https://issues.apache.org/jira/browse/IOTDB-217
> Project: Apache IoTDB
> Issue Type: New Feature
> Reporter: Jialin Qiao
> Priority: Major
> Labels: medium, pull-request-available
> Fix For: 0.10.0-SNAPSHOT
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> I have encountered an issue that our SQL cannot support well.
> The scenario is: I want to get the data between 9:00am to 12:00am in each day
> last week.
> Could we add a new sql to do that? The sql maybe like this:
>
> select s0 from root.d0 where time >= now()-1week and time <= now() groupby
> time(1d) innerInterval(9h, 12h)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)