You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Greg Pelly <gf...@gmail.com> on 2012/02/21 01:26:25 UTC

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

Posted by Yonik Seeley <yo...@lucidimagination.com>.
On Mon, Feb 20, 2012 at 7:26 PM, Greg Pelly <gf...@gmail.com> wrote:
> 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.

Did you try split=true?

http://wiki.apache.org/solr/UpdateCSV#split

-Yonik
lucidimagination.com

Re: Exception importing multi-valued UUID field

Posted by Erick Erickson <er...@gmail.com>.
I don't think escaping is your problem, you probably want to take
that bit out.

Try adding
f.<youruuidfieldname>.split=true

when importing. You might also have to specify something like
f.<houruuidfieldname>.separator=,
but probably not, I suspect it's the default.

See the "split" heading at: http://wiki.apache.org/solr/UpdateCSV

Although I have to ask about your use case for curiosity, is this some
kind of 1-n mapping to other docs?

Best
Erick

On Mon, Feb 20, 2012 at 7:43 PM, Greg Pelly <gf...@gmail.com> wrote:
> 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 <gf...@gmail.com> 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)
>>
>>
>>

Re: Exception importing multi-valued UUID field

Posted by Greg Pelly <gf...@gmail.com>.
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 <gf...@gmail.com> 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)
>
>
>