Hi,
I have two table to be indexed.
Table-1: Person [id,name,addr]
Table-2: Docs [id,doc_name,person_id]
Relationship is: One person can have many documents.
I would like to get json as follows
[ { id : name, address,[doc_id1, doc_id2, doc_id3,etc] }]
How would I configure this in Solr.
How
Hi All,
I wanted to achieve something similar
[ { last_name : jain, training_skill:[c, c++, php,java,.net] }]
[{person_id : 111, documents :
[doc_1,doc_2,doc_3,doc4,doc5,doc6]}]
Meaning one person could have more than one document.
how do we need to write the query, and configure data fields.
Hi All,
I managed to *solve* the issue I had posted earlier with respect to
multiValued.
Here is the Query suppose to configured this way in *data-config.xml *
Description: in the below, first query has associated table images. Each
person would have many images. Here the JSON/XML would return
Hi All,
I managed to *solve* the issue I had posted earlier with respect to
multiValued.
Here is the Query suppose to configured this way in *data-config.xml *
Description: in the below, first query has associated table images. Each
person would have many images. Here the JSON/XML would return
Hi,
I have a confusion over choosing Cores or Shards for the project scenario.
My scenario is as follows
I have three entities
1. Customers
2. Product Info
3. Listings [Contains all the listings posted by customer based on product]
I'm planning to design Solr structure for the above scenario
Can you provide sample structure of the document with entities, how does the
document look like?.
As far as I can assume, you do not need to apply any filters. If you are
entities are searchable include them in the fulltext or keyword research.
Is your entities are part of the document and are
I'm not sure about the root cause in your case. However one thing to remember
while MLT is that, *MLT does not work with integer fields*.
In your case if 'catchall' is copyField and if you are trying to copy any
integer values verify it again :-).
Thanks
--
View this message in context:
Hi Eric,
Thanks for your reply.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solr-design-Choose-Cores-or-Shards-tp4082930p4083178.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hi All,
I have a multiValued field, and it returns the result in the following
manner
doc
str name=fnameMicheal/str
str name=lnameSchumacher/str
arr name=phones
str090933434343/str
str052323232323/str
str073628362782/str
/arr
/doc
In the above document phones is multiValued and
Hi Tamanjit,
Not really :-).
**phones** is an multiValued. Usually solr will produce list of array of
values without naming each row something like this
doc
str name=fnameMicheal/str
str name=lnameSchumacher/str
arr name=phones
str090933434343/str
str052323232323/str
Hi Jack,
Thank you for the suggestions.
I'm using DIH and the field names mobile,home,office comes as database
fields. And 'phones' field is defined in schema.xml as multiValued.
in DIH I'm using sub-entity for 'phones' fields.
Let me give a try based on your suggestion :-).
Thank you
--
Hi,
Following post help you.
http://stackoverflow.com/questions/7512945/solr-error-opening-new-searcher-exceeded-limit-of-maxwarmingsearchers-2-try
Thanks
--
View this message in context:
Yes it is
facet.sort=index would return facet result set in alphabetical order
--
View this message in context:
http://lucene.472066.n3.nabble.com/solr-sort-facets-by-name-tp4099499p4099522.html
Sent from the Solr - User mailing list archive at Nabble.com.
I'm not sure if my answer would help you :-).
Usually we do not need to know the min and max prices that our current
database or solr is holding for all the products. Even if you were to that,
would be complex and just make your business logic bigger and tedious.
Instead, we would know what is
Hey Peter,
Now I understood your requirement :-).
I come across this http://wiki.apache.org/solr/StatsComponent
have a look if it helps you :-).
--
View this message in context:
http://lucene.472066.n3.nabble.com/get-min-max-prices-as-facets-tp4099501p4099737.html
Sent from the Solr - User
How do I set default value for int fields
ex
field name=mileage type=int indexed=true stored=true
multiValued=false default=/
While indexing lets say if I have not set the value for mileage, and solr
tries to assign default value and it fails. Because *mileage* is of type int
not string. It
Hi Rob,
mlti-core approach is different. You could have two cares lets say
marketing-core [Has its own schema.xml and data-config.xml]
magento-core [Has its own schema.xml and data-config.xml]
each core have their own schema.xml and data-config.xml
If you go by multi-core approach I guess you
Eric,
Just a question :-), wouldn't it be easy to use DIH to pull data from
multiple data sources.
I do use DIH to do that comfortably. I have three data sources
- MySQL
- URLDataSource that returns XML from an .NET application
- URLDataSource that connects to an API and return XML
Here is
Erick,
Thanks for replying :-).
If I were to do that, we are trying to set string value to int and Solr
throws an error.
field name=mileage type=int indexed=true stored=true
multiValued=false default=5/
Oh wait, I guess it works because Solr would automatically parse based on
the data type of
Hi,
If we can not analyse string field, is there any other way to apply case
insensitiveness.
Ex: I have a field called *make* its values are Toyota, Honda, Chery etc. In
Solr make data type is string and values are stored as they appear (Toyota,
Honda, Chery).
However, when user try to search
Hi Iori,
Thank you replying, really appreciate that.
My concern not to use *TextField* and I want to make use of *string* field.
Reason is that I have 7 fields that I want to apply case-insensitiveness and
all these fields are *facetable* fields. It would not be feasible if I
change data type
Hi Jim Glynn,
KAMACI is correct. How do you discriminate your documents?.
Jim and Kamaci,
I do have the same situation where I will be boosting document regular basis
and expect documents with higher score appears on top and lower one at the
bottom.
Here is my requirement.
My entity name is
I don't understand. Use the field type *Ahmet* recommended. Who is Ahmet?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Difference-between-textfield-and-strfield-tp3986916p4105570.html
Sent from the Solr - User mailing list archive at Nabble.com.
Could it be achieved using multiple request handlers?
Example:
http://localhost:8983/solr/my/wiki
http://localhost:8983/solr/my/blog
http://localhost:8983/solr/my/forum
As we could configure config for each request handler to specify the query.
It would be great if Solr supports to query those
Hey Iori,
Apologize for misunderstanding :-).
Yes agree with you, faceting will be OK with TextField type however I'm
concern about performance impact while running the facets if we have
millions of documents.
I wish in future we could apply tokensizers and filters to String fields.
:-).Thanks
Hi All,
In database, MYSQL DateTime format is 2013-10-17 15:32:48 [-MM-dd
hh:mm:ss] however, when I store this DateTime field in solr as String, it
would look something like this 2013-10-17 15:32:48*.0*.
Why the 0 is appended at the end of the DateTime?
For the same date field, I do have
Hi Shekhar,
Thanks for replying :-).
Yes your answer is justifiable.
DateFormatTransformer was a good consideration. However it doesn't out the
format I expected. Rather it outputs in the following manner
str name=publish_dateTue Jun 05 00:00:00 MYT 2012/str
Here is DIH configuration
field
Hi Shekhar,
Yes, I did specify transformer=DateFormatTransformer in entity and I
did re-index :-(.
Bit strange output.
Even I tried to change the Data type of the data field in schema.xml as
well.
I have tried with changing date type from String to Date and Date to String
by applying
OK here are the scenarios I tried.
*Scenario - 1: *
dih.xml (aka data-config.xml)
entity dataSource=solr name=listing query=...
transformer=DateFormatTransformer
field name=quot;publish_datequot; column=quot;publish_datequot;
xpath=quot;/RDF/item/datequot;
Hi NewRelic is good enough to monitor the Solr.
Are you using Solarium or SolrJ client to connect to Solr?.
We have used Solarium and able to monitor each calls and gather most of the
info.
--
View this message in context:
Hi Raymond,
You mean during the DIH execution?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4107136.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hi Shekhar,
Yes :-).
Thanks for the references. Will try out the options you mentioned.
Thanks
--
View this message in context:
http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4107135.html
Sent from the Solr - User mailing list archive at
Hi Raymond,
Let me give a try. Thanks for suggestion :-).
Cheers,
On Wed, Dec 18, 2013 at 12:38 AM, Raymond Wiker [via Lucene]
ml-node+s472066n410713...@n3.nabble.com wrote:
On 17 Dec 2013, at 17:30 , manju16832003 [hidden
email]http://user/SendEmail.jtp?type=nodenode=4107138i=0
wrote
Hi Puneet,
if you type field is pre-determined text field ex type [compact, sedan,
hatchback], I think you have to boost with query type field (q) to
get more accurate boosting.
Ex: http://localhost:8983/solr/my/select?q=type:sedan^100 type:compact^10
Hi Puneet,
http://localhost:8983/solr/my/select?q=type:sedan^100 type:compact^10
(:*)^1wt=jsonindent=truefl=,scoredebug=resultsbf=recip(rord(publish_date),1,2,3)^1.5sort=score
desc
Not really. The query I mentioned it does not restrict the other types,
instead it would push other types to
I found a way to store MySQL DateTime as a string in Solr
Here is the way
in data-config.xml in the SQL query we could convert the date directly to
char
CAST(l.creation_date as char) as creation_date,
CAST(l.modification_date as char) as modification_date,
in schema.xml
field
Hi Tariq,
I'm glad that helped you :-).
Thanks
--
View this message in context:
http://lucene.472066.n3.nabble.com/Solved-Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4112979.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hi,
In an application I'm working on, I have applied two types of search
criteria to Solr.
First one is a definitive search using filter query (fq) where by I know
exactly the fields I'm searching for.
Secondly I use eDisMax for full-text search, this would be applied when user
enters keywords.
Hi,
I'm facing a dilemma of choosing the indexing strategies.
My application architecture is
- I have a listing table in my DB
- For each listing, I have 3 calls to a URL Datasource of different system
I have 200k records
Time taken to index 25 docs is 1Minute, so for 200k it might take
Hi Erick,
Thank you very much, those are valuable suggestions :-).
I would give a try.
Appreciate your time.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Indexing-strategies-tp4116852p4117050.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hi,
I come across the issue with urlencoding between PHP and Solr.
I have a field indexed with value *WBE(Honda Edix)* in Solr.
From PHP codes, if I urlencode($string) and send to Solr, I do not get the
accurate results.
Here is the part of the solr query *fq=model:WBE(Honda+Edix)*
However, If I
Hi Shawn and Rico,
Thanks you for your suggestions, those are valuable suggestions :-).
If Pharse Query does not work as we expected sometimes, I guess we could use
*TermQuery* instead.
http://blog.florian-hopf.de/2013/01/make-your-filters-match-faceting-in-solr.html
This worked fine
Solr already writes the logs to a file 'solr.log'. Its located in the same
folder as start.jar (logs/solr.log).
I'm not sure if thats what you looking for :-).
--
View this message in context:
http://lucene.472066.n3.nabble.com/start-jar-config-tp4119201p4119203.html
Sent from the Solr - User
I'm not sure if I would be missing any configuration params here, however
when I tried to assign an xpath field from URLDataSource (XML end point) to
two fields defined in schema.xml.
Here is my scenario,
I have two fields
*profile_display* and *profile_indexed*
My assignment in DataImpotHandler
I tried to use *CachedSqlEntityProcessor* in DataImportHandler with
Sub-entity query. It does not seems to be working.
Here is my query
entity name=listing dataSource=mysql query=SELECT id,make, model FROM
LISTING
entity name=account dataSource=mssql query=SELECT name,email FROM
CUSTOMER WHERE
Hi All,
I'm using latest version of Solr 4.7.1 and was wondering if there is a way
to share common schema.xml.
Here is my use case.
I have two cores which would have same schema structure.
Core 1 = Stores Active Records
Core 2 = All records regardless of the status
Both the cores would have the
Thanks Dmitry,
Yes I'm on *nix OS. Yes *soft-link* was mentioned by one of my sys-admin
friend as well. :-).
I was just trying to from the community if there there would be a way from
Solr itself.
Thanks for suggestion. Probably soft-link is the way to go now :-).
--
View this message in
HI,
I have a scenario where by I apply boosting in the following two cases
- Usual search, by user selection
- Keyword search. I have a field *keyword* that is copy/combination of many
fields
When user does the usual query, my boosting works fines, this is how I do
boosting
The *fq* is used for searching more deterministic results something like
WHERE type={}
Where as *q* is something like WHERE type like '%%'
user *fq*, if your are sure of what your going to search
use *q*, if not sure what your trying to search
If you are using fq and if you do not get any
Hi Jack,
Thanks for your help.
I do not want to boost *keyword* field. I apply full text search no keyword
field and boost based on another field *featured*.
Also qf field allows us to boost the field without values. I would like to
boost with value
Ex: qf=featured:true^100 - I don't think this
Hi Jack,
Thank you for the suggestions. :-)
--
View this message in context:
http://lucene.472066.n3.nabble.com/Applying-boosting-for-keyword-search-tp4137523p4138239.html
Sent from the Solr - User mailing list archive at Nabble.com.
Hi Erick,
Your explanation leads me to one question :-)
if
*/select?q=featured:true^100fq=make:toyotasort=featured_date desc,price
asc*
The above query, without edismax, works well because, If I'm not mistaken
its boosting document by value method.
So I'm boosting all my documents with the
Solr 5 has been released. I was just giving a try and come across the same
issue. As I heard over from some documentation, Solr 5 doesn't come with
default core (example in earlier versions). And this requires us to create
a core from Solr Admin. When I tried to create the core, I get the
53 matches
Mail list logo