[
https://issues.apache.org/jira/browse/SOLR-946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shalin Shekhar Mangar resolved SOLR-946.
----------------------------------------
Resolution: Won't Fix
Marking this issue as won't fix because there is a documented workaround
available in the form of 'deltaImportQuery'.
> 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.
