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

2017-07-15 Thread Pablo Anzorena
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

Re: Solr dynamic "on the fly fields"

2017-07-05 Thread Pablo Anzorena
gets created. I'm 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 > >

Re: Solr dynamic "on the fly fields"

2017-07-03 Thread Pablo Anzorena
ttps://cwiki.apache.org/confluence/display/solr/ > Update+Request+Processors#UpdateRequestProcessors- > UpdateRequestProcessorFactories > > Best, > Erick > > On Mon, Jul 3, 2017 at 10:52 AM, Pablo Anzorena <anzorena.f...@gmail.com> > wrote: > > Hey, > > >

Solr dynamic "on the fly fields"

2017-07-03 Thread Pablo Anzorena
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: How to use Wordnet in solr?

2017-04-21 Thread Pablo Anzorena
Thanks to everybody. I will try first Alessandro and Steve recommendation. If i don't misunderstood, you are telling me that I have to customize the prolog files to "solr txt synonyms syntax"? If that is correct, what is the point of format:wordnet ? 2017-04-21 12:52 GMT-03:00

How to use Wordnet in solr?

2017-04-21 Thread Pablo Anzorena
Hey, I'm planning to use Wordnet and I want to know how. There's a class called *WordnetSynonymParser *, does anybody use it? It says it is experimental... I'm using solr 5.2.1 Briefly speaking about my needs: I have different collections in different languages (fr, pr, sp, en). When the user

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

2017-04-01 Thread Pablo Anzorena
Excellent guns, thank you very much! El mar. 29, 2017 18:09, "Erick Erickson" escribió: > You might be helped by "distributed IDF". > see: SOLR-1632 > > On Wed, Mar 29, 2017 at 1:56 PM, Chris Hostetter > wrote: > > > > The thing to keep in

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

2017-03-29 Thread Pablo Anzorena
is the same, but 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 <anzorena.f...@gmail.com> > wrote: > > > Shawn, > > > > Yes, the field has du

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

2017-03-29 Thread Pablo Anzorena
in the sort? 2017-03-29 9:58 GMT-03:00 Shawn Heisey <apa...@elyograg.org>: > 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 > &g

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

2017-03-29 Thread Pablo Anzorena
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 <erik.hatc...@gmail.com>: > Certainly not intended behavior. Can you show us a way to replicate the > issue? > > > > On Mar 29, 2017, at

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

2017-03-29 Thread Pablo Anzorena
Hey, 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 repeated document but when I sort by another field then repeated documents appear. I assume is a bug and it's not the

Re: Configuring Solr for Maximum Concurrency

2016-12-28 Thread Pablo Anzorena
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

Re: Posting files 405 http error

2016-11-03 Thread Pablo Anzorena
lt;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 sync automatic

Re: Posting files 405 http error

2016-11-03 Thread Pablo Anzorena
solr-undertow https://github.com/kohesive/solr-undertow 2016-11-03 12:56 GMT-03:00 Shawn Heisey <apa...@elyograg.org>: > On 11/3/2016 9:10 AM, Pablo Anzorena wrote: > > Thanks for the answer. > > > > I checked the log and it wasn't logging anything. > > > > T

Re: Posting files 405 http error

2016-11-03 Thread Pablo Anzorena
pect. > > 2> 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 <anzorena.f...@gmail.com> > wrote: > > Hey, > > > > I'm indexing a file wit

Posting files 405 http error

2016-11-01 Thread Pablo Anzorena
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

Rollback solrcloud

2016-10-06 Thread Pablo Anzorena
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

Re: Solr 6 Configuration - java.net.SocketTimeoutException

2016-08-15 Thread Pablo Anzorena
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

Re: Consume sql response using solrj

2016-08-12 Thread Pablo Anzorena
gt; > > > Just not positive how the SQL parser will treat the : in the query. > > > > > > > > > > Joel Bernstein > > http://joelsolr.blogspot.com/ > > > > On Thu, Aug 11, 2016 at 12:22 PM, Pablo Anzorena < > anzorena.f...@gmail.com> > > wr

Re: Consume sql response using solrj

