Re:
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 P1ipad P2iphone 4 P3iphone 5 Order Table id order date product_id O1 1-Dec-2012 P1 O2 1-Dec-2012P2 O3 2-Dec-2012 P2 I want to show the details in UI as below O101-Dec-2012 On Sat, Nov 30, 2013 at 12:13 AM, subacini Arunkumar subac...@gmail.comwrote: 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 P1ipad P2iphone 4 P3iphone 5 Order Table id order date product_id O1
single solr document with all fields from two different document types
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
P1ipad
P2iphone 4
P3iphone 5
*Order Table*
id order date product_id
O1 1-Dec-2012 P1
O2 1-Dec-2012P2
O3 2-Dec-2012 P2
*Expected Output: *I want to show the details in UI as below [SQL inner
join ]
O101-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.
Re:
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
P1ipad
P2iphone 4
P3iphone 5
*Order Table*
id order date product_id
O1 1-Dec-2012 P1
O2 1-Dec-2012P2
O3 2-Dec-2012 P2
*Expected Output: *I want to show the details in UI as below [SQL inner
join ]
O101-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.orgwrote:
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
P1ipad
P2iphone 4
P3iphone 5
Order Table
id order date product_id
O1 1-Dec-2012 P1
O2 1-Dec-2012P2
O3 2-Dec-2012 P2
I want to show the details in UI as below
O101-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
P1ipad
P2iphone 4
P3iphone 5
Order Table
id order date product_id
O1
--
Walter Underwood
wun...@wunderwood.org
Re:
I have product core, order core ,Is there a way in solr to fetch all
fields from two cores in a single query?Solr join can fetch fields from
only 1 core.
If we cant , how to achieve this??, is the only option is to index
denormalize data??
On Sat, Nov 30, 2013 at 8:08 PM, Walter Underwood wun...@wunderwood.orgwrote:
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
P1ipad
P2iphone 4
P3iphone 5
*Order Table*
id order date product_id
O1 1-Dec-2012 P1
O2 1-Dec-2012P2
O3 2-Dec-2012 P2
*Expected Output: *I want to show the details in UI as below [SQL inner
join ]
O101-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
P1ipad
P2iphone 4
P3iphone 5
Order Table
id order date product_id
O1 1-Dec-2012 P1
O2 1-Dec-2012P2
O3 2-Dec-2012 P2
I want to show the details in UI as below
O101-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
P1ipad
P2iphone 4
P3iphone 5
Order Table
id order date product_id
O1
--
Walter Underwood
wun...@wunderwood.org
--
Walter Underwood
wun...@wunderwood.org
Solr 3.5 and 4.4 - ParsedQuery is different for q=*
Hi Team, We are upgrading from Solr 3.5 to Solr 4.4. The response from 3.5 and 4.4 are different. I have attached request and response [highlighted the major difference in RED] Can you please let me know how to change parsedQuery from *MatchAllDocsQuery to text.* *Also, in solr 4.4 if fq or q param has * , we are having this issue. Otheriwse parsedQuery value is text:searchStr* *Solr 4.4 Request:* http://server:7982/nip/select/?q=*fq=MODULE_ID%3A**\**debug=true *Solr 4.4 Repsonse:* response lst name=responseHeader int name=status0/int int name=QTime59/int /lst result name=response *numFound=0* start=0/ lst name=debug str name=rawquerystring*/str str name=querystring*/str str name=parsedquery*MatchAllDocsQuery(*:**)/str str name=parsedquery_toString**:**/str lst name=explain/ str name=QParserLuceneQParser/str arr name=filter_queries strMODULE_ID:**\**/str /arr arr name=parsed_filter_queries strMODULE_ID*:**\***/str /arr lst name=timing.../lst /lst /response *Solr 3.5 Request* http://server:7982/nip/select/?q=*fq=MODULE_ID%3A**\**debugQuery=true *Solr 3.5 Response* response lst name=responseHeader int name=status0/int int name=QTime1458/int /lst result name=response numFound=*146928* start=0 doc.../doc doc.../doc doc.../doc doc.../doc doc.../doc doc.../doc doc.../doc doc.../doc doc.../doc doc.../doc /result lst name=debug str name=rawquerystring*/str str name=querystring*/str str name=parsedquery*text:**/str str name=parsedquery_toString*text:**/str lst name=explain.../lst str name=QParserLuceneQParser/str arr name=filter_queries strMODULE_ID:**\**/str /arr arr name=parsed_filter_queries strMODULE_ID:/str /arr lst name=timing.../lst /lst /response Thanks, Subacini
upgrading from Solr 3.5 to Solr 4.X
Hi Solr Team, We are planning to upgrade from Solr 3.5 to Solr 4.x version. Appreciate if you can provide any pointers/documentation on step by step by changes. Also, the reason for upgrading is to use Solr join [not solr cloud or any other feature]. So which version is better Solr 4.0 or higher version considering the changes to be minimal during upgradation. Thanks, Subacini
