Query regarding integrating solr query functions into blockfacetjoin Query

2021-02-22 Thread Ravi Kumar
Hi Team, I was implementing block join faceting query in my project and was stuck in integrating the existing functional queries in the block join faceting query. *The current query using 'select' handler is as follows* :- https://localhost:8983/solr/master_Product_default/*select*?*yq*

Re: Solr query with space (only) gives error

2021-01-09 Thread vstuart
Cross-posted / addressed (both me), here. https://stackoverflow.com/questions/65620642/solr-query-with-space-only-q-20-stalls/65638561#65638561 -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Solr query with space (only) gives error

2021-01-09 Thread vstuart
Cross-posted / addressed (both me), here. https://stackoverflow.com/questions/65620642/solr-query-with-space-only-q-20-stalls/65638561#65638561 -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Solr query with space (only) gives error

2021-01-07 Thread vstuart
I have a frontend that uses Ajax to query Solr. It's working well, but if I enter a single space (nothing else) in the input/search box (the URL in the browser will show ... index.html#q=%20 In that circumstance I get a 400 error (as there are no parameters in the request), which is fine,

Solr query with space (only) gives error

2021-01-07 Thread vstuart
I have a frontend that uses Ajax to query Solr. It's working well, but if I enter a single space (nothing else) in the input/search box (the URL in the browser will show ... index.html#q=%20 In that circumstance I get a 400 error (as there are no parameters in the request), which is fine,

Re: solr query returns items with spaces removed

2020-07-29 Thread Erick Erickson
data value if it >> exists, otherwise an empty string? I'm integrating this with a 3rd party >> app which I can't change. When the field is null it isn't showing up in the >> output. >>> >>> -Original Message- >>> From: Erick Erickson >&

Re: solr query returns items with spaces removed

2020-07-29 Thread David Hastings
d is null it isn't showing up in the > output. > > > > -Original Message- > > From: Erick Erickson > > Sent: Wednesday, July 29, 2020 12:49 PM > > To: solr-user@lucene.apache.org > > Subject: Re: solr query returns items with spaces removed > > > >

Re: solr query returns items with spaces removed

2020-07-29 Thread Erick Erickson
r@lucene.apache.org > Subject: Re: solr query returns items with spaces removed > > The “def” function goes after the _indexed_ value, so that’s what you’re > getting back. Try just specifying “fl=INSTRUCTIONS”, and if the value is > stored that should return the original fiel

RE: solr query returns items with spaces removed

2020-07-29 Thread Teresa McMains
, July 29, 2020 12:49 PM To: solr-user@lucene.apache.org Subject: Re: solr query returns items with spaces removed The “def” function goes after the _indexed_ value, so that’s what you’re getting back. Try just specifying “fl=INSTRUCTIONS”, and if the value is stored that should return

Re: solr query returns items with spaces removed

2020-07-29 Thread Erick Erickson
The “def” function goes after the _indexed_ value, so that’s what you’re getting back. Try just specifying “fl=INSTRUCTIONS”, and if the value is stored that should return the original field value before any analysis is done. Why are you using the def function? If the field is absent from the

solr query returns items with spaces removed

2020-07-29 Thread Teresa McMains
I am sure I'm doing something silly. Basically it looks like my data is being altered upon search. This is my fieldType: I have a string field called "INSTRUCTIONS" using this field type that looks like this: ABC_D=

solr query to return matched text to regex with default schema

2020-07-07 Thread Phillip Wu
Hi, I want to search Solr for server names in a set of Microsoft Word documents, PDF, and image files like jpg,gif. Server names are given by the regular expression(regex) INFP[a-zA-z0-9]{3,9} TRKP[a-zA-z0-9]{3,9} PLCP[a-zA-z0-9]{3,9} SQRP[a-zA-z0-9]{3,9} Problem === I want to get the

Re: Solr Query

2020-07-07 Thread Furkan KAMACI
Hi Swetha, Given URL is encoded. So, you can decode it before analyzing. Plus character is used for whitespaces when you encode a URL and minus sign represents a negative query in Solr. Kind Regards, Furkan KAMACI On Tue, Jul 7, 2020 at 9:16 PM swetha vemula wrote: > Hi, > > I have an URL and

