lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raheel Hasan <raheelhasan....@gmail.com>
Subject Re: Multitable import - uniqueKey
Date Mon, 03 Jun 2013 15:06:21 GMT
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 <jack@basetechnology.com>wrote:

> Same answer. Whether it is 2, 3, 10 or 1000 tables, you, the data
> architect must decide how to uniquely identify Solr documents. In general,
> when joining n tables, combine the n keys into one composite key. Either do
> it on the SQL query side, or with a Solr update request processor.
>
>
> -- Jack 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. 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 also added? will the 3 tables be intact in terms of
> relationship?
>
> Thanks.
>
>
>
> On Mon, Jun 3, 2013 at 7:33 PM, Jack Krupansky <jack@basetechnology.com>**
> wrote:
>
>  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 you WANT the Solr key field to look like? I mean,
>> YOU are the data architect, right? What requirements do you have? When
>> your
>> Solr application users receive the key values in the responses to queries,
>> what expectations do you expect to set for them?
>>
>> -- Jack Krupansky
>>
>> -----Original Message----- From: Raheel Hasan
>> Sent: Monday, June 03, 2013 9:12 AM
>> To: solr-user@lucene.apache.org
>> Subject: Multitable import - uniqueKey
>>
>>
>> Hi,
>>
>> I am importing multiple table (by join) into solr using DIH. All is set,
>> except for 1 confusion:
>> what to do with "*<uniqueKey>*" in schema?
>>
>>
>> When I had only 1 table, I had it fine. Now how to put 2 uniqueKeys (both
>> from different table).
>>
>> For example:
>>
>> <uniqueKey>table1_id</****uniqueKey>
>> <uniqueKey>table2_id</****uniqueKey>
>>
>>
>> Will this work?
>>
>> --
>> Regards,
>> Raheel Hasan
>>
>>
>
>
> --
> Regards,
> Raheel Hasan
>



-- 
Regards,
Raheel Hasan

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message