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.
