Re: MySQL Data import handler
Hi Baskar, Just create a single schema.xml which should contains required fields from 3 tables. Add a status column to child table.i.e 1 = add 2 = update 3 = delete 4 = indexed Etc Write a program using solrj which will read the status and do thing accordingly. Rgds AJ On 15-Sep-2013, at 5:46, Baskar Sikkayan wrote: > Hi, > If i am supposed to go with Java client, should i still do any > configurations in solrconfig.xml or schema.xml. > > Thanks, > Baskar.S > > > On Sat, Sep 14, 2013 at 8:46 PM, Gora Mohanty wrote: > >> On 14 September 2013 20:07, Baskar Sikkayan wrote: >>> Hi Gora, >>>Thanks a lot for your reply. >>> My requirement is to combine 3 tables in mysql for search operation and >>> planning to sync these 3 tables( not all the columns ) in Apache Solr. >>> Whenever there is any change( adding a new row, deleting a row, modifying >>> the column data( any column in the 3 tables ) ), the same has to updated >> in >>> solr. Guess, for this requirement, instead of going with delta-import, >>> Apachae Solar java client will be of useful. >> [...] >> >> Yes, if you are comfortable with programming in Java, >> the Solr client would be a good alternative, though the >> DataImportHandler can also do what you want. >> >> Regards, >> Gora >>
Re: MySQL Data import handler
Hi, If i am supposed to go with Java client, should i still do any configurations in solrconfig.xml or schema.xml. Thanks, Baskar.S On Sat, Sep 14, 2013 at 8:46 PM, Gora Mohanty wrote: > On 14 September 2013 20:07, Baskar Sikkayan wrote: > > Hi Gora, > > Thanks a lot for your reply. > > My requirement is to combine 3 tables in mysql for search operation and > > planning to sync these 3 tables( not all the columns ) in Apache Solr. > > Whenever there is any change( adding a new row, deleting a row, modifying > > the column data( any column in the 3 tables ) ), the same has to updated > in > > solr. Guess, for this requirement, instead of going with delta-import, > > Apachae Solar java client will be of useful. > [...] > > Yes, if you are comfortable with programming in Java, > the Solr client would be a good alternative, though the > DataImportHandler can also do what you want. > > Regards, > Gora >
Re: MySQL Data import handler
On 14 September 2013 20:07, Baskar Sikkayan wrote: > Hi Gora, > Thanks a lot for your reply. > My requirement is to combine 3 tables in mysql for search operation and > planning to sync these 3 tables( not all the columns ) in Apache Solr. > Whenever there is any change( adding a new row, deleting a row, modifying > the column data( any column in the 3 tables ) ), the same has to updated in > solr. Guess, for this requirement, instead of going with delta-import, > Apachae Solar java client will be of useful. [...] Yes, if you are comfortable with programming in Java, the Solr client would be a good alternative, though the DataImportHandler can also do what you want. Regards, Gora
Re: MySQL Data import handler
Hi Gora, Thanks a lot for your reply. My requirement is to combine 3 tables in mysql for search operation and planning to sync these 3 tables( not all the columns ) in Apache Solr. Whenever there is any change( adding a new row, deleting a row, modifying the column data( any column in the 3 tables ) ), the same has to updated in solr. Guess, for this requirement, instead of going with delta-import, Apachae Solar java client will be of useful. Could you please share your view? Thanks, Baskar.S On Sat, Sep 14, 2013 at 7:25 PM, Gora Mohanty wrote: > On 14 September 2013 18:46, Baskar Sikkayan wrote: > > Hi, > > I am new to solar and trying for MySQL data import handler. > > > > I have 3 tables in mysql. > [...] > > Your question is unclear, and you would probably benefit > by doing some basic homework on Solr and importing > data into it. Please start from the Solr Wiki: > http://wiki.apache.org/solr/ > > For indexing from a database, you can use the DataImportHandler: > http://wiki.apache.org/solr/DataImportHandler > http://wiki.apache.org/solr/DIHQuickStart > What you want should be pretty straightforward. After > setting up basic data import, please refer to delta-import > for adding new data to Solr: > http://wiki.apache.org/solr/DataImportHandler#Using_delta-import_command > > Regards, > Gora >
Re: MySQL Data import handler
On 14 September 2013 18:46, Baskar Sikkayan wrote: > Hi, > I am new to solar and trying for MySQL data import handler. > > I have 3 tables in mysql. [...] Your question is unclear, and you would probably benefit by doing some basic homework on Solr and importing data into it. Please start from the Solr Wiki: http://wiki.apache.org/solr/ For indexing from a database, you can use the DataImportHandler: http://wiki.apache.org/solr/DataImportHandler http://wiki.apache.org/solr/DIHQuickStart What you want should be pretty straightforward. After setting up basic data import, please refer to delta-import for adding new data to Solr: http://wiki.apache.org/solr/DataImportHandler#Using_delta-import_command Regards, Gora