Re: Solr dataimporthandler use storedProcedure in deltaImportQuery

2014-02-13 Thread Shawn Heisey
On 2/13/2014 5:53 PM, Jay Potharaju wrote: > I was wondering if its possible to call a storedProcedure in the > deltaImportQuery. This is what I 'm trying to do. > >query="SELECT * FROM table1 > INNER JOIN tabl2 ON table2.tbl1Id = table1.id" > > deltaImportQue

Re: Solr dataimporthandler use storedProcedure in deltaImportQuery

2014-02-13 Thread Ahmet Arslan
I think it is not possible to use stored procedures in DIH.  Please see : https://issues.apache.org/jira/browse/SOLR-1262 On Friday, February 14, 2014 3:02 AM, Jay Potharaju wrote: I was wondering if its possible to call a storedProcedure in the deltaImportQuery. This is what I 'm trying to do

Solr dataimporthandler use storedProcedure in deltaImportQuery

2014-02-13 Thread Jay Potharaju
I was wondering if its possible to call a storedProcedure in the deltaImportQuery. This is what I 'm trying to do. In my store procedure I am deleting n rows and inserting them back. And then finally run a select statement to get some data back from the delta import query. Can anyone tell me