Re: JOIN query

2020-01-08 Thread Mikhail Khludnev
Hi, Paresh. I'm afraid the only way is to join them back in post processing https://lucene.apache.org/solr/guide/6_6/transforming-result-documents.html#TransformingResultDocuments-_subquery_ Although, I'm not sure it will ever work with particular collections. On Wed, Jan 8, 2020 at 3:42 PM

Re: Edismax ignoring queries containing booleans

2020-01-08 Thread Edward Ribeiro
Hi Claire, Unfortunately I didn't see anything in the debug explain that could potentially be the source of the problem. As Saurabh, I tested on a core and it worked for me. I suggest that you simplify the solrconfig (commenting out qf, mm, spellchecker config and pf, for example) and reload the

Re: Tlogs are not purged when CDCR is enabled

2020-01-08 Thread Louis
Another finding is, no matter how I tried to disable buffer with the following setup on target node, it is always enabled first time. disabled Once I call CDCR API to disable buffer, it turns to be disabled. I wonder if https://issues.apache.org/jira/browse/SOLR-11652 is related

tlogs are not purged when CDCR is enabled

2020-01-08 Thread Louis
Using Solr 7.7.3-snapshot, 1 shard + 3 replicas on source and target cluster When unidirectional CDCR enabled and buffer disabled, my understanding is, when data is successfully forwarded to target and committed, tlogs on both source and target should be purged. However, the source node doesn't

Re: Solr spatial search - overlapRatio of polygons

2020-01-08 Thread David Smiley
Your English is perfect. I forwarded my response without your contact info. I *do* follow solr-users but only certain key words like "spatial" (and some other topics) and some words related to that domain (e.g. polygon, etc.). I so your post would have gotten my attention. On Wed, Jan 8, 2020

Fwd: Solr spatial search - overlapRatio of polygons

2020-01-08 Thread David Smiley
My response to a direct email (copying here with permission): It's possible; you'll certainly have to write some code here to make this work, including some new Solr plugin; perhaps ValueSourceParser that can compute a more accurate overlap. Such a thing would have to get the Spatial4J Shape

Re: support need in solr for min and max

2020-01-08 Thread Mel Mason
Try looking at range JSON facets: https://lucene.apache.org/solr/guide/8_2/json-facet-api.html#range-facet. If you facet over the eventTimeStamp with a gap of 1 day, you should then be able to use a sub facet to return a min and max value

RE: Edismax ignoring queries containing booleans

2020-01-08 Thread Claire Pollard
It would be lovely to be able to use range to complete my searches, but sadly documents aren't necessarily sequential so I might want say 18, 24 or 30 in future. I've re-run the query with debug on. Is there anything here that looks unusual? Thanks. { "responseHeader":{ "status":0,

Re: support need in solr for min and max

2020-01-08 Thread Walter Underwood
I hope you do not plan to use Solr as a primary repository. Solr is NOT a database. If you use Solr as a database, you will lose data at some point. The Solr feature set is very different from MySQL. There is no guarantee that a SQL query can be translated into a Solr query. wunder Walter

JOIN query

2020-01-08 Thread Paresh
Hi, I have two collections: collection1 and collection2 I have fields like - colleciton1: id, prop1, prop2, prop3 collection2: id, col1, col2, col3 I am doing a join query with collection1.prop1 = collection2.col1 on collection2. As a result, I can get any field from collection2 in 'fl'. Is

support need in solr for min and max

2020-01-08 Thread Mohamed Azharuddin
Hi team, We are migrating from mysql to apache solr since solr is fast in searching. Thank you. We had a scenario to > *find 1) difference (max-min)* *2) with group by date(timeStamp)* Given below is our mysql table : [image: Untitled.png] And mysql query is, *SELECT

Re: Solr 8.4.0 Cloud Graph is not shown due to CSP

2020-01-08 Thread Jörn Franke
I have to admit it was the cache. Sorry I believed I deleted it. Thanks for the efforts and testing ! I will update the Jira. > Am 07.01.2020 um 22:14 schrieb Jörn Franke : > >  > here you go: > https://issues.apache.org/jira/browse/SOLR-14176 > > a detailed screenshot of the message can be