Solr facet division of 2 aggregation function

I'm storing 2 type of data for each record in my Solr core. first one is the total number of tasks in each day (total) and the second one is the total number of *finished* tasks in each day (finished). I want to compute how many percents of tasks was finished in each *month* using solr json facet q

Hi, happy to join this solr party.

I'd like to subscribe this maillist, thanks.

RE: RE: Inquiry

Hello, what is your MOQ and price per 1 item? can you make order exactly as same in the link below? We will be waiting your reply to proceed. Please reply me on my business email ASAP as we need an urgent order: farooq_a...@outlook.com best regards, Farooq Amin Sent from my iPhone

Re: Sum and aggregation on nested documents field

Hello Mikhail, First thanks a lot for your answers which are very useful for me... Then, I tried the query with the '$' parameter, and I get some great result like this : "id":"693897", "asso_i":693897, "etat_technique_s":"avec_documents", "etat_marketing_s":"actif",

Re: Solr OpenNLP named entity extraction

Thanks a lot Steve! On Wed, Jul 11, 2018 at 10:24 AM Steve Rowe wrote: > Hi Jerome, > > I was able to setup a configset to perform OpenNLP NER, loading the model > files from local storage. > > There is a trick though[1]: the model files must be located *in a jar* or > *in a subdirectory* under

Sum and aggregation on nested documents field

