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