[jira] Resolved: (SOLR-946) DataImportHandler issue with SQL query using GROUP BY keyword

["Shalin Shekhar Mangar (JIRA)" <ji...@apache.org>]

     [ 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.