lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sunil jadhav (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-2907) java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
Date Tue, 03 Feb 2015 15:08:35 GMT

    [ https://issues.apache.org/jira/browse/SOLR-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14303404#comment-14303404
] 

sunil jadhav commented on SOLR-2907:
------------------------------------

Thanks Mate. You saved my DAY. Your suggestion did worked after spending almost 6 hours on
figuring out the resolution !!!!

> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary
key pk='ITEM_ID, CATEGORY_ID'
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: SOLR-2907
>                 URL: https://issues.apache.org/jira/browse/SOLR-2907
>             Project: Solr
>          Issue Type: Bug
>          Components: contrib - DataImportHandler, Schema and Analysis
>    Affects Versions: 3.4
>            Reporter: Alan Baker
>
> We are using solr for our site and ran into this error in our own schema and I was able
to reproduce it using the dataimport example code in the solr project.  We do not get this
error in SOLR 1.4 only started seeing it as we are working to upgrade to 3.4.0.  It fails
when delta-importing linked tables.
> Complete trace:
> Nov 18, 2011 5:21:02 PM org.apache.solr.handler.dataimport.DataImporter doDeltaImport
> SEVERE: Delta Import Failed
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary
key pk='ITEM_ID, CATEGORY_ID'
> 	at org.apache.solr.handler.dataimport.DocBuilder.findMatchingPkColumn(DocBuilder.java:849)
> 	at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:900)
> 	at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:879)
> 	at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:285)
> 	at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:179)
> 	at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:390)
> 	at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:429)
> 	at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
> I used this dataConfig from the wiki on the data import:
> <dataConfig>
>     <dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex"
user="sa" />
>     <document>
>    <entity  name="item" pk="ID" 
>    			query="select * from item" 
>             deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
>             deltaQuery="select id from item where last_modified &gt; '${dataimporter.last_index_time}'">
>             <entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
>                     query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
>                     deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where
last_modified > '${dataimporter.last_index_time}'"
>                     parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
>                 
>         		<entity name="category" pk="ID"
>                         query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
>                         deltaQuery="select ID from category where last_modified &gt;
'${dataimporter.last_index_time}'"
>                         parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category
where CATEGORY_ID=${category.ID}"/>
>             	</entity>
>         </entity>
>         
>     </document>
> </dataConfig>
> To reproduce use the data config from above and set the dataimport.properties last update
times to before the last_modifed date in the example data.  I my case I had to set the year
to 1969.  Then run a delta-import and the exception occurs.  Thanks.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message