Pivot facets - distributed search - request

Hi, Is there any way of requesting limit 10 order by a stat within facet pivot? I know that the "json facet" component can do this and it has a very comphrehensive api, but it has a problem of consistency (refinement) when querying across multiple shards. And given that pivot facets supports distr

Which line is solr following in terms of a BI Tool?

Hello, I think this topic is important for solr users that are planning to use solr as a BI Tool. Speaking about facets, nowadays there are three majors way of doing (more or less) the same in solr. First, you have the pivot facets, on the other hand you have the Analytics component and finally

Re: Which line is solr following in terms of a BI Tool?

; And, to make matters worse, the ParllelSQL way of doing some > > aggregations is going to give yet another approach. > > > > Best, > > Erick > > > > On Tue, Apr 12, 2016 at 7:15 AM, Pablo wrote: > > > Hello, > > > I think this topic is import

Create collections in SolrCloud "Could not get shard id for core"

Hey, I'm using solr 5.2.1 and yesterday I started migrating to SolrCloud so I might be quite noobish with it. The thing is that I could create 3 collections with not so many inconvenients, but when trying to create another collection it throws a timeout and inside solr log it says "Could not get sh

Lucene 5 Custom FieldComparator

know how to do this? Thanks a lot for the help. Regards, Pablo.

Lucene 5 Custom FieldComparator

know how to do this? Thanks a lot for the help. Regards, Pablo.

Lucene 5.2.1 Spatial Strategy PointVectorStrategy

alues type NONE for field 'location__x' (expected=NUMERIC) And for what I see it is impossible to use a specific FieldType with DocValuesType NUMERIC. Someone know how to fix this? Thanks a lot for the help. Regards, Pablo.

FieldCacheTermsFilter Replacement in Lucene 5.2.1

Hi, I'm doing a migration from Lucene 3.6.1 to 5.2.1, and for what I see FieldCacheTermsFilter does not exists any more. Is there any replacement for keep same functionality? Thanks for the help. Regards, Pablo.

OutOfMemoryError does not fire the script

Hello, I am using solr 5.2.1 in cloud mode. My jvm arguments for the OutOfMemoryError is -XX:OnOutOfMemoryError='/etc/init.d/solrcloud;restart' In the Solr UI, the event is beign fired, but nothing happens. What am I missing? Regards.

Re: OutOfMemoryError does not fire the script

Perfect, thank you very much. 2016-05-27 12:44 GMT-03:00 Shawn Heisey : > On 5/27/2016 7:05 AM, Pablo Anzorena wrote: > > I am using solr 5.2.1 in cloud mode. My jvm arguments for the > > OutOfMemoryError is > > -XX:OnOutOfMemoryError='/etc/init.d/solrcloud;restart&#x

SolrCloud SolrNode stopping randomly for no reason

Hey, I'am using SolrCloud with two nodes (5.2.1). One or two times a day the node1 is stopping for no reason. I checked the logs but no errors are beign logged. I also have a standalone solr service in both nodes running in production (we are doing the migration to SolrCloud, that's why). Thanks.

Re: SolrCloud SolrNode stopping randomly for no reason

gives an outofmemoryerror and the oom script is killing the process, but again I saw nothing in the solr_gc.log. 2016-06-07 10:18 GMT-03:00 Shawn Heisey : > On 6/7/2016 6:08 AM, Pablo Anzorena wrote: > > I'am using SolrCloud with two nodes (5.2.1). One or two times a day the >

No live SolrServers triggered by maxclausecount

