Top management has given requirements that force a broken design. They are
requiring something that is impossible with Solr.
1. Flatten the data. You get one table, no joins.
2. 12M records is not a big Solr index. That should work fine.
3. If the supplier activity points are updated frequently, you could use an
external file field for those, but they still need to be flattened.
wunder
On May 12, 2014, at 7:21 AM, Aman Tandon <antn.s...@gmail.com> wrote:
> Yeah i understand but i got the requirement from the top management,
> requirements are:
> core1: in this we want to keep the supplier activity points
> case 2: we want to boost those records which are present in core1 by the
> amount of supplier activity points.
>
> I know we can keep that supplier score in same core but this requires the
> full indexing of 12M records and suppliers are of about 1lacs which won't
> cost much.
>
> With Regards
> Aman
>
>
> On Mon, May 12, 2014 at 7:44 PM, Erick Erickson
> <erickerick...@gmail.com>wrote:
>
>> Any time you find yourself trying to use Solr like a DB, stop.
>>
>> Solr joins are _not_ DB joins, the data from the "from" core is not
>> returned (I think there are a few special cases where you can make
>> this happen though).
>>
>> Try denormalizing your data if at all possible, that's what Solr docs
>> best... search single records.
>>
>> Best,
>> Erick
>>
>> On Sun, May 11, 2014 at 6:40 PM, Aman Tandon <amantandon...@gmail.com>
>> wrote:
>>> please help me out here!!
>>>
>>> With Regards
>>> Aman Tandon
>>>
>>>
>>> On Sun, May 11, 2014 at 1:44 PM, Aman Tandon <amantandon...@gmail.com
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Is there a way possible to retrieve all the fields present in both the
>>>> cores(core 1 and core2).
>>>>
>>>> e.g.
>>>> core1: {id:111,name: "abc" }
>>>>
>>>> core2: {page:17, type: "fiction"}
>>>>
>>>> I want is that, on querying both the cores I want to retrieve the
>> results
>>>> containing all the 4 fields, fields id, name from core1 and page, type
>> from
>>>> core2. Is it possible?
>>>>
>>>> With Regards
>>>> Aman Tandon
>>>>
>>
--
Walter Underwood
wun...@wunderwood.org
