Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALAO
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

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 Query

Translating SQL having clause in Solr query

2018-08-07 Thread SAGAR PALAO
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

Re: Problem with fuzzy search and accentuation

2018-08-07 Thread Monique Monteiro
Hi Erick, In fact, stemming was the culprit for the problem. Thanks! Monique Monteiro On Fri, Aug 3, 2018 at 3:45 PM Erick Erickson wrote: > Stemming is getting in the way here. You could probably use copyField > to a field that doesn't stem and fuzzy search against that field > rather than

Re: deprecated field types

2018-08-07 Thread Steve Rowe
I created a JIRA issue to track the Trie field removal effort: https://issues.apache.org/jira/browse/SOLR-12632 -- Steve www.lucidworks.com > On Aug 7, 2018, at 11:48 AM, Shawn Heisey wrote: > > On 8/6/2018 11:52 PM, Hendrik Haddorp wrote: >> Below the table the following is stated: >> /All

Re: executing /suggest in Admin Console

2018-08-07 Thread Shawn Heisey
On 8/6/2018 11:18 AM, Steve Pruitt wrote: > Changing the request handler to /suggest in the Admin Console Query panel > doesn't work. It was a guess on my part to see if it would. > > Is the way to do this, or do I need to always use browser, postman, etc. for > debugging? I've never used the

Re: deprecated field types

2018-08-07 Thread Shawn Heisey
On 8/6/2018 11:52 PM, Hendrik Haddorp wrote: Below the table the following is stated: /All Trie* numeric and date field types have been deprecated in favor of *Point field types. Point field types are better at range queries (speed, memory, disk), however simple field:value queries

Re: Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Erick Erickson
Bjarke: One thing, what version of Solr are you moving _from_ and _to_? Solr/Lucene only guarantee one major backward revision so you can copy an index created with Solr 6 to another Solr 6 or Solr 7, but you couldn't copy an index created with Solr 5 to Solr 7... Also note that shard splitting

Re: Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Rahul Singh
Bjarke, I am imagining that at some point you may need to shard that data if it grows. Or do you imagine this data to remain stagnant? Generally you want to add solrcloud to do two things : 1. Increase availability with replicas 2. Increase available data via shards 3. Increase fault tolerance

Re: Solr cloud in kubernetes

2018-08-07 Thread jonasdkhansen
Hi, i also got this running https://github.com/freedev/solrcloud-zookeeper-kubernetes My problem is also that instance 2 and 3 will not start. If i exec into them, and run bin/solr start -cloud, then i can start them on another port than 32080, but thats not what we want. Is anyone having a

Re: SolrQuery Highlight Problem - Not working for text

2018-08-07 Thread THADC
Thanks Erick, that indeed was the problem. All good now! -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Bjarke Buur Mortensen
Right, that seems like a way to go, will give it a try. Thanks! /Bjarke 2018-08-07 14:08 GMT+02:00 Markus Jelsma : > Hello Bjarke, > > You can use shard splitting: > https://lucene.apache.org/solr/guide/6_6/collections- > api.html#CollectionsAPI-splitshard > > Regards, > Markus > > > >

RE: Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Markus Jelsma
Hello Bjarke, You can use shard splitting: https://lucene.apache.org/solr/guide/6_6/collections-api.html#CollectionsAPI-splitshard Regards, Markus -Original message- > From:Bjarke Buur Mortensen > Sent: Tuesday 7th August 2018 13:47 > To: solr-user@lucene.apache.org > Subject: Re:

Re: Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Bjarke Buur Mortensen
Thank you, that is of course a way to go, but I would actually like to be able to shard ... Could I use your approach and add shards dynamically? 2018-08-07 13:28 GMT+02:00 Markus Jelsma : > Hello Bjarke, > > If you are not going to shard you can just create a 1 shard/1 replica > collection,

RE: Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Markus Jelsma
Hello Bjarke, If you are not going to shard you can just create a 1 shard/1 replica collection, shut down Solr, copy the data directory into the replica's directory and start up again. Regards, Markus -Original message- > From:Bjarke Buur Mortensen > Sent: Tuesday 7th August 2018

Recipe for moving to solr cloud without reindexing

2018-08-07 Thread Bjarke Buur Mortensen
Hi List, is there a cookbook recipe for moving an existing solr core to a solr cloud collection. We currently have a single machine with a large core (~150gb), and we would like to move to solr cloud. I haven't been able to find anything that reuses an existing index, so any pointers much

Re: Solr timeAllowed metric

2018-08-07 Thread Mikhail Khludnev
facet.method=fc not facet.method=fsc are not, but facet.method=enum has a chance to be stopped when timeAllowed is exceeded. On Tue, Aug 7, 2018 at 9:40 AM Wei wrote: > Thanks Mikhail! Is traditional facet subject to timeAllowed? > > On Mon, Aug 6, 2018 at 3:46 AM, Mikhail Khludnev wrote: > >

Re: Highlighting the search keywords

2018-08-07 Thread Renuka Srishti
First of all thanks to all, its a great community and amazing experience to work with Apache Solr. I was trying to use highlight component inside suggest request handler by mentioning highlight component like this: suggest highlight So I can use suggestions and highlighter at the same time,

Re: Block Join Faceting in Solr 7.2

2018-08-07 Thread Mikhail Khludnev
uniqueBlock is not faster than BlockJoinFacet in 7.4. On Tue, Aug 7, 2018 at 8:05 AM Aditya Gandhi wrote: > I'm querying an Index which has two types of child documents (let's call > them ChildTypeA and ChildTypeB) > I wrap the subqueries for each of these documents in a boolean clause, >

Re: Solr timeAllowed metric

2018-08-07 Thread Wei
Thanks Mikhail! Is traditional facet subject to timeAllowed? On Mon, Aug 6, 2018 at 3:46 AM, Mikhail Khludnev wrote: > One note: enum facets might be stopped by timeAllowed. > > On Mon, Aug 6, 2018 at 1:45 PM Mikhail Khludnev wrote: > > > Hello, Wei. > > > > "Document collection" is done along