Hi, I have an ensemble zookeeper consisting of 3 machines and 2 machines with solrcloud. With a high frequency I see in the logging: *No live SolrServers available to handle this request:[http://solr2:8983/solr/usa_bills_imp_2016_2016062300_shard1_replica1

Re: No live SolrServers triggered by maxclausecount

And if you use the TermsQueryParser, it's probably a good idea to sort > the list of terms, it's > more efficient. > > Or do a join or... because anything with that many terms will be > rather slow to say the least. > > Best, > Erick > > > On Mon, Jun 27, 2

Re: No live SolrServers triggered by maxclausecount

that your responsiveness will suffer if you come > anywhere near 100K OR clauses. Maybe that's OK, but > it's lurking out there. > > > And no I can't see the image, the Apache server is pretty > aggressive about stripping those too. > > Best, > Erick > &g

Re: Facet in SOLR Cloud vs Core

As long as you don't shard your index, you will have no problem migrating to solrcloud. The problem with the shards appears in the following scenario (note that the problem below also applies in a solr standalone enviroment with distributed search): Shard1: DATA_SOURCE1 (3 docs), DATA_SOURCE2 (2

Re: Facet in SOLR Cloud vs Core

Sorry for introducing bad information. Because it happens in the json facet api, I thought it would also happen in the facet. Soyrry again for the misunderstood. 2016-07-07 16:08 GMT-03:00 Chris Hostetter : > > : The problem with the shards appears in the following scenario (note that > : the pro

Is SolrCloudClient Singleton Pattern possible with multiple collections?

Hey, So the question is quite simple, Is it possible to use Singleton Pattern with SolrCloudClient instantiation and then reuse that instance to handle multiple requests concurrently accessing differente collections? Thanks.

Re: Is SolrCloudClient Singleton Pattern possible with multiple collections?

only when I need to request to multiple collections. Thanks. 2016-07-14 14:15 GMT-03:00 Erick Erickson : > Just use the > > public NamedList request(SolrRequest request, String collection) > > method on the SolrCloudClient? > > Best, > Erick > > On Thu, Jul 14,

Re: Is SolrCloudClient Singleton Pattern possible with multiple collections?

uery against. It's only > necessary when you want to go against a > collection that isn't the default which you can set with > setDefaultCollection() > > Best, > Erick > > On Thu, Jul 14, 2016 at 10:51 AM, Pablo Anzorena > wrote: > > I was using >

Parallel SQL where exists, in

Hey, Is anyone willing to add the where exists and in clauses into paraller sql? Thanks.

Re: Parallel SQL where exists, in

> > Best, > Erick > > On Tue, Jul 19, 2016 at 8:12 AM, Pablo Anzorena > wrote: > > Hey, > > > > Is anyone willing to add the where exists and in clauses into paraller > sql? > > > > Thanks. >

Re: Group and sum in SOLR 5.3

Using the json facet api is quite easy Check out: http://yonik.com/json-facet-api/#TermsFacet http://solr:8983/solr/your_collection/select?q=*:*&wt=json&indent=true&json.facet= { property_codes_group_by : { type : terms, field : property_code, facet : { sum_price : "sum(price)" } }

Does solr support two phase commit or any other distributed transaction protocol?

That's it. Thanks.

Re: Does solr support two phase commit or any other distributed transaction protocol?

n postgres. End of transaction. 2.1)If some problem occurs in solr, rollback solr and rollback postgres. End of transaction. 2016-08-09 11:24 GMT-03:00 Shawn Heisey : > On 8/9/2016 7:55 AM, Pablo Anzorena wrote: > > That's it. Thanks. > > Solr doesn't support transac

Consume sql response using solrj

Hey, I'm trying to get the response of solr via QueryResponse using QueryResponse queryResponse = client.query(solrParams); (where client is a CloudSolrClient) The error it thows is: org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException: Error from server at http://tywin:8983/solr

Re: Consume sql response using solrj

.com/ > > On Thu, Aug 11, 2016 at 10:05 AM, Pablo Anzorena > wrote: > > > Hey, > > > > I'm trying to get the response of solr via QueryResponse using > > QueryResponse queryResponse = client.query(solrParams); (where client is > a > > CloudSolrCli

Re: Consume sql response using solrj

-11 11:40 GMT-03:00 Pablo Anzorena : > Excellent! > > Thanks Joel > > 2016-08-11 11:19 GMT-03:00 Joel Bernstein : > >> There are two ways to do this with SolrJ: >> >> 1) Use the JDBC driver. >> >> 2) Use the SolrStream to send the request and then re

Re: Consume sql response using solrj