Solr Query

2020-07-07 Thread swetha vemula
Hi, I have an URL and I want to break this down and run it in the admin console but I am not what is ++ and - represents in the query.

Re: How to use two search string in a single solr query

2020-07-03 Thread Tushar Arora
Hi Thanks Erick and Walter for your response. Solr Version Used : 6.5.0 I tried to elaborate the issue: Case 1 : Search String : Industrial Electric Oven Results=945 Case 2 : Search String : Dell laptop bags Results=992 In above both cases, mm play its role.(match

Re: How to use two search string in a single solr query

2020-07-02 Thread Walter Underwood
First, remove the “mm” parameter from the request handler definition. That can be added back in and tweaked later, or just left out. Second, you don’t need any query syntax to search for two words. This query should work fine: books bags wunder Walter Underwood wun...@wunderwood.org

Re: How to use two search string in a single solr query

2020-07-02 Thread Erick Erickson
Please let s know what version of Solr you use, otherwise it’s very hard to know whether you’re running into https://issues.apache.org/jira/browse/SOLR-8812 or similar. But two things to try: 1> specify q.op lr 2> specify mm=0% Best, Erick > On Jul 2, 2020, at 1:22 AM, Tushar Arora wrote: > >

How to use two search string in a single solr query

2020-07-01 Thread Tushar Arora
Hi, I have a scenario with following entry in the request handler(handler1) of solrconfig.xml.(defType=edismax is used) description category title^4 demand^0.3 2-1 4-30% When I searched 'bags' as a search string, solr returned 15000 results. Query Used :

Re: Lucene query to Solr query

2020-06-01 Thread gnandre
Is this odd use-case where one needs to convert Lucene query to Solr query? Isn't this normal use-case when somebody is trying to port their Lucene code to Solr? I mean, is it like a XY problem where I should not even run into this problem in the first place? On Sun, May 31, 2020 at 9:40 AM

Re: Lucene query to Solr query

2020-05-31 Thread Mikhail Khludnev
abble.com/Lucene-Query-to-Solr-query-td493751.html > > > As suggested in that thread, I do not want to use toString method for > Lucene query to pass it to the q param in SolrQuery. > > I am looking for a function that accepts org.apache.lucene.search.Query and > returns org.apac

Re: Lucene query to Solr query

2020-05-30 Thread gnandre
I think this question here in this thread is similar to my question. https://lucene.472066.n3.nabble.com/Lucene-Query-to-Solr-query-td493751.html As suggested in that thread, I do not want to use toString method for Lucene query to pass it to the q param in SolrQuery. I am looking

Re: Lucene query to Solr query

2020-05-30 Thread Erick Erickson
607211 (topics:146)^0.008187325 > -asset_id:doc:en:index.html > > But, it does not work if I use it as a solr query with lucene as defType. > > For it to work, I need to convert it like following: > q=+((topics:132)^0.02607211 (topics:146)^0.008187325 > +(-(asset_id:doc\:en\:index.html

Lucene query to Solr query

2020-05-29 Thread gnandre
Hi, I have following query which works fine as a lucene query: +(topics:132)^0.02607211 (topics:146)^0.008187325 -asset_id:doc:en:index.html But, it does not work if I use it as a solr query with lucene as defType. For it to work, I need to convert it like following: q=+((topics:132)^0.02607211

Re: Why Solr query time is more in case the searched value frequency is more even if no sorting is applied, for the same number of rows?

2020-05-15 Thread Paras Lehana
Well, in a way, QTime can depend on the total number of terms existing in the core. It would have been better if you had posted sample query and analysis chain. On Mon, 11 May 2020 at 11:45, Anshuman Singh wrote: > Suppose I have two phone numbers P1 and P2 and the number of records with > P1

Why Solr query time is more in case the searched value frequency is more even if no sorting is applied, for the same number of rows?

2020-05-11 Thread Anshuman Singh
Suppose I have two phone numbers P1 and P2 and the number of records with P1 are X and with P2 are 2X (2 times X) respectively. If I query for R rows for P1 and P2, the QTime in case of P2 is more. I am not specifying any sort parameter and the number of rows I'm asking for is same in both the

Re: Solr query Slow in Solr 6.1.0

2020-03-19 Thread Erick Erickson
ltAccess:(true) AND -blockedUsers:(1) AND -blockedRoles:( > 6440215 6368478) OR (isLatestRevPrivate:(true) AND > allowedUsersForPvtRev:(1) AND -folderadmin_list:(1))) AND > (doc_ref:((*KON\-N2*) )) AND (title:((*cdrl*) )) > > Is it possible? How does Solr execute th

Solr query Slow in Solr 6.1.0

2020-03-19 Thread vishal patel
))) AND (doc_ref:((*KON\-N2*) )) AND (title:((*cdrl*) )) Is it possible? How does Solr execute this query? field sequence is matter for performance? I want to know the step by step Solr query execution same like database query because I will arrange field for better performance. Regards, Vishal Sent from

Re: strange behavior of solr query parser

2020-03-02 Thread Hongtai Xue
/bf9db95f218f49bac8e7971eb953a9fd9d13a2f0#diff-269ae02e56283ced3ce781cce21b3147R563 sincerely hongtai 送信元: "Staley, Phil R - DCF" Reply-To: "d...@lucene.apache.org" 日付: 2020年3月2日 月曜日 22:38 宛先: solr_user lucene_apache , "d...@lucene.apache.org" 件名: Re: strange behavior of solr query parser

Question About Solr Query Parser

2020-03-02 Thread Kayak28
Hello, Community: I have a question about interpreting a parsed query from Debug Query. I used Solr 8.4.1 and LuceneQueryParser. I was learning the behavior of ManagedSynonymFilter because I was curious about how "ManagedSynonymGraphFilter" fails to generate a graph. So, I try to interpret the

Re: strange behavior of solr query parser

2020-03-02 Thread Staley, Phil R - DCF
lucene_apache Cc: d...@lucene.apache.org Subject: strange behavior of solr query parser Hi, Our team found a strange behavior of solr query parser. In some specific cases, some conditional clauses on unindexed field will be ignored. for query like, q=A:1 OR B:1 OR A:2 OR B:2 if field B

strange behavior of solr query parser

2020-03-02 Thread Hongtai Xue
Hi, Our team found a strange behavior of solr query parser. In some specific cases, some conditional clauses on unindexed field will be ignored. for query like, q=A:1 OR B:1 OR A:2 OR B:2 if field B is not indexed(but docValues="true"), "B:1" will be lost. but if you wri

Position And Offset in Solr Query

2020-02-27 Thread ????
Hi all, I am working in Chinese App. I am suffering a question of whether a PhraseQuery involved StartOffset and EndOffset of a term on SOLR. For instance: Text: ?? Indexing: ??|??||||??||?? position: 1 | 2| 3 | 4| 4 | 5 | 5 | 5 querying:

Re: Lucene query to Solr query

2020-01-22 Thread Edward Ribeiro
cs:29)^2 (topics:38)^3 +(-id:41135) >> >> It works fine when I am using it as a lucene query in >> SolrIndexSearcher.getDocList function. >> >> However, now I want to use it as a Solr query and query against a >> collection. I tried to use the as-is representation from Lucene query >> object's toString method but it does not work. How should I proceed? >> >

