Re: Multitable import - uniqueKey

2013-06-07 Thread sodoo
Thank you for all reply members. Solve the issue. -- View this message in context: http://lucene.472066.n3.nabble.com/Multitable-import-uniqueKey-tp4067796p4069007.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Multitable import - uniqueKey

2013-06-05 Thread Chris Hostetter
: How can I don't overwrite other entities? : Please assist me on this example. I'm confused, you sent this in direct reply to my last message, which contained the following... 1) a paragraph describing the general approach to solving this type of problem... >> You can use TemplateTransformer

Re: Multitable import - uniqueKey

2013-06-05 Thread sodoo
Hehe. Yes my all tables ID field names are different. For example: I have 5 table. These names are 'admin, account, group, checklist' admin=>id ->uniquekey account=>account_id ->uniquekey group=>group_id ->uniquekey checklist=>id->uniquekey Also I thought last entity overwrite other entities.

Re: Multitable import - uniqueKey

2013-06-04 Thread Chris Hostetter
: And I have register schema.xml these fields. : I tried to make full import but unfortunately only the last entity is : indexed. Other entities are not index. : : What should I do to import all the entities? See Gora's other reply... >> This will only work if your table IDs are different. Mi

Re: Multitable import - uniqueKey

2013-06-04 Thread sodoo
Thank you. Solve the issue. Also I one problem. I want to create index few tables. All tables not related. In data-config.xml, that I created to create index

Re: Multitable import - uniqueKey

2013-06-04 Thread Gora Mohanty
On 4 June 2013 16:03, Gora Mohanty wrote: > On 4 June 2013 14:14, sodoo wrote: >> >> Hi, >> >> My english is bad. But I try to explain do this. >> >> I have a 5 table in MySQL db. I try make data-config.xml. Then my >> data-config.xml is below. >> >> >> > name=

Re: Multitable import - uniqueKey

2013-06-04 Thread Gora Mohanty
On 4 June 2013 14:14, sodoo wrote: > > Hi, > > My english is bad. But I try to explain do this. > > I have a 5 table in MySQL db. I try make data-config.xml. Then my > data-config.xml is below. > > > name="ds-1" > driver="com.mysql.jdbc.Driver" >

Re: Multitable import - uniqueKey

2013-06-04 Thread sodoo
Hi, My english is bad. But I try to explain do this. I have a 5 table in MySQL db. I try make data-config.xml. Then my data-config.xml is below.

Re: Multitable import - uniqueKey

2013-06-04 Thread Raheel Hasan
oh thanks a lot for the replies. Table 1, 2, 3 are just "normalized" form of the whole record and you can easily pull one from another... but thats RDBMS, I dont know if thats true in Solr as well. On Mon, Jun 3, 2013 at 8:33 PM, Shawn Heisey wrote: > > ok. But do we need it? Thats what I

Re: Multitable import - uniqueKey

2013-06-03 Thread Shawn Heisey
> ok. But do we need it? Thats what I am confused at. should 1 key from > table_1 pull all the data in relationship as they were inserted? Suoplementing all the great info Jack has relayed: For the unique key in schema.xml, you really only need to be concerned about the document uniqueness within

Re: Multitable import - uniqueKey

2013-06-03 Thread Jack Krupansky
y, June 03, 2013 11:06 AM To: solr-user@lucene.apache.org Subject: Re: Multitable import - uniqueKey ok. But do we need it? Thats what I am confused at. should 1 key from table_1 pull all the data in relationship as they were inserted? On Mon, Jun 3, 2013 at 7:53 PM, Jack Krupansky wrote: S

Re: Multitable import - uniqueKey

2013-06-03 Thread Raheel Hasan
Monday, June 03, 2013 10:44 AM > To: solr-user@lucene.apache.org > Subject: Re: Multitable import - uniqueKey > > > Hi, > > Thanks for the replies. Actually, I had only a small confusion: > > From table_1 I got key_1; using this I join into table_2. But table_2 also > gav

Re: Multitable import - uniqueKey

2013-06-03 Thread Jack Krupansky
Krupansky -Original Message- From: Raheel Hasan Sent: Monday, June 03, 2013 10:44 AM To: solr-user@lucene.apache.org Subject: Re: Multitable import - uniqueKey Hi, Thanks for the replies. Actually, I had only a small confusion: From table_1 I got key_1; using this I join into table_2

Re: Multitable import - uniqueKey

2013-06-03 Thread Raheel Hasan
Hi, Thanks for the replies. Actually, I had only a small confusion: >From table_1 I got key_1; using this I join into table_2. But table_2 also gave another key key_2 which is needed for joining with table_3. So for Table1 and Table2 its obviously just fine... but what will happen when table3 is

Re: Multitable import - uniqueKey

2013-06-03 Thread Jack Krupansky
If the respective table IDs are not globally unique, then you (the developer) will have to supplement the raw ID with a prefix or suffix or other form of global ID (e.g., UUID) to assure that they are unique. You could just add the SQL table name as a prefix or suffix. The bottom line: What do

Re: Multitable import - uniqueKey

2013-06-03 Thread Shawn Heisey
On 6/3/2013 7:12 AM, Raheel Hasan wrote: > I am importing multiple table (by join) into solr using DIH. All is set, > except for 1 confusion: > what to do with "**" in schema? > > When I had only 1 table, I had it fine. Now how to put 2 uniqueKeys (both > from different table). > > For example: >