when using group=true facet numbers are "incorrect"
Hi, I've noticed that when field collapsing and faceting are both used in the one query the facet numbers ignore the grouping. In my example I have three documents (I have a small index for testing) and if I group on a certain field I get two groups in the results but the facet numbers show that there were three hits. I understand that's a valid thing for faceting to do, I was just wondering if there's any way to get it to do the faceting on the groups returned. Otherwise I guess I'll need to convince the UI people to just show the facets without the numbers. Cheers, Greg
can't determine sort order with desc provided
Hi, I'm having an issue with sorting because the PHP plugin converts the + to %2B, I get the error "Can't determine Sort Order: 'name+desc'". Thanks in advance for any assistance. Cheers Nov 8, 2011 1:53:00 PM org.apache.solr.core.SolrCore execute INFO: [pending] webapp=/solr path=/select/ params={facet=true&sort=name+desc&indent=on&start=0&q=*:*&group.field=resourceid&group=true&facet.field=sport&facet.field=learningmode&rows=10&version=2.2} hits=3 status=0 QTime=2 Nov 8, 2011 1:53:58 PM org.apache.solr.core.SolrCore execute INFO: [pending] webapp=/solr path=/select params={facet=true&start=0&q=Just*&group.field=resourceid&group=true&facet.field=sport&facet.field=learningmode&facet.field=resourceid& json.nl=map&wt=json&rows=10} hits=3 status=0 QTime=2 Nov 8, 2011 1:54:01 PM org.apache.solr.common.SolrException log SEVERE: org.apache.solr.common.SolrException: Can't determine Sort Order: 'name+desc', pos=9 at org.apache.solr.search.QueryParsing.parseSort(QueryParsing.java:358) at org.apache.solr.search.QParser.getSort(QParser.java:251) at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:82) at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:173) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Nov 8, 2011 1:54:01 PM org.apache.solr.core.SolrCore execute INFO: [pending] webapp=/solr path=/select params={facet=true&sort=name%2Bdesc&start=0&q=Just*&group.field=resourceid&group=true&facet.field=sport&facet.field=learningmode&facet.field=resourceid& json.nl=map&wt=json&rows=10} status=400 QTime=2
Re: when using group=true facet numbers are "incorrect"
That works well, thanks very much. On Tue, Nov 8, 2011 at 12:55 PM, Chris Hostetter wrote: > > : I understand that's a valid thing for faceting to do, I was just > wondering > : if there's any way to get it to do the faceting on the groups returned. > : Otherwise I guess I'll need to convince the UI people to just show the > : facets without the numbers. > > what you are asking about is generally refered to as "post-group faceting" > and can be activated using "group.truncate"... > > https://wiki.apache.org/solr/FieldCollapsing#Request_Parameters > > > > > -Hoss >
Re: can't determine sort order with desc provided
Thanks again On Tue, Nov 8, 2011 at 2:56 PM, Chris Hostetter wrote: > > : I'm having an issue with sorting because the PHP plugin converts the + to > : %2B, I get the error "Can't determine Sort Order: 'name+desc'". > > then it sounds like the PHP library you are using is URL escaping > things properly, and you should just be passing a simple space > character to it. > > the canonical form of a sort is "fieldname desc" or "fieldname asc" ... > when you see examples that look like "fieldname+desc" that's justbecause > the example is showing you what it looks like when it's been URL escaped > and put into the URL... > > https://wiki.apache.org/solr/CommonQueryParameters#sort > > : > : Thanks in advance for any assistance. > : > : Cheers > : > : Nov 8, 2011 1:53:00 PM org.apache.solr.core.SolrCore execute > : INFO: [pending] webapp=/solr path=/select/ > : > params={facet=true&sort=name+desc&indent=on&start=0&q=*:*&group.field=resourceid&group=true&facet.field=sport&facet.field=learningmode&rows=10&version=2.2} > : hits=3 status=0 QTime=2 > : Nov 8, 2011 1:53:58 PM org.apache.solr.core.SolrCore execute > : INFO: [pending] webapp=/solr path=/select > : > params={facet=true&start=0&q=Just*&group.field=resourceid&group=true&facet.field=sport&facet.field=learningmode&facet.field=resourceid& > : json.nl=map&wt=json&rows=10} hits=3 status=0 QTime=2 > : Nov 8, 2011 1:54:01 PM org.apache.solr.common.SolrException log > : SEVERE: org.apache.solr.common.SolrException: Can't determine Sort Order: > : 'name+desc', pos=9 > : at > org.apache.solr.search.QueryParsing.parseSort(QueryParsing.java:358) > : at org.apache.solr.search.QParser.getSort(QParser.java:251) > : at > : > org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:82) > : at > : > org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:173) > : at > : > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) > : at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368) > : at > : > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356) > : at > : > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252) > : at > : > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > : at > : > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > : at > : > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > : at > : > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > : at > : > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > : at > : > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > : at > : > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > : at > : > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > : at > : > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) > : at > : > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > : at > : org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > : at java.lang.Thread.run(Thread.java:662) > : > : Nov 8, 2011 1:54:01 PM org.apache.solr.core.SolrCore execute > : INFO: [pending] webapp=/solr path=/select > : > params={facet=true&sort=name%2Bdesc&start=0&q=Just*&group.field=resourceid&group=true&facet.field=sport&facet.field=learningmode&facet.field=resourceid& > : json.nl=map&wt=json&rows=10} status=400 QTime=2 > : > > -Hoss >
Error Handling of deliberately missing required field
Hi, I'm trying to implement error handling in a PHP client (through the PHP SOLR Plugin), I'm doing so by making a missing field mandatory temporarily. When the update is sent through without the field made mandatory I get a response back with a status code of 0 which is great. In the situation where the field is made mandatory I was hoping to get a status code of 40 or whatever and an error message like the message in the tomcat log below: "missing required field: numberviewed". Instead I get an exception, which has a message of "Bad Request" and thousands of lines of data with everything except "missing required field: numberviewed". I was wondering if there there is anything I'm missing, is there a way to get to that message? Also, I wouldn't have thought a missing field was a severe error but I was wondering if there was any other tests I could put in to deliberately get errors that would show up as error codes on the result rather than exceptions. Thanks in advance for any advice. Cheers SEVERE: org.apache.solr.common.SolrException: Document [7ec0f68c-dacb-4c5f-9e6d-84914b134591] missing required field: numberviewed at org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:336) at org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60) at org.apache.solr.update.processor.LogUpdateProcessor.processAdd(LogUpdateProcessorFactory.java:115) at org.apache.solr.handler.XMLLoader.processUpdate(XMLLoader.java:158) at org.apache.solr.handler.XMLLoader.load(XMLLoader.java:79) at org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(ContentStreamHandlerBase.java:67) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662)
Exception importing multi-valued UUID field
Hi, I exported a csv file from SOLR and made some changes, I then tried to reimport the file and got the exception below. It seems UUID field type can't import multi-values, I removed all of the multi-values and it imported without an issue. Cheers org.apache.solr.common.SolrException: Error while creating field 'jobuid{type=uuid,properties=indexed,stored,omitTermFreqAndPositions,multiValued}' from value '845b9db2-2a25-44e3-8eb4-3bf17cd16738,c5477d5d-e77c-45e9-ab61-f7ca05499b37' at org.apache.solr.schema.FieldType.createField(FieldType.java:239) at org.apache.solr.schema.SchemaField.createField(SchemaField.java:104) at org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:203) at org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:276) at org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60) at org.apache.solr.update.processor.LogUpdateProcessor.processAdd(LogUpdateProcessorFactory.java:115) at org.apache.solr.handler.CSVLoader.doAdd(CSVRequestHandler.java:416) at org.apache.solr.handler.SingleThreadedCSVLoader.addDoc(CSVRequestHandler.java:431) at org.apache.solr.handler.CSVLoader.load(CSVRequestHandler.java:393) at org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(ContentStreamHandlerBase.java:67) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.RequestHandlers$LazyRequestHandlerWrapper.handleRequest(RequestHandlers.java:241) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:300) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:679) Caused by: org.apache.solr.common.SolrException: Invalid UUID String: '845b9db2-2a25-44e3-8eb4-3bf17cd16738,c5477d5d-e77c-45e9-ab61-f7ca05499b37' at org.apache.solr.schema.UUIDField.toInternal(UUIDField.java:85) at org.apache.solr.schema.FieldType.createField(FieldType.java:237)
Re: Exception importing multi-valued UUID field
I also tried it with the comma escaped, so: '845b9db2-2a25-44e3-8eb4-3bf17cd16738\,c5477d5d-e77c-45e9-ab61-f7ca05499b37' So that's in the same format as it was exported, Excel must have removed the slash. But I still get the error with the slash. On Tue, Feb 21, 2012 at 11:26 AM, Greg Pelly wrote: > Hi, > > I exported a csv file from SOLR and made some changes, I then tried to > reimport the file and got the exception below. It seems UUID field type > can't import multi-values, I removed all of the multi-values and it > imported without an issue. > > Cheers > > > org.apache.solr.common.SolrException: Error while creating field > 'jobuid{type=uuid,properties=indexed,stored,omitTermFreqAndPositions,multiValued}' > from value > '845b9db2-2a25-44e3-8eb4-3bf17cd16738,c5477d5d-e77c-45e9-ab61-f7ca05499b37' > at org.apache.solr.schema.FieldType.createField(FieldType.java:239) > at org.apache.solr.schema.SchemaField.createField(SchemaField.java:104) > at > org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:203) > at > org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:276) > at > org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60) > at > org.apache.solr.update.processor.LogUpdateProcessor.processAdd(LogUpdateProcessorFactory.java:115) > at org.apache.solr.handler.CSVLoader.doAdd(CSVRequestHandler.java:416) > at > org.apache.solr.handler.SingleThreadedCSVLoader.addDoc(CSVRequestHandler.java:431) > at org.apache.solr.handler.CSVLoader.load(CSVRequestHandler.java:393) > at > org.apache.solr.handler.ContentStreamHandlerBase.handleRequestBody(ContentStreamHandlerBase.java:67) > at > org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) > at > org.apache.solr.core.RequestHandlers$LazyRequestHandlerWrapper.handleRequest(RequestHandlers.java:241) > at org.apache.solr.core.SolrCore.execute(SolrCore.java:1368) > at > org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:356) > at > org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:252) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:300) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > at java.lang.Thread.run(Thread.java:679) > Caused by: org.apache.solr.common.SolrException: Invalid UUID String: > '845b9db2-2a25-44e3-8eb4-3bf17cd16738,c5477d5d-e77c-45e9-ab61-f7ca05499b37' > at org.apache.solr.schema.UUIDField.toInternal(UUIDField.java:85) > at org.apache.solr.schema.FieldType.createField(FieldType.java:237) > > >