Re: Lucene query to Solr query

2020-01-22 Thread Edward Ribeiro
tring represenation of Lucene's > Query object): > > +(topics:29)^2 (topics:38)^3 +(-id:41135) > > It works fine when I am using it as a lucene query in > SolrIndexSearcher.getDocList function. > > However, now I want to use it as a Solr query and query against a > collection

Lucene query to Solr query

2020-01-19 Thread Arnold Bronley
Hi, I have a Lucene query as following (toString represenation of Lucene's Query object): +(topics:29)^2 (topics:38)^3 +(-id:41135) It works fine when I am using it as a lucene query in SolrIndexSearcher.getDocList function. However, now I want to use it as a Solr query and query against

Odata filter query to Solr query

2020-01-15 Thread sambasivarao giddaluri
Hi All, Do we have any library which can convert Odata filter to Solr Query EX : $filter=Address eq 'Redmond' to ?q=Address:Redmond Any suggestions will help. Thanks Sambasiva

Re: Solr query fetching different results

2019-09-19 Thread Erick Erickson
Multiple replicas of the same shard will execute their autocommits at different wall clock times. Thus there may be a _temporary_ time when newly-indexed document is found by a query that happens to get served by replica1 but not by replica2. If you have a timestamp in the doc, and a soft commit

Solr query fetching different results

2019-09-18 Thread Jayadevan Maymala
Hi all, There is something "strange' happening in our Solr cluster. If I execute a query from the server, via solarium client, I get one result. If I execute the same or similar query from admin Panel, I get another result. If I go to Admin Panel - Collections - Select Collection and click

Re: Solr query exclude parent when no _childDocuments exists

2019-08-29 Thread Mikhail Khludnev
Hello. _text_=kids is not a query syntax Solr supports. Last time I've looked into, mixing doc blocks and childfree docs is not supported. Anyway, debugQuery=true usually helps to understand puzzling results. On Thu, Aug 29, 2019 at 2:19 AM craftlogan wrote: > So in Solr I have a data

Solr query exclude parent when no _childDocuments exists

2019-08-28 Thread craftlogan
So in Solr I have a data structure that is made of of Restaurant Documents that have Deals attached as _childDocuments to a Restaurant. However with my current query {!parent which='content_type:restaurant'}_text_=kids =*,[child parentFilter=content_type:restaurant childFilter="content_type:deal

Re: Solr query is very slow -- guidance would be much appreciated

2019-08-22 Thread Erick Erickson
If you’re literally including the quotes, i.e. q=“one two”, then you’re doing phrase searches which are more complex and will take longer. q=field:one AND field:two is a straight boolean query. Also, what query parser are you using? If it’s edismax, then you’re searching across multiple fields.

Solr query is very slow -- guidance would be much appreciated

2019-08-22 Thread Muthu Thenappan
Hi, when I run "q=one" the Qtime is around 200ms however when I run 2 or 3 words the run time exponentially increases eg: "q=two words" or "q=apple orange berry" resulting in 3s to 10s. I have indexed around 10 milion document with each document containing around 100 words. I am using that

Solr query with best match returning high score

2019-07-03 Thread mganeshs
Hello Experts, I have a following query product:TV or os:Android or size:(55 60 65) or brand:samsung or issmart:yes or ram:[4 TO *] or rate:[10 TO *] or bezel : no or sound:dolby In Total there are 9 conditions. Now I need the document with best match should return top. Best match I mean

Re: Solr query with long query

2019-05-31 Thread Erick Erickson
and get the > results from solr and display them on PCAT. > > But as per new requirement , we need to invoke third party service to fetch > the personalized products and send them to Solr get the results. that is > the reason i was tying to send those products in solr query. >

Re: Solr query with long query

2019-05-30 Thread Venkateswarlu Bommineni
products and send them to Solr get the results. that is the reason i was tying to send those products in solr query. @Eric : we are using Solr 7.2.1 version. I will check on solr cache. Thanks, Venkat. On Thu, May 30, 2019 at 7:53 PM Erick Erickson wrote: > What version of Solr? Recent versi

Re: Solr query with long query

2019-05-30 Thread Erick Erickson
What version of Solr? Recent versions automatically use terms query parser for large, simple or clauses. Do look into using it anyway. And I'd set cache=false because I doubt you'll ever get a cache hit... On Thu, May 30, 2019, 16:21 Venkateswarlu Bommineni wrote: > Hello Team, > > I have got a

Re: Solr query with long query

2019-05-30 Thread Tim Casey
Venkat, There is another way to do this. If you have a category of "thing" you are attempting to filter over, then you create a query and tag the documents with this category. So, create a 'categories' field and append 'thing' to the field updating the field if need be. (Be wary of over

Re: Solr query with long query

2019-05-30 Thread Shawn Heisey
On 5/30/2019 4:13 PM, Venkateswarlu Bommineni wrote: Thank you guys for quick response. I was able to query solr by sending 1500 products using solrJ with http post method. But I had to change maxBooleanClauses to 4096 from default 1024. But I wanted to check with you guys that, will there be

Re: Solr query with long query

2019-05-30 Thread Venkateswarlu Bommineni
Thank you guys for quick response. I was able to query solr by sending 1500 products using solrJ with http post method. But I had to change maxBooleanClauses to 4096 from default 1024. But I wanted to check with you guys that, will there be any performance issues by changing maxBooleanClauses

Re: Solr query with long query

2019-05-30 Thread Shawn Heisey
On 5/30/2019 2:20 PM, Venkateswarlu Bommineni wrote: I have got a requirement to send many strings (~1500) in the filter query param to the solr. Can you please provide any suggestions/precautions we need to take care in this particular scenario. You'll probably want to send that as a POST,

Re: Solr query with long query

2019-05-30 Thread Alexandre Rafalovitch
You can use POST instead of GET. But you may also want to see if you can refactor those 1500 strings somehow. If you don't use it already, maybe Terms query parser could be useful: https://lucene.apache.org/solr/guide/7_7/other-parsers.html#terms-query-parser Also, if at least some of those

Solr query with long query

2019-05-30 Thread Venkateswarlu Bommineni
Hello Team, I have got a requirement to send many strings (~1500) in the filter query param to the solr. Can you please provide any suggestions/precautions we need to take care in this particular scenario. Thanks, Venkat.

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-13 Thread Shawn Heisey
On 5/13/2019 2:51 AM, vishal patel wrote: Executing an identical query again will likely satisfy the query from Solr's caches. Solr won't need to talk to the actual index, and it will be REALLY fast. Even a massively complex query, if it is cached, will be fast. All caches are disabled in

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-13 Thread Erick Erickson
Oh, and you can freely set docValues=true _and_ have indexed=true on the same field, Solr will use the right structure for the operations it needs. HOWEVER: if you change that definition you _must_ re-index the entire collection. > On May 13, 2019, at 1:22 AM, Bernd Fehling > wrote: > > Your

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-13 Thread Erick Erickson
That indicates you’re hitting the queryResultCache, which is also supported by your statement about how fast queries are returned after they’re run once. Look at admin UI>>select core>>stats/plugins>>cache>>queryResultCache and you’ll probably see a very hit ratio, approaching 1. You also have

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-13 Thread vishal patel
cet? If I do not do a separate field then any performance issue when the same field will search in a query? Sent from Outlook<http://aka.ms/weboutlook> From: Bernd Fehling Sent: Monday, May 13, 2019 11:52 AM To: solr-user@lucene.apache.org Subject: Re: Solr qu

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-13 Thread vishal patel
hema file because of our indexing and searching ratio is high in our live environment. Sent from Outlook<http://aka.ms/weboutlook> From: Shawn Heisey Sent: Friday, May 10, 2019 9:32 PM To: solr-user@lucene.apache.org Subject: Re: Solr query takes a too mu

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-13 Thread Bernd Fehling
Your "sort" parameter has "sort=id+desc,id+desc". 1. It doesn't make sense to have a sort on "id" in descending order twice. 2. Be aware that the id field has the highest cadinality. 3. To speedup sorting have a separate field with docValues=true for sorting. E.g. Regards Bernd Am

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-10 Thread Shawn Heisey
On 5/10/2019 7:32 AM, vishal patel wrote: We have 2 shards and 2 replicas in Live environment. we have multiple collections. Some times some query takes much time(QTime=52552). There are so many documents indexing and searching within milliseconds. There could be any number of causes of

Re: Solr query takes a too much time in Solr 6.1.0

2019-05-10 Thread David Hastings
first inclination is your index is cold. On Fri, May 10, 2019 at 9:32 AM vishal patel wrote: > We have 2 shards and 2 replicas in Live environment. we have multiple > collections. > Some times some query takes much time(QTime=52552). There are so many > documents indexing and searching within

Solr query takes a too much time in Solr 6.1.0

2019-05-10 Thread vishal patel
We have 2 shards and 2 replicas in Live environment. we have multiple collections. Some times some query takes much time(QTime=52552). There are so many documents indexing and searching within milliseconds. When we executed the same query again using admin panel, it does not take a much time

Re: Solr query particular value of a field last

2019-04-14 Thread Anuj Bhargava
Thanks Saurabh And Prince, Works perfectly. On Sun, 14 Apr 2019 at 17:21, Prince Manohar wrote: > Basically, you need to boost some documents low. > > For this, you can either use solr’s Boost Query ( bq ) or Boost Function > (bf) > parameter. > > For example in your case:- > > If you want the

Re: Solr query particular value of a field last

2019-04-14 Thread Prince Manohar
Basically, you need to boost some documents low. For this, you can either use solr’s Boost Query ( bq ) or Boost Function (bf) parameter. For example in your case:- If you want the documents with countries A and B to show last in the result, you can use:- bq=( country:A OR country:B )^-1 Note

Re: Solr query particular value of a field last

2019-04-14 Thread Saurabh Sharma
fq=country :c1 OR c2 OR c3=if(termfreq (country,c2),0,1) desc Correcting query. On Sun 14 Apr, 2019, 3:36 PM Saurabh Sharma, wrote: > I would suggest to sort on the basis of condition. First find all the > records and then sort on the basis of condition where you will be putting > spcific

Re: Solr query particular value of a field last

2019-04-14 Thread Saurabh Sharma
I would suggest to sort on the basis of condition. First find all the records and then sort on the basis of condition where you will be putting spcific countries below other. fq=country :c1 OR c2 OR c3=if(termfreq (country,c2),1,0) desc Here we are putting c2 below c1 and c3. You can also try

Solr query particular value of a field last

2019-04-14 Thread Anuj Bhargava
I have a field *country*. I need to do a search in which I need to show the search result of a country or some countries, last in the search result for eg. country code *BD*. What query should I use to get the above result. fq=country:???=*%3A*

Re: Solr query high response time

2019-03-22 Thread Shawn Heisey
On 3/22/2019 7:52 AM, Rajdeep Sahoo wrote: My solr query sometime taking more than 60 sec to return the response . Is there any way I can check why it is taking so much time . Please let me know if there is any way to analyse this issue(high response time ) .Thanks With the information

Solr query high response time

2019-03-22 Thread Rajdeep Sahoo
Hi all, My solr query sometime taking more than 60 sec to return the response . Is there any way I can check why it is taking so much time . Please let me know if there is any way to analyse this issue(high response time ) .Thanks

Re: solr-query

2019-01-20 Thread Aman Tandon
Hi Shilpa, I am assuming you know the functionality of synonym. Synonym in Solr can be applied over the tokens getting indexed/queried for the field. In order to apply synonym to a field you need to update the configuration file schema.xml where you also define a file (synonym.txt is default,

solr-query

2019-01-18 Thread Shilpa Solanki
Hello, can you ask me how we use synonyms with apache solr. Thanks & Regards, Shilpa solanki

Re: Solr Query running slow in Prod node

2019-01-09 Thread Zheng Lin Edwin Yeo
wrote: > Hello, > We have a Solr query that runs much slower in Production Solr cluster > compared with lower environments.(Yes they may not be apples to apples > comparison but it's really slow in prod as HDFS gets pounded) > What are the general ways to track/trouble shoot slowne

Solr Query running slow in Prod node

2019-01-09 Thread Dasarathi Minjur
Hello, We have a Solr query that runs much slower in Production Solr cluster compared with lower environments.(Yes they may not be apples to apples comparison but it's really slow in prod as HDFS gets pounded) What are the general ways to track/trouble shoot slowness in the query. Is there any

Re: Tool to format the solr query for easier reading?

2019-01-08 Thread Jan Høydahl
I find myself doing exactly the same, so such a tool would be wonderful. I sometimes use the Solr Query Debugger <https://chrome.google.com/webstore/detail/solr-query-debugger/gmpkeiamnmccifccnbfljffkcnacmmdl> Chrome plugin but that does not help with decoding the q parameter, only to

SV: SV: Tool to format the solr query for easier reading?

2019-01-08 Thread Hullegård , Jimi
lucene.apache.org Ämne: Re: SV: Tool to format the solr query for easier reading? Hi Jimi, I recalled that the Chrome plugin would do this, obviously it's not a perfect solution for you as you've prefer a Java formatter but it's a start - have you tried this one? Best Charlie > > /J

Re: SV: Tool to format the solr query for easier reading?

2019-01-08 Thread Charlie Hull
On 08/01/2019 09:20, Hullegård, Jimi wrote: Hi Charlie, Care to elaborate on that a little? I can't seem to find any tool in that blog entry that formats a given solr query. What tool did you have in mind? Hi Jimi, I recalled that the Chrome plugin would do this, obviously it's

Re: SV: Tool to format the solr query for easier reading?

2019-01-08 Thread Charlie Hull
On 08/01/2019 09:20, Hullegård, Jimi wrote: Hi Charlie, Care to elaborate on that a little? I can't seem to find any tool in that blog entry that formats a given solr query. What tool did you have in mind? This also does some basic URL splitting: https://www.freeformatter.com/url-parser

SV: Tool to format the solr query for easier reading?

2019-01-08 Thread Hullegård , Jimi
Hi Charlie, Care to elaborate on that a little? I can't seem to find any tool in that blog entry that formats a given solr query. What tool did you have in mind? /Jimi -Ursprungligt meddelande- Från: Charlie Hull Skickat: den 8 januari 2019 15:55 Till: solr-user@lucene.apache.org Ämne

Re: Tool to format the solr query for easier reading?

2019-01-08 Thread Charlie Hull
On 08/01/2019 04:33, Hullegård, Jimi wrote: Hi, Hi Jimi, There are some suggestions in part 4 of my recent blog: http://www.flax.co.uk/blog/2018/11/15/defining-relevance-engineering-part-4-tools/ Cheers Charlie I often find myself having to analyze an already existing solr query

Tool to format the solr query for easier reading?

2019-01-07 Thread Hullegård , Jimi
Hi, I often find myself having to analyze an already existing solr query. But when the number of clauses and/or number of nested parentheses reach a certain level I can no longer grasp what the query is about by just a quick glance. Sometimes I can look at the code generating the query

Re: Solr query response time analysis

2018-11-19 Thread Tanapol Nearunchorn
, Nov 20, 2018, 00:35 Chris Ulicny Rajdeep, > > Not an external tool, but there is the option of using the "debug" > parameter in the Solr query that can be used at least as a starting point > for looking at the query timing. > > > https://lucene.apache.

Re: Solr query response time analysis

2018-11-19 Thread Chris Ulicny
Rajdeep, Not an external tool, but there is the option of using the "debug" parameter in the Solr query that can be used at least as a starting point for looking at the query timing. https://lucene.apache.org/solr/guide/6_6/common-query-parameters.html#CommonQueryParameters-Thedebu

Solr query response time analysis

2018-11-19 Thread Rajdeep Sahoo
Hi all, Please suggest, how can I analyze the time taken by a solr query? Is there any tool for analyzing the query response time.I f there is any way to do this please suggest.

Re: Is it possible to escape some texts from Solr query?

2018-09-04 Thread Erick Erickson
Alexandre's response is probably a better solution, assuming that the field in question isn't complex, for instance: http://localhost:8983/solr/techproducts/query?q={!term f=id}AND Be aware that this requires that the value for the field (AND in this case) be exactly as it appears in the index as

Re: Is it possible to escape some texts from Solr query?

2018-09-04 Thread Alexandre Rafalovitch
As Erick said, you need to be looking into Query Parsers. There are many, depending on what search you are actually allowing your users to do. You probably know lucene/default, dismax and edismax, but there are many more: http://lucene.apache.org/solr/guide/7_4/other-parsers.html For example, you

Re: Is it possible to escape some texts from Solr query?

2018-09-04 Thread Erick Erickson
This is a query _parsing_ issue, way before a tokenizer ever gets to it. The problem of course is that AND is an operator in the query language, so your problem is how to distinguish it from the value of a field. You can always quote the input for id, as in id:"AND" which you could do for

Is it possible to escape some texts from Solr query?

2018-09-04 Thread girish.vignesh
One of the ID attribute which we are using to query is AND so our looks like http://localhost:8983/solr//select?fq=id:AND=json This throws below mentioned exception error: { metadata: [ "error-class", "org.apache.solr.common.SolrException", "root-error-class",

Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALAO
ove to Solr Query partially using pivot facet. But how do I have the having clause implemented in my Solr Query. Without having clause in place the number of records is too large and so the pivoting on A is returning a very large result. In addition the number of distinct value for A is also very h

Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALO
Hi Guys, I am new to the Solr world and I am using Solr 5.4.1. I have a question and hope to find answer to the same. Consider a SQL query as: select A, sum(B), sum(C) from Col1 where D = ‘Test’ group by A having sum(B) > 20 order by A limit 100 I am able to translate the above to Solr Qu

Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALAO
ove to Solr Query partially using pivot facet. But how do I have the having clause implemented in my Solr Query. Without having clause in place the number of records is too large and so the pivoting on A is returning a very large result. In addition the number of distinct value for A is also very h

Solr query string compare to actual date and build a new string on this?

2018-05-31 Thread servus01
Hey, digging the web for a while now to find a solution due to a complex search string. what i've got: xml file with a date/description fields which are not part of the index: (start-date-time="2018-04-01T18:00:00.000+02:00" code-name="MD 28") (start-date-time="2018-04-07T15:00:00.000+02:00"

Re: solr query

2018-03-15 Thread Walter Underwood
t;>> Hi Emir, >>> >>> If using OR-ed conditions for different years then the query will be very >>> long if I got 100 years and I think this is not practical. >>> You have any other idea? >>> >>> Regards, >>> Albert >>>

RE: solr query

2018-03-15 Thread Stefan Matheis
birthdate_year, birthdate_month, > birthdate_day. > Is this practical adding so much additional fields? > > Albert > From: Stefan Matheis > Sent: Thursday, March 15, 2018 3:05 PM > To: solr-user@lucene.apache.org > Subject: RE: solr query > > > You have any other idea? > &

RE: solr query

2018-03-15 Thread Albert Lee
: Stefan Matheis Sent: Thursday, March 15, 2018 3:05 PM To: solr-user@lucene.apache.org Subject: RE: solr query > You have any other idea? Yes, we go back to start and discuss again why you're not adding a separate field for that. It's the simplest thing possible and avoids all those workarou

RE: solr query

2018-03-15 Thread Stefan Matheis
M > To: solr-user@lucene.apache.org > Subject: Re: solr query > > I think you have inadvertently "corrected" the intentional exclusive end on > my range... [NOW/MONTH TO NOW/MONTH+1MONTH} > > On Wed, Mar 14, 2018 at 12:08 PM, Emir Arnautović < > emir.arnauto...@sem

RE: solr query

2018-03-14 Thread Albert Lee
Hi Emir, If using OR-ed conditions for different years then the query will be very long if I got 100 years and I think this is not practical. You have any other idea? Regards, Albert From: Gus Heck Sent: Thursday, March 15, 2018 12:43 AM To: solr-user@lucene.apache.org Subject: Re: solr query

Re: solr query

2018-03-14 Thread Emir Arnautović
ng Support Training - http://sematext.com/ >>>> >>>> >>>> >>>>> On 14 Mar 2018, at 10:53, Albert Lee <albertlee8...@gmail.com> wrote: >>>>> >>>>> I don’t want to add separate fields since I have many da

Re: solr query

2018-03-14 Thread Gus Heck
- Alerting - Anomaly Detection > >> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > >> > >> > >> > >>> On 14 Mar 2018, at 10:53, Albert Lee <albertlee8...@gmail.com> wrote: > >>> > >>> I

Re: solr query

2018-03-14 Thread Emir Arnautović
sematext.com/ >> >> >> >>> On 14 Mar 2018, at 10:53, Albert Lee <albertlee8...@gmail.com> wrote: >>> >>> I don’t want to add separate fields since I have many dates to index. >> How to index it as timestamp and do function query, any ex

Re: solr query

2018-03-14 Thread Gus Heck
> > > > From: Emir Arnautović > > Sent: Wednesday, March 14, 2018 5:38 PM > > To: solr-user@lucene.apache.org > > Subject: Re: solr query > > > > Hi Albert, > > The simplest solution is to index month/year as separate fields. > Alternative is t

Re: solr query

2018-03-14 Thread Emir Arnautović
r Arnautović > Sent: Wednesday, March 14, 2018 5:38 PM > To: solr-user@lucene.apache.org > Subject: Re: solr query > > Hi Albert, > The simplest solution is to index month/year as separate fields. Alternative > is to index it as timestamp and do function query to do some m

  1   2   3   4   5   6   7   8   >