_query_=(a:c AND d:f) > > > > This should get translated to: > > > > _query_:(a:c AND d:f) > > > > This link describes the behavior of _query_ https://lucidworks. > > com/blog/2009/03/31/nested-queries-in-solr/ > > > > Just not positive how the S

Re: Solr 6 Configuration - java.net.SocketTimeoutException

I think it is under solr_path/server/etc/ a file name jetty.xml 2016-08-15 10:01 GMT-03:00 Stan Lee : > I currently doing a POC with SOLR 6 on my windows 7, with 16GB ram. > Successfully imported 16 million of documents from SQL Server, where one of > the SQL column is an XML. > Whenever I

Rollback solrcloud

Hey, I was trying to make a rollback under solrcloud and foundd that it's not supported https://issues.apache.org/jira/browse/SOLR-4895 (I have solr6.1.0) So my question is, how can I simulate a rollback? Actually what I'm doing is: 1. prepareCommit 2. add documents 3. try to commit

Posting files 405 http error

Hey, I'm indexing a file with a delete query in xml format using the post.jar. I have two solrclouds, which apparently have all the same configurations. The thing is that I have no problem when indexing in one of them, but the other keeps giving me this error: SimplePostTool version 5.0.0 Posting

Re: Posting files 405 http error

> the details in the solr log are often much more helpful > than what gets returned to the client. > > Best, > Erick > > On Tue, Nov 1, 2016 at 1:37 PM, Pablo Anzorena > wrote: > > Hey, > > > > I'm indexing a file with a delete query in xml format using t

Re: Posting files 405 http error

ot using jetty, I'm using solr-undertow https://github.com/kohesive/solr-undertow 2016-11-03 12:56 GMT-03:00 Shawn Heisey : > On 11/3/2016 9:10 AM, Pablo Anzorena wrote: > > Thanks for the answer. > > > > I checked the log and it wasn't logging anything. > > &

Re: Posting files 405 http error

d of <3a>, manually copy the data directory from the source > to each replica. > 4> In either 3a> or 3b>, it's probably easier to create a leader-only > (replicationFactor=1) destination collection then use the ADDREPLICA > command to add replicas, that way they'll all

Solr dynamic "on the fly fields"

Hey, I was wondering if there is some way to add fields "on the fly" based on arithmetic operations on other fields. For example add a new field "custom_field" = log(field1) + field2 -5. Thanks.

Re: Solr dynamic "on the fly fields"

y: > > see: https://cwiki.apache.org/confluence/display/solr/ > Update+Request+Processors#UpdateRequestProcessors- > UpdateRequestProcessorFactories > > Best, > Erick > > On Mon, Jul 3, 2017 at 10:52 AM, Pablo Anzorena > wrote: > > Hey, > > > > I was wondering if there is

Re: Solr dynamic "on the fly fields"

assuming your tenants don't talk to each > other > > Have you thought about using function queries to pull this data out as > needed at _query_ time? See: > https://cwiki.apache.org/confluence/display/solr/Function+Queries > > Best, > Erick > > On Mon, Jul 3, 20

How difficult is adding a new aggregate function to Json Facet?

Hey, it has been awhile since I'm using Solr, but I have never see the code. Now I'm in the need to add some capability to Solr. What I need to add is another aggregate function to Json Facet API, for example "sum(field1)-sum(field2)". How hard do you think it would be? Also, it would be great if

Re: Configuring Solr for Maximum Concurrency

Dave, there is something similar like MAX_CONNECTIONS and MAX_CONNECTIONS_PER_HOST which control the number of connections. Are you leaving open the connection to zookeeper after you establish it? Are you using the singleton pattern? 2016-12-28 14:14 GMT-03:00 Dave Seltzer : > Hi Erick, > > I'l

Pagination bug? when sorting by a field (not unique field)

t the intended behaviour, right? Solr version:5.2.1 Regards, Pablo.

Re: Pagination bug? when sorting by a field (not unique field)

Let me try. It is really hard to replicate it, but I will try out and come back when i got it. 2017-03-29 9:40 GMT-03:00 Erik Hatcher : > Certainly not intended behavior. Can you show us a way to replicate the > issue? > > > > On Mar 29, 2017, at 8:35 AM, Pablo Anzorena &g

