Thanks! I'm glad to find out I'm not going crazy. I'll keep a lookout for that enhancement.
Ronald S. Wood Immediate customer support: Call 1-866-762-7741<tel:1-866-762-7741> (x2) or emailsupp...@smarsh.com<mailto:supp...@smarsh.com> On Jun 1, 2016, at 21:45, Joel Bernstein <joels...@gmail.com<mailto:joels...@gmail.com>> wrote: The documentation is wrong for sure. We need a new example query. I was just discussing the date issue with Erick Erickson the other day. I believe he is working on adding dates to the export handler but I didn't see a jira ticket for this yet. We'll also need to add dates to the /export handler for date support in the Parallel SQL interface. Erick, if you're reading this, let us know if this is in the works. Joel Bernstein http://joelsolr.blogspot.com/ On Wed, Jun 1, 2016 at 8:15 PM, Ronald Wood <rw...@smarsh.com<mailto:rw...@smarsh.com>> wrote: I have spent a bit of time with the export handler in 5.5.1 (since we are unable to upgrade directly from 4 to 6). The speed looks impressive at first glance compared to paging with cursors. However, I am deeply confused that it does not seem to be possible to either sort on or get date values when doing an export. I say deeply confused, because the example in the Reference Guide is this: http://localhost:8983/solr/core_name/export?q=my-query&sort=severity+desc,timestamp+desc&fl=severity,timestamp,msg Now, I suppose you could argue that timestamp's schema type isn't shown, so maybe it's an epochal integer value. Certainly when I try to get our date field (defined as TrieDateField in our schema) I get this error: java.io.IOException: Export fields must either be one of the following types: int,float,long,double,string at org.apache.solr.response.SortingResponseWriter.getFieldWriters(SortingResponseWriter.java:277) at org.apache.solr.response.SortingResponseWriter.write(SortingResponseWriter.java:120) at org.apache.solr.response.QueryResponseWriterUtil.writeQueryResponse(QueryResponseWriterUtil.java:52) ... And I see date is not a type there. However, int, float, long and double are also Trie types, so I'm not sure why a TrieDateField could not also be sorted or exported. I wonder if someone could elucidate this. I would have thought getting dates out of an export or stream would be highly desirable. I am definitely open to the high likelihood I am doing something wrong. I apologize if this topic has been covered before, as I was unable to find a way to search the mailing list on the Apache mail archives site. I wonder if there's some search engine out there that could do that kind of thing? ? Ronald S. Wood | Senior Software Developer 857-991-7681 (mobile) Smarsh 100 Franklin St. Suite 903 | Boston, MA 02210 1-866-SMARSH-1 | 971-998-9967 (fax) www.smarsh.com<http://www.smarsh.com><http://www.smarsh.com/> Immediate customer support: Call 1-866-762-7741 (x2) or visit www.smarsh.com/support<http://www.smarsh.com/support>< http://www.smarsh.com/support>
