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 if

Re: Solr dynamic "on the fly fields"

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

Re: Solr dynamic "on the fly fields"

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

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 alessandro.benedet

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 s

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 mind, is that w/o a fully deterministic sort, > > the u

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

2017-03-29 Thread Pablo Anzorena
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)

2017-03-29 Thread Pablo Anzorena
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)

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 : > 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

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 intend

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 : > Hi Erick, > > I'l

Re: Posting files 405 http error

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

Re: Posting files 405 http error

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

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

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 Posting

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 an XML. > Whenever I

Re: Consume sql response using solrj

2016-08-12 Thread Pablo Anzorena
l, one more thing. > >> > >> Is there anyway to use the sql and the lucene query syntax? The thing is > >> that my bussiness application is tightly coupled with the lucene query > >> syntax, so I need a way to use both the sql features (without the where > >

Re: Consume sql response using solrj

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

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

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 http://tywin:8983/solr

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

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

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=*:*&wt=json&indent=true&json.facet= { property_codes_group_by : { type : terms, field : property_code, facet : { sum_price : "sum(price)" } }

Re: Parallel SQL where exists, in

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

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
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 >

Re: Is SolrCloudClient Singleton Pattern possible with multiple collections?

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

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 scenario (note that > : the pro

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
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: No live SolrServers triggered by maxclausecount

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

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
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 >

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). Thanks.

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 : > 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

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 sh

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 > SOLR-8502. There are fur