performance improvement for streaming expression

2023-08-19 Thread Susheel Kumar
Hello, Any suggestions on what can be done to improve performance of below streaming expressions. especially when emp table has like 100K records. Performance is okay when emp table has around 10K and returns in less than 1-2 sec but when 100K rows to be joined etc then its taking many seconds.

Re: min date function - Solr Streaming

2023-06-06 Thread Susheel Kumar
; select(search(collection), >epoch(date_dt) as utime) > > I'll create a jira to document this feature. > > > > > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Tue, Jun 6, 2023 at 9:29 AM Susheel Kumar > wrote: > > > Hel

min date function - Solr Streaming

2023-06-06 Thread Susheel Kumar
Hello, How can we take a minimum date in a grouping scenario. I tried using the min function but it converts all dates to a fixed e Value. rollup( search(employee_position, q="*:*", qt="/export", fl="EMPLOYEE_ID_s,POSITION_ID_s,HIRE_DATE_dt", df="_text_", sort="PO

Solr 9 - Admin UI throwing error "The JSON must be an object of the form"

2022-11-15 Thread Susheel Kumar
Hello, I am seeing Solr 9.0.0 admin UI throwing error "The JSON must be an object of the form..." when adding any Permission under security tab. Can someone confirm and accordingly will create JIRA and also if there is any work around? Thnx

Re: Stream - substitute result from output of a stream expr as filter query to another expr

2022-09-06 Thread Susheel Kumar
oin: > > https://solr.apache.org/guide/8_4/stream-decorator-reference.html#hashjoin > > Joel Bernstein > http://joelsolr.blogspot.com/ > > > On Mon, Aug 22, 2022 at 12:00 PM Joel Bernstein > wrote: > > > I believe what you're looking for is an in

Stream - substitute result from output of a stream expr as filter query to another expr

2022-08-17 Thread Susheel Kumar
Hello, How can we substitute an output from a streaming expr as a filter query inside another streaming expression. For example below expr select( search(filters, q="*:*", fq="key:84396", qt="/export", fl="id,filter1_s,key", sort="key asc" ), fil

Re: HTTP ERROR 401 Authentication when connecting to HTTPS Solr

2022-06-14 Thread Susheel Kumar
Any help why it might be failing with 401 or what can I try ? On Thu, Jun 9, 2022 at 5:13 PM Susheel Kumar wrote: > This is the Solr setup using Solr operator with 8.11.1. I have posted on > Solr operator channel as well but checking here as well as Http2SolrClient > and CloudHttp2S

Re: HTTP ERROR 401 Authentication when connecting to HTTPS Solr

2022-06-09 Thread Susheel Kumar
This is the Solr setup using Solr operator with 8.11.1. I have posted on Solr operator channel as well but checking here as well as Http2SolrClient and CloudHttp2SolrClient should still work. Thnx On Thu, Jun 9, 2022 at 5:08 PM Susheel Kumar wrote: > Hello, > > While using Http2SolrC

HTTP ERROR 401 Authentication when connecting to HTTPS Solr

2022-06-09 Thread Susheel Kumar
Hello, While using Http2SolrClient and CloudHttp2SolrClient to query HTTPS Solr, running into below errors. Any ideas/suggestions what could be wrong? Code . System.setProperty("javax.net.ssl.keyStore", "/etc/secrets/keystore.p12"); System.setProperty("javax.

Re: [VOTE] Solr Operator Logo

2021-05-03 Thread Susheel Kumar
Logo: L-2 Icon: I-1 On Mon, May 3, 2021 at 4:58 AM Istvan Balint wrote: > Logo: L-1 > Icon: I-1, I-3 > > Istvan Balint > > On Mon, May 3, 2021 at 12:03 AM David Smiley wrote: > > > L-3 > > I-3 > > > > They are all pretty good so I'll just pick my favorite. I'm not sure if > > there's a possible