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.

Mysql data import issue

2016-01-28 Thread vsriram30
ld 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 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.

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 handler

2013-09-14 Thread Gora Mohanty
On 14 September 2013 18:46, Baskar Sikkayan baskar@gmail.com 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

Re: MySQL Data import handler

2013-09-14 Thread Baskar Sikkayan
2013 18:46, Baskar Sikkayan baskar@gmail.com 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

Re: MySQL Data import handler

2013-09-14 Thread Gora Mohanty
On 14 September 2013 20:07, Baskar Sikkayan baskar@gmail.com 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

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 g...@mimirtech.com wrote: On 14 September 2013 20:07, Baskar Sikkayan baskar@gmail.com wrote: Hi Gora,

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,

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

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 brian.l...@journalexperts.comwrote: 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

Re: MySQL data import

2011-12-12 Thread Gora Mohanty
On Mon, Dec 12, 2011 at 2:24 AM, Brian Lamb brian.l...@journalexperts.com 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

Re: MySQL data import

2011-12-12 Thread Erick Erickson
at 12:48 PM, Gora Mohanty g...@mimirtech.com wrote: On Mon, Dec 12, 2011 at 2:24 AM, Brian Lamb brian.l...@journalexperts.com 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

Re: MySQL data import

2011-12-12 Thread Brian Lamb
...@journalexperts.com 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. However, from your description below, I think

Re: MySQL data import

2011-12-12 Thread Erick Erickson
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. However, from your description below, I think that you are unnecessarily multiplying entities. By nature of my

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