Re: Mysql data import issue

2016-01-29 Thread vsriram30
to achieve that? Thanks, Sriram -- View this message in context: http://lucene.472066.n3.nabble.com/Mysql-data-import-issue-tp4253998p4254210.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Mysql data import issue

2016-01-28 Thread Gora Mohanty
On 29 January 2016 at 04:13, vsriram30 wrote: > Hi, > I am using Solr 4.6.1 and I am trying to import my data from mysql to solr. > > In mysql, I have a table with columns, > id, legacyid, otherfields... > [...] > But still I get mysql id field to solr id field mapping. Please let me know > how

Mysql data import issue

2016-01-28 Thread vsriram30
olr id field mapping. Please let me know how to prevent this from happening. Thanks, Sriram -- View this message in context: http://lucene.472066.n3.nabble.com/Mysql-data-import-issue-tp4253998.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: MySQL Data import handler

2013-09-14 Thread Amit Jha
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

Re: MySQL Data import handler

2013-09-14 Thread Baskar Sikkayan
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. > >

Re: MySQL Data import handler

2013-09-14 Thread Gora Mohanty
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, dele

Re: MySQL Data import handler

2013-09-14 Thread Baskar Sikkayan
kar 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 > dat

Re: MySQL Data import handler

2013-09-14 Thread Gora Mohanty
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. Pleas

MySQL Data import handler

2013-09-14 Thread Baskar Sikkayan
Hi, I am new to solar and trying for MySQL data import handler. I have 3 tables in mysql. 1) user 2) mast_data 3) child_data The child_data table has foreign key ref of master_data and user. In child_data table, i have the following columns. 1) date 2) fee 3) location 4) type 5) text 6

Re: MySQL data import

2011-12-13 Thread Shawn Heisey
On 12/11/2011 1:54 PM, Brian Lamb wrote: By nature of my schema, I have several multivalued fields. Each one I populate with a separate entity. Is there a better way to do it? For example, could I pull in all the singular data in one sitting and then come back in later and populate with the multi

Re: MySQL data import

2011-12-12 Thread Erick Erickson
to consider just doing the whole >> thing in SolrJ with a JDBC connection. When things >> get complex, it's sometimes more straightforward. >> >> Best >> Erick... >> >> P.S. Yes, it's pretty standard to have a single >> field be the destination f

Re: MySQL data import

2011-12-12 Thread Brian Lamb
Lamb > > wrote: > >> Hi all, > >> > >> I have a few questions about how the MySQL data import works. It seems > it > >> creates a separate connection for each entity I create. Is there any > way to > >> avoid this? > > > > Not sur

Re: MySQL data import

2011-12-12 Thread Erick Erickson
2, 2011 at 12:48 PM, Gora Mohanty wrote: > On Mon, Dec 12, 2011 at 2:24 AM, Brian Lamb > wrote: >> Hi all, >> >> I have a few questions about how the MySQL data import works. It seems it >> creates a separate connection for each entity I create. Is there any way to &

Re: MySQL data import

2011-12-12 Thread Gora Mohanty
On Mon, Dec 12, 2011 at 2:24 AM, Brian Lamb wrote: > Hi all, > > I have a few questions about how the MySQL data import works. It seems it > creates a separate connection for each entity I create. Is there any way to > avoid this? Not sure, but I do not think that it is possible

Re: MySQL data import

2011-12-12 Thread Brian Lamb
Hi all, Any tips on this one? Thanks, Brian Lamb On Sun, Dec 11, 2011 at 3:54 PM, Brian Lamb wrote: > Hi all, > > I have a few questions about how the MySQL data import works. It seems it > creates a separate connection for each entity I create. Is there any way to > avoid this

MySQL data import

2011-12-11 Thread Brian Lamb
Hi all, I have a few questions about how the MySQL data import works. It seems it creates a separate connection for each entity I create. Is there any way to avoid this? By nature of my schema, I have several multivalued fields. Each one I populate with a separate entity. Is there a better way