Hi
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.