Re: Pagination bug? when sorting by a field (not unique field)

sort? 2017-03-29 9:58 GMT-03:00 Shawn Heisey : > On 3/29/2017 6:35 AM, Pablo Anzorena wrote: > > I was paginating the results of a query and noticed that some > > documents were repeated across pagination buckets of 100 rows. When I > > sort by the unique field there is no repea

Re: Pagination bug? when sorting by a field (not unique field)

maxDocs is different by number of deleted docs, you can > see it in solr admin at the core page. > > On Wed, Mar 29, 2017 at 4:16 PM, Pablo Anzorena > wrote: > > > Shawn, > > > > Yes, the field has duplicate values and yes, if I add the secondary sort > by > &

Re: Pagination bug? when sorting by a field (not unique field)

with NormalizationH2 > and > > : > BM25) take account into avdl and would have notable change in ranked > list. > > : > Especially if you have a collection of documents with varying > lengths. > > : > Because NormalizationH2 tends to punish documents longer than avdl./ >

How to use Wordnet in solr?

ges, that's why it would be great to have solr using it. Regards, Pablo.

Re: How to use Wordnet in solr?

12:52 GMT-03:00 alessandro.benedetti : > Hi Pablo, > with wordnet format , Solr will just parse synonyms from a different file > format [1] . > The rest will work exactly the same. > You will use a managed resource to load the file and then potentially > update > it. > If you were thinking t

RE: NoClassDefFoundError while indexing in Solr

missing a transitive tika dependency (http://freecode.com/projects/jhighlight). Copying the lib in solr runtime lib directory should solve your issue. Pablo. From: Shalin Shekhar Mangar Sent: Wednesday, July 23, 2014 7:43 AM To: solr-user@lucene.apache.o

How to return a function result instead of doclist in the Solr collapsing/grouping feature?

I have the following solr fields in schema.xml: - id (string) - name (string) - category(string) - latitude (double) - longitude(double) Is it possible to make a query that groups by category and returns the average of latitude and longitude instead of the doclist? Thanks, Pablo

Get field value in custom searchcomponent (solr 3.3)

er.nextDoc(); String tlat = slat.lookup[slat.order[docID]]; if (tlat != null) { float lat = Float.parseFloat(tlat); //Exception! } } } Thanks, Pablo

Re: Implementing Search Suggestion on Solr

others’ mistakes, so you do not have to make them yourself. from ' http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036' > > EARTH has a Right To Life, > otherwise we all die. > > > --- On Mon, 10/18/10, Pablo Recio Quijano wrote: > >> From: Pabl

Re: Implementing Search Suggestion on Solr

Hi, I don't want to be annoying, but I'm looking for a way to do that. I repeat the question: is there a way to implement Search Suggestion manually? Thanks in advance. Regards, 2010/10/18 Pablo Recio Quijano > Hi! > > I'm trying to implement some kind of Search Sugge

Re: Implementing Search Suggestion on Solr

you shared, maybe I will implement it, thanks! 2010/10/27 Jakub Godawa > I am a real rookie at solr, but try this: > http://solr.pl/2010/10/18/solr-and-autocomplete-part-1/?lang=en > > 2010/10/27 Pablo Recio > > > Hi, > > > > I don't want to be annoying, but

Possible bug in query sorting

Hi all. I'm having a problem with solr sorting search results. When I try to make a query and sort it by title: http://localhost:8983/solr/select/?q=*%3A*&version=2.2&start=0&rows=10&indent=on&sort=title%20desc I get that error [1]. If I try to sort by other indexed field it works, indeed if I c

Re: Possible bug in query sorting

That's my schema XML: link text ... 2010/10/28 Gora Mohanty > On Thu, Oct 28, 2010 at 5:18 PM, Michael McCandless > wrote: > >

need some guidance about how to configure a specific solr solution.

he writer solr server content into the readers. Please can you provide advice about that? Thanks, Pablo This e-mail may contain confidential and/or privileged information for the sole use of the intended recipient. Any review or distribution by anyone other than the person for whom it was o

Clustering not working when using 'text' field as snippet.

27;t debug solr.clustering.ClusteringComponent nor CarrotClusteringEngine yet, but am I misunderstanding something about the 'text' Field ? Thanks, Pablo.

RE: Clustering not working when using 'text' field as snippet.

. ;-) Pablo. -Message d'origine- De : stac...@gmail.com [mailto:stac...@gmail.com] De la part de Stanislaw Osinski Envoyé : vendredi 12 août 2011 11:00 À : solr-user@lucene.apache.org Objet : Re: Clustering not working when using 'text' field as snippet. Hi Pablo, The reason clu

Re: Adding docs from MySQL and php

ing about using DataImportHandler in any of this two ways: - Write a script that creates a table with all the information I need for searching (it is not very efficient because of duplicate data) - Configure DataImportHandler with some JOIN SQL statement I'll let you know how I did, thanks aga

Re: Adding docs from MySQL and php

wow, it looks like DIH already works with relational databases... thanks again! 2009/9/1 Pablo Ferrari > Thanks Aakash! > > I've looked at it and it looks very interesting, the problem is that my > database is a relational model, therefore I don't have a table with all

PhP, Solr and Delta Imports

document I have to do a full import again or I can delete the document by its id and add it again with the updated info... Anyone can guide me a bit in how to do delta imports? If its via php, better! Thanks in advance, Pablo Ferrari Tinkerlabs.net

Control DIH from PHP

nding anything useful so far. Thank you for you time! Pablo Tinkerlabs

Re: Control DIH from PHP

Most specificly, I'm looking to update only one document using it's Unique ID: I dont want the DIH to lookup the whole database because I already know the Unique ID that has changed. Pablo 2009/11/19 Pablo Ferrari > > > Hello! > > After been working in Solr documents

Re: Control DIH from PHP

st_parameters > . > > --Noble > > > > On Thu, Nov 19, 2009 at 3:53 PM, Pablo Ferrari > wrote: > >> Most specificly, I'm looking to update only one document using it's > Unique > >> ID: I dont want the DIH to lookup the whole database because I alre

SEVERE: java.lang.NumberFormatException: For input string: "104708<"

Hello, Solr is raising the following exception when processing queries that sort on integer attribute. The same queries and sorts have been running fine in production for almost a year now. If I run the query without the sort on the integer attribute, the query runs fine. If I run a query that

Re: SEVERE: java.lang.NumberFormatException: For input string: "104708<"

> TrieIntField) that does do validation at index time, and is just as > efficient for sorting. > > -Yonik > http://www.lucidimagination.com > > > On Fri, Feb 26, 2010 at 9:59 AM, Pablo Mercado wrote: >> Hello, >> >> Solr is raising the following exception when

Re: SEVERE: java.lang.NumberFormatException: For input string: "104708<"

A big thanks to Yonik and Mark. Using the raw term query I was able to find the range(!) of documents that had bad integer field values. Deleting those documents, committing and optimizing cleared up the issue. Still not sure how the bad values were inserted in the first place, but that is anothe

ubuntu lucid package

Hi I've installed solr-tomcat package on ubuntu lucid (10.04 latest). It automatically install java and tomcat and hopefully all other dependencies. I can access tomcat at http://localhost:8080 but not sure where to find the solr web admin http://localhost:8180 gives me nothing. Is this package k

Re: ubuntu lucid package

http://localhost:8080/solr/admin/ gives me the solr admin. thanks On Fri, Apr 30, 2010 at 10:24 AM, Gora Mohanty wrote: > On Thu, 29 Apr 2010 19:54:49 -0700 (PDT) > Otis Gospodnetic wrote: > > > Pablo, Ubuntu Lucid is *brand* new :) > > > > try: > > find /

Re: ubuntu lucid package

what parts doesn't work for you? If there are bugs in the package it will be great if you can report them to make it better. On Fri, Apr 30, 2010 at 1:50 PM, Olivier Dobberkau wrote: > > Am 30.04.2010 um 09:24 schrieb Gora Mohanty: > > > Also, the standard Debian/Ubuntu way of finding out what f

Re: Licensing issue advice for Solr.

No answer from my side, but if you like to search the mailing list, you can try this: http://markmail.org/search/?q=license+list%3Aorg.apache.lucene.solr-user On 24.03.2017 18:53, russell.lemas...@comcast.net wrote: Hi all, I'm just getting started with Solr (6.4.2) and am trying to get appr

Extend the Solr Terms Component to implement a customized Autosuggest

sfy my requirements in an efficient way? If there is another way without using the terms component for me is also awesome. Thanks Juan Pablo Albuja Senior Developer

Grouping or Facet ?

I need to do some counts on a StrField field to suggest options from two different categories, and I don´t know what option is the best: My schema looks: - id - name - category: XX or YY with Grouping I do: http://localhost:8983/?q=name:prefix*&group=true&group.field=category But I can change

RE: Grouping or Facet ?

De: Erick Erickson [erickerick...@gmail.com] Enviado el: lunes, 05 de diciembre de 2011 14:48 Para: solr-user@lucene.apache.org Asunto: Re: Grouping or Facet ? Why not just use the first form of the document and just facet.field=category? You'll get two diffe

Re: Grouping or Facet ?

eld. So it would help me if you showed the output of faceting on a >>>> single >>>> category field and why that didn't work for you >>>> >>>> But either way, faceting will probably outperform grouping. >>>> >>

RE: Solr Optimization Fail

Maybe you are generating a snapshot of your index attached to the optimize ??? Look for post-commit or post-optimize events in your solr-config.xml De: Rajani Maski [rajinima...@gmail.com] Enviado el: viernes, 16 de diciembre de 2011 11:11 Para: solr-user@l

Implementing Search Suggestion on Solr

Hi! I'm trying to implement some kind of Search Suggestion on a search engine I have implemented. This search suggestions should not be automatically like the one described for the SpellCheckComponent [1]. I'm looking something like: "SAS oppositions" => "Public job offers for some-company"

RE: SOLR 3.3 DIH and Java 1.6

Some versions of the OpenJDK doesn´t include the Rhino Engine to run javascript dataimport. You have to use the Oracle JDK. Juampa. De: randolf.julian [randolf.jul...@dominionenterprises.com] Enviado el: martes, 20 de marzo de 2012 5:41 Para: solr-user@luc

RE: problems with search in solr

Remove the stemmer filter. "Caso" and "casa" are transformed into "cas" if you use the stemmer filter. En español: Quita el filtro de stemmer, que se usa para sacar la raiz de las palabras, pero en tu caso la raíz de "casa" y "caso" es la misma, "cas". Un saludo. __

RE: Transform a SolrDocument into a SolrInputDocument

I answered myself a similar question here: http://stackoverflow.com/questions/4037625/change-schema-in-solr-without-reindex I Hope it helps De: Marc SCHNEIDER [marc.schneide...@gmail.com] Enviado el: lunes, 21 de marzo de 2011 15:20 Para: solr-user@lucene

Re: Matching on a multi valued field

>> A multiValued field >> is actually a single field with all data separated with positionIncrement. >> Try setting that value high enough and use a PhraseQuery. That is true but you cannot do things like: q="bar* foo*"~10 with default query search. and if you use dismax you will have the same

Re: Matching on a multi valued field

ian.l...@journalexperts.com>> wrote: Thank you all for your responses. The field had already been set up with positionIncrementGap=100 so I just needed to add in the slop. On Tue, Mar 29, 2011 at 6:32 PM, Juan Pablo Mora mailto:jua...@informa.es>> wrote: >> A multiValued field

Highlight, Dismax and local params

Hello, I think I have found something extrange with local params and edismax. If I do querys like : "params":{ "hl.requireFieldMatch":"true", "hl.fragsize":"200", "json.wrf":"callback0", "indent":"on", "hl.fl":"domicilio,deno", "wt":"json", "hl":"true",

Solr :: Snapshooter Cannot allocate memory

Thanks for your help Pablo

Solr Slaves Sync

high active connections when moving Slaves back to LB Pool. Has anybody faced this situation in production envs ? Thanks Pablo