Several million rows is not a big deal for Solr, especially if you don't need
really fast response. Lots of columns are also not a big problem.
Join the tables, like you would to make a view, and store that in Solr.
But again, do not use Solr for transactional data.
wunder
On Nov 30, 2013, at 5:04 PM, subacini Arunkumar <subac...@gmail.com> wrote:
> Thanks Walter for the reply. Here is my complete requirement.
>
>
> Please let me know the possible solutions to address my requirement.
>
> * Two tables might have millions of records with 50 columns in each table
>
> * Expected output is same as what we get in SQL inner join
>
> say For Eg, I have two tables Product , Order table.
>
> *Product Table *
>
> id Name
>
> P1 ipad
>
> P2 iphone 4
>
> P3 iphone 5
>
> *Order Table*
>
> id order date product_id
>
> O1 1-Dec-2012 P1
>
> O2 1-Dec-2012 P2
>
> O3 2-Dec-2012 P2
>
>
> *Expected Output: *I want to show the details in UI as below [SQL inner
> join ]
>
> O1 01-Dec-2012 ipad
>
> O2 1-Dec-2012 iPhone 4
>
> O3 2-Dec-2012 iPhone 5
>
>
> I tried setting up two solr cores , Product core & Order Core
>
> *Option 1: Using Solr Join*
>
> I got expected result but i was able to get columns only from one core (ie)
> total 3 records but only product table columns
>
>
> http://<….>/product/select?q=*&fq={!join from=product_id to=id
> fromIndex=order}*
>
>
> *Option 2: Using shards*
>
> Created third core, but number of records is sum of(Product core + Order
> Core) as documents are of different types and they are all unique(ie) 6
> records
>
> So how could i generate a single document with all fields from two
> different document types in different cores.
>
>
> On Sat, Nov 30, 2013 at 8:04 AM, Walter Underwood
> <wun...@wunderwood.org>wrote:
>
>> 1. Flatten the data into a single table.
>>
>> 2. Solr does not seem like a good solution for order data, especially live
>> orders that need to be transactional. That is a great match to a standard
>> relational DB.
>>
>> wunder
>>
>> On Nov 30, 2013, at 12:15 AM, subacini Arunkumar <subac...@gmail.com>
>> wrote:
>>
>>> Hi
>>>
>>> We are using solr 4.4 . Please let me know the possible solutions to
>>> address my requirement.
>>>
>>> We have to fetch data from two tables Product , Order table.
>>>
>>> Product Table
>>>
>>> id Name
>>> P1 ipad
>>> P2 iphone 4
>>> P3 iphone 5
>>>
>>>
>>> Order Table
>>>
>>> id order date product_id
>>> O1 1-Dec-2012 P1
>>> O2 1-Dec-2012 P2
>>> O3 2-Dec-2012 P2
>>>
>>> I want to show the details in UI as below
>>>
>>> O1 01-Dec-2012
>>>
>>>
>>> On Sat, Nov 30, 2013 at 12:13 AM, subacini Arunkumar <subac...@gmail.com
>>> wrote:
>>>
>>>> Hi
>>>>
>>>> We are using solr 4.4 . Please let me know the possible solutions to
>>>> address my requirement.
>>>>
>>>> We have to fetch data from two tables Product , Order table.
>>>>
>>>> Product Table
>>>>
>>>> id Name
>>>> P1 ipad
>>>> P2 iphone 4
>>>> P3 iphone 5
>>>>
>>>>
>>>> Order Table
>>>>
>>>> id order date product_id
>>>> O1
>>>>
>>>>
>>
>> --
>> Walter Underwood
>> wun...@wunderwood.org
>>
>>
>>
>>
--
Walter Underwood
wun...@wunderwood.org
