Re: solr 8.11 attribute for deltaImportQuery

2023-12-02 Thread Andy Webb
Nice, glad that helped! I'd not clocked the two variable names before, but it looks like they're interchangeable - the code defines "dih" as the alternate short version at https://github.com/apache/lucene-solr/blob/branch_8_11/solr/contrib/dataimporthandler/src/java/org/apache/solr/handler/dataimp

Re: solr 8.11 attribute for deltaImportQuery

2023-12-01 Thread Vince McMahon
Andy, you rock! You've made my day. it works after adding the deltaImportQuery with the WHERE id =... into the entity section. BTW, would you have a pointer when to use the variable dataimporter vs dih '${dataimporter.delta.id}? I see some other online places use dih, when doing dih.last_index

Re: solr 8.11 attribute for deltaImportQuery

2023-12-01 Thread Andy Webb
hi Vince, The deltaQuery is used to fetch the IDs of any changed items - DIH then runs the deltaImportQuery to fetch the document for each of those IDs, using a WHERE clause of the form "WHERE id = '${dataimporter.delta.id}'. (You can make it use compound PKs if necessary - and you might want a de

Re: solr 8.11 attribute for deltaImportQuery

2023-12-01 Thread Vince McMahon
I need help, please. I keep looking at the Configuration, the full import works using the entity "query". I have tested the SELECT statement from deltaQuery in a Teradata terminal and that works. The following teradata query returns 18 rows from the Teradata terminal. SELECT id, updated_at FROM

solr 8.11 attribute for deltaImportQuery

2023-12-01 Thread Vince McMahon
Hi, Could someone please help me with the what Solr is looking in deltaQuery of Delta Import ? I have got 18 rows fetched from the database, but none of the row is processed as document. There are the "WARN" In the solr.log, but, what attribute is not specified? It seems important because the Ra