[
https://issues.apache.org/jira/browse/SOLR-946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12659790#action_12659790
]
Shalin Shekhar Mangar commented on SOLR-946:
--------------------------------------------
Try using the deltaImportQuery. From the wiki document:
deltaImportQuery : (Only used in delta-import). If this is not present , DIH
tries to construct the import query by(after identifying the delta) modifying
the 'query' (this is error prone). There is a namespace
${dataimporter.delta.<column-name>} which can be used in this query. e.g:
select * from tbl where id=${dataimporter.delta.id}
Note -- This is a Solr 1.4 feature so you must use a nightly build.
> DataImportHandler issue with SQL query using GROUP BY keyword
> -------------------------------------------------------------
>
> Key: SOLR-946
> URL: https://issues.apache.org/jira/browse/SOLR-946
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 1.3
> Reporter: secmask
>
> hi, i'm using DataImportHandler to import my data from database to solr
> index. in db-data-import.xml i have i query like this:
> <document name="products">
> <entity name="product" pk="products.id" Query="SELECT products.id
> products.name, features.props FROM products JOIN features ON
> products.id=features.product_id GROUP BY features.product_id"
> deltaQuery="SELECT products.id from products where
> products.lastMod>'${dataimport.last_modify}'">
> <field name="id" column="id" />
> <field name="name" column="name" boost="4.0" />
> </entity>
> </document>
> don't be attend at the database structs, problem is when i use delta-import,
> the sql query to mysql by solr will look like "$Query" + "WHERE pk={ id
> return by deltaQuery }" , this will cause sql query syntax error because
> WHERE keyword must be appear in front of GROUP BY keyword. i don't know how
> to solr this problem. please help me.
> thanks.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