2016-08-11 Thread Pablo Anzorena
-11 11:40 GMT-03:00 Pablo Anzorena <anzorena.f...@gmail.com>: > Excellent! > > Thanks Joel > > 2016-08-11 11:19 GMT-03:00 Joel Bernstein <joels...@gmail.com>: > >> There are two ways to do this with SolrJ: >> >> 1) Use the JDBC driver. >> >

Re: Consume sql response using solrj

2016-08-11 Thread Pablo Anzorena
http://joelsolr.blogspot.com/ > > On Thu, Aug 11, 2016 at 10:05 AM, Pablo Anzorena <anzorena.f...@gmail.com> > wrote: > > > Hey, > > > > I'm trying to get the response of solr via QueryResponse using > > QueryResponse queryResponse = clie

Consume sql response using solrj

2016-08-11 Thread Pablo Anzorena
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

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

2016-08-09 Thread Pablo Anzorena
tgres. 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 <apa...@elyograg.org>: > On 8/9/2016 7:55 AM, Pablo Anzorena wrote: > > That's it. Thanks. > > Solr doesn't

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

2016-08-09 Thread Pablo Anzorena
That's it. Thanks.

Re: Group and sum in SOLR 5.3

2016-07-29 Thread Pablo Anzorena
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=*:*=json=true= { property_codes_group_by : { type : terms, field : property_code, facet : { sum_price : "sum(price)" } } } 2016-07-29 7:47

Re: Parallel SQL where exists, in

2016-07-20 Thread Pablo Anzorena
mitting a patch? > > Best, > Erick > > On Tue, Jul 19, 2016 at 8:12 AM, Pablo Anzorena <anzorena.f...@gmail.com> > wrote: > > Hey, > > > > Is anyone willing to add the where exists and in clauses into paraller > sql? > > > > Thanks. >

Parallel SQL where exists, in

2016-07-19 Thread Pablo Anzorena
Hey, Is anyone willing to add the where exists and in clauses into paraller sql? Thanks.

Re: Is SolrCloudClient Singleton Pattern possible with multiple collections?

2016-07-14 Thread Pablo Anzorena
ction you want to query 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 > <anzorena.f...@gma

Re: Is SolrCloudClient Singleton Pattern possible with multiple collections?

2016-07-14 Thread Pablo Anzorena
ot; only when I need to request to multiple collections. Thanks. 2016-07-14 14:15 GMT-03:00 Erick Erickson <erickerick...@gmail.com>: > Just use the > > public NamedList request(SolrRequest request, String collection) > > method on the SolrCloudClient? > > Best, >

Is SolrCloudClient Singleton Pattern possible with multiple collections?

2016-07-14 Thread Pablo Anzorena
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: Facet in SOLR Cloud vs Core

2016-07-07 Thread Pablo Anzorena
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

Re: Facet in SOLR Cloud vs Core

2016-07-07 Thread Pablo Anzorena
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: No live SolrServers triggered by maxclausecount

2016-06-28 Thread Pablo Anzorena
at all. > > The point is 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. > >

Re: No live SolrServers triggered by maxclausecount

2016-06-28 Thread Pablo Anzorena
ou 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, 2016 at 8:38 AM, Pablo

No live SolrServers triggered by maxclausecount

2016-06-27 Thread Pablo Anzorena
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: SolrCloud SolrNode stopping randomly for no reason

2016-06-07 Thread Pablo Anzorena
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 <apa...@elyograg.org>: > 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

SolrCloud SolrNode stopping randomly for no reason

2016-06-07 Thread Pablo Anzorena
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).

Re: OutOfMemoryError does not fire the script

2016-05-27 Thread Pablo Anzorena
Perfect, thank you very much. 2016-05-27 12:44 GMT-03:00 Shawn Heisey <apa...@elyograg.org>: > 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='/e

OutOfMemoryError does not fire the script

2016-05-27 Thread Pablo Anzorena
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.

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

2016-04-22 Thread Pablo Anzorena
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

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

2016-04-13 Thread Pablo Anzorena
Thank you very much both of you for your insights! I really appreciate it. 2016-04-13 11:30 GMT-03:00 Kevin Risden : > For Solr 6, ParallelSQL and Solr JDBC driver are going to be developed more > as well as JSON facets. The Solr JDBC driver that is in Solr 6 contains