The time functions aren't supported in the SQL interface currently. Joel Bernstein http://joelsolr.blogspot.com/
On Fri, Jan 13, 2017 at 10:44 AM, radha krishnan <dradhakrishna...@gmail.com > wrote: > Hi, > > can we write an SQL statement and use the /sql handler to get the > json.facet;s "gap" functionality. > > Ex facet query : > > json.facet: { > my_histogram: { > type: range, > field: i_timestamp, > start: "2016-10-21T01:00:00Z", > end: "2016-10-21T02:00:00Z", > gap: "+1MINUTE", > mincount: 0 > } > } > > > Thanks, > Radhakrishnan >