On 2/26/2014 11:42 PM, Chandan khatua wrote: > I have the bellow query in data-config.xml, but it throws an error while > running the delta query: "java.sql.SQLSyntaxErrorException: ORA-00918: > column ambiguously defined".
These are the FIRST two hits that I got when I searched for your full error string on Google: http://ora-918.ora-code.com/ http://www.techonthenet.com/oracle/errors/ora00918.php This error is coming from Oracle, not Solr. You did not include your deltaImportQuery. If you do not HAVE a deltaImportQuery defined, Solr will try to guess what it should be doing based on your main query and deltaQuery. As it says in the following wiki page, this is error-prone, and is likely to be the reason it's not working. http://wiki.apache.org/solr/DataImportHandler#Schema_for_the_data_config It's always possible that the real problem here is a bug in the Oracle JDBC driver. Less likely is a bug in Oracle itself. Thanks, Shawn