Hello everybody, I have a question about how to retrieve results from SOLR with some aggregation (like sum in my case...) on the nested documents. First, the data SOLR returned with a standard query : { "id":"3911.3912.1278", "parent_i":3191, "asso_i":3112, "pers

Solr7.3.1 Installation

We are trying to install solr-7.3.1 into our existing system (We have also made some changes by adding one custom query parser). I am having some build issues and it would be really helpful if someone can help. While running ant test(in the process of building the solr package), it terminates bec

Re: FieldValueCache in solr 6.6

hi: I have a question ，how to load data to FieldValueCache in solr7 thanks -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Solr OpenNLP named entity extraction

Hi Jerome, I was able to setup a configset to perform OpenNLP NER, loading the model files from local storage. There is a trick though[1]: the model files must be located *in a jar* or *in a subdirectory* under ${solr.solr.home}/lib/ or under a directory specified via a solrconfig.xml directi

Re: Sum and aggregation on nested documents field

Hello, JB. The rule of thumb if that you post what's you have whether it exception or unexpected result with explain. Here I guess you need something like: q={!parent which=object_type_s:contact score=total v=$chq}&chq=+ object_type:order {!func}TTC_i Make sure that + isn't mangled by url ecoding i

Re: Get transaction count from ZooKeeper transaction logs

On Wed, 11 Jul 2018 at 02:48, Shawn Heisey wrote: > On 7/10/2018 3:32 PM, Jostein Elvaker Haande wrote: > > I'm trying to find an effective way to find the number of transactions > You have detailed questions about the inner workings of ZooKeeper. This > is not a ZooKeeper mailing list. It is a

Re: Get transaction count from ZooKeeper transaction logs

On 7/10/2018 3:32 PM, Jostein Elvaker Haande wrote: I'm trying to find an effective way to find the number of transactions stored in the ZooKeeper transaction logs. The only method I've found so far is by using the Java class 'org.apache.zookeeper.server.LogFormatter' which outputs the following

Get transaction count from ZooKeeper transaction logs

Hello, I'm trying to find an effective way to find the number of transactions stored in the ZooKeeper transaction logs. The only method I've found so far is by using the Java class 'org.apache.zookeeper.server.LogFormatter' which outputs the following after it has formatted a log file: EOF rea

Verifying autoscale events via History Api

Hi all, We are trying to confirm that a Autoscaling ‘nodeAdded’ event triggers when a node joins the cluster using the History Api. We’ve added a node to the cluster but do not see any records in the Autoscale History endpoint. As a side note, we had to manually create the .system collection. Th

MetricRegistry instances for transient cores are not getting GC'd

I took a heap dump when Solr heap usage kept growing to 32GB and comes down to 15GB after GC. Heap dump analysis shows there are MetricRegistry instances for transient cores.i.e., cores with "isLoaded" as false in STATUS output.

Re: Sorting and pagination in Solr json range facet

HI Eric, i mean pagination is offset and limit for facet results. Basically i am trying to sort the daily totals (from json facet field) and apply offset, limit to the buckets. json.facet= { daily_totals: { type: range, field: daily_window, start : "2017-11-01T00:00:00

Re: Sum and aggregation on nested documents field

Thanks for your reply Mikhail, I tried like this : "{!parent which=object_type_s:contact score=total v={!func}TTC_i}" in a filter query, the same in the sort parameter, I also tried to put this query "{!parent which=object_type_s:contact score=total}TTC_i" into the q parameter, but no results... I

Re: Sum and aggregation on nested documents field

Thanks for your reply Mikhail, I tried like this : "{!parent which=object_type_s:contact score=total v={!func}TTC_i}" in a filter query, the same in the sort parameter, I also tried to put this query "{!parent which=object_type_s:contact score=total}TTC_i" into the q parameter, but no results... I

Re: Sorting and pagination in Solr json range facet

What exactly do you mean by "pagination" here? Facets are computed over the entire result set. That is, if the number of documents found for the query is 1,000,000, the facets are returned counted over all 1M docs, even if your rows parameter is 10. The same numbers will be returned for facets rega

Re: Delta import not working with Oracle in Solr

It's actually quite easy to index from a DB to Solr via SolrJ, here's an example. https://lucidworks.com/2012/02/14/indexing-with-solrj/ On Tue, Jul 10, 2018 at 6:06 AM, Shawn Heisey wrote: > On 7/8/2018 9:44 AM, shruti suri wrote: >> >> I am using solr-6.1.0 version. This is the response I am g

Re: [Solr-Zookeeper] Housekeeping Archival Logs

On 7/8/2018 8:46 PM, Goh, Qing Hao wrote: Can I kindly check what is the best practice for housekeeping archival logs for Solr & Zookeeper? What I meant here is the best practices recommended by Apache and to ensure the middleware is kept healthy? I have no idea what options ZooKeeper has for

Re: error on health check from command line

Additional information: Using solr-6.3.0 Also tried, no luck: ./bin/solr healthcheck -c poi -z host1:2181,host2:2181,host3:2181 SOLR_AUTH_TYPE=“basic” SOLR_AUTHENTICATION_OPTS="-Dbasicauth=username:password" On Tue, Jul 10, 2018 at 9:09 AM Satya Marivada wrote: > Hi, > > How do I supply the ba

error on health check from command line

Hi, How do I supply the basic auth credentials for the below healthcheck that has to be done from command line? $ ./bin/solr healthcheck -c poi -z host1:2181,host2:2181,host3:2181 ERROR: Solr requires authentication for https://host1:15101/solr/shard1/. Please supply valid credentials. HTTP code

Re: Delta import not working with Oracle in Solr

On 7/8/2018 9:44 AM, shruti suri wrote: I am using solr-6.1.0 version. This is the response I am getting. But every time I run delta import , it fetches same number of records but didn't commit them. 0:0:42.255 2 10208 0 0 2018-07-08 15:37:31 2018-07-08 15:37:31 2018-07-08 15:38:13 2018-07-08 1

Sorting and pagination in Solr json range facet

Hi, Good Morning. I am trying solr json facet features. sort, offset, limit fields are not working for Range facet. and could not find the support in the documentation. is there any way to achieve sort and pagination for Range facet ? please help. Documentation of range facet says - Parameters

Re: truncate string field type

suppose I want to search the "l(i|a)*on k(i|e)*ng". there is a space between two words. I want solr to retrieve the exact match that these two words or their other cases are adjacent. If I want to use text field type, each one of these words are considered as tokens, so solr may bring back other re

Re: truncate string field type

Are you sure Solr is the right tool for you? Regexp searches is the really last resort approach in the domain. I suggest that maybe you rethink your actual business case (share it here) to benefiy from tokenization or look if other tools are better. As it is, you are using a drill to hammer nails

Re: CDCR traffic

Hi, In the case of CDCR, assuming both the source and target clusters are SSL > enabled, can we say that the source clusters’ shard leaders act as clients > to the target cluster and hence the data is encrypted while its transmitted > between the clusters? Yes, that is correct. SSL and Kerberize

Re: Delta import not working with Oracle in Solr

Agreed. DIH is not an industrial grade ETL tool.. may want to consider other options. May want to look into Kafka Connect as an alternative. It has connectors for JDBC into Kafka, and from Kafka into Solr. -- Rahul Singh rahul.si...@anant.us Anant Corporation On Jul 9, 2018, 6:14 AM -0500, Alex