Re: SQL equality predicate escaping single quotes

2019-08-09 Thread Joel Bernstein
It does appear that single quotes are being removed. If you want to provide a patch that allows single quotes to get passed through, I can help with testing and committing. On Thu, Aug 8, 2019 at 11:28 AM Kyle Lilly wrote: > Hi, > > When using the SQL handler is there any way to escape single q

Re: Enumerating cores via SolrJ

2019-08-09 Thread Shawn Heisey
On 8/9/2019 3:07 PM, Mark H. Wood wrote: Did I miss something, or is there no way, using SolrJ, to enumerate loaded cores, as: curl 'http://solr.example.com:8983/solr/admin/cores?action=STATUS' does? This code will do so. I tested it. public static void main(String[] args) throws SolrS

Re: Enumerating cores via SolrJ

2019-08-09 Thread Brian Lininger
You can extend org.apache.solr.client.solrj.request.CoreAdminRequest to do exactly what you're asking for On Fri, Aug 9, 2019 at 2:07 PM Mark H. Wood wrote: > Did I miss something, or is there no way, using SolrJ, to enumerate > loaded cores, as: > > curl 'http://solr.example.com:8983/sol

Enumerating cores via SolrJ

2019-08-09 Thread Mark H. Wood
Did I miss something, or is there no way, using SolrJ, to enumerate loaded cores, as: curl 'http://solr.example.com:8983/solr/admin/cores?action=STATUS' does? -- Mark H. Wood Lead Technology Analyst University Library Indiana University - Purdue University Indianapolis 755 W. Michigan Street

install Solr keeping S3 as storage(neither OS file system not hdfs).

2019-08-09 Thread Suryakant Jadhav
Hi, I am trying to configure Solr with S3. Could you please guide me step by step configuration for setting this up. Can you see if we can install Solr keeping S3 as storage(neither OS file system not hdfs). Best Regards, Suryakant

Re: Indexed Data Size

2019-08-09 Thread Shawn Heisey
On 8/9/2019 12:17 PM, Moyer, Brett wrote: The biggest is /data/solr/system_logs_shard1_replica_n1/data/index, files with the extensions I stated previously. Each is 5gb and there are a few hundred. Dated by to last 3 months. I don’t understand why there are so many files with such small indexe

RE: Indexed Data Size

2019-08-09 Thread Moyer, Brett
Correct our indexes are small document wise, but for some ready we have a years' worth of files in the data/solr folders. There are no index. files. The biggest is /data/solr/system_logs_shard1_replica_n1/data/index, files with the extensions I stated previously. Each is 5gb and there are a few

Solr restricting time-consuming/heavy processing queries

2019-08-09 Thread Mark Robinson
Hello, I have the following questions please:- In solrconfig.xml I created a new "/selecttimeout" handler copying "/select" handler and added the following to my new "/selecttimeout":- 10 20 1. Does the above mean that if I dont get a request once in 10ms on the socket handling the

Re: [jira] [Commented] (SOLR-9952) S3BackupRepository can install Solr keeping S3 as storage(neither OS filesystem not hdfs).

2019-08-09 Thread Shawn Heisey
On 8/9/2019 10:16 AM, Suryakant Jadhav wrote: I am trying to configure Solr with S3. Could you please guide me step by step configuration for setting this up. Can you see if we can install Solr keeping S3 as storage(neither OS file system not hdfs). Changes for that issue have not yet been com

RE: [jira] [Commented] (SOLR-9952) S3BackupRepository can install Solr keeping S3 as storage(neither OS filesystem not hdfs).

2019-08-09 Thread Suryakant Jadhav
Hi, I am trying to configure Solr with S3. Could you please guide me step by step configuration for setting this up. Can you see if we can install Solr keeping S3 as storage(neither OS file system not hdfs). Best Regards, Suryakant -Original Message- From: Kevin Risden (JIRA) Sent:

Re: Searches across Cores

2019-08-09 Thread Nicolas Franck
He's right. You can use the parameter "shards" for a very long time, even before the whole solr cloud existed. e.g. http://localhost:8983/solr/core0/select with parameters: shards = localhost:8983/solr/core0,example.com:8983/solr/core0 q = *:* defType =

RE: Searches across Cores

2019-08-09 Thread Vadim Ivanov
May be consider having one collection with implicit sharding ? This way you can have all advantages of solrcloud and can control content of each core "manualy" as well as query them independently (&distrib=false) ... or some of them using &shards=core1,core2 as was proposed before Quote from doc

Re: Searches across Cores

2019-08-09 Thread Komal Motwani
For some good reasons, SolrCloud is not an option for me. I need to run nested graph queries so firing parallel queries and taking union/intersection won't work. I am aware of achieving this via shards however I am looking for ways to achieve this via multiple cores. We already have data existing i

Re: Searches across Cores

2019-08-09 Thread Erick Erickson
So my question is why do you have individual cores? Why not use SolrCloud and collections and have this happen automatically? There may be very good reasons, this is more if a sanity check…. > On Aug 9, 2019, at 8:02 AM, Jan Høydahl wrote: > > USE request param &shards=core1,core2 or if on sep

Re: Indexed Data Size

2019-08-09 Thread Shawn Heisey
On 8/9/2019 6:12 AM, Moyer, Brett wrote: Thanks! We update each index nightly, we don’t clear, but bring in New and Deltas, delete expired/404. All our data are basically webpages, so none are very large. Some PDFs but again not too large. We are running Solr 7.5, hopefully you can access the

RE: Indexed Data Size

2019-08-09 Thread Moyer, Brett
Thanks! We update each index nightly, we don’t clear, but bring in New and Deltas, delete expired/404. All our data are basically webpages, so none are very large. Some PDFs but again not too large. We are running Solr 7.5, hopefully you can access the links. https://www.dropbox.com/s/lzd6hkoik

Re: Searches across Cores

2019-08-09 Thread Jan Høydahl
USE request param &shards=core1,core2 or if on separate machines host:port/solr/core1,host:port/solr/core2 Jan Høydahl > 9. aug. 2019 kl. 11:23 skrev Komal Motwani : > > Hi, > > > > I have a use case where I would like a query to span across Cores > (Multi-Core); all the cores involved do ha

Re: Searches across Cores

2019-08-09 Thread Sidharth Negi
Hi, If the number of cores spanned is low, I guess firing parallel queries and taking union or intersection should work since their schema is the same. Do you notice any perceivable difference in performance? Best, Sidharth On Fri, Aug 9, 2019 at 2:54 PM Komal Motwani wrote: > Hi, > > > > I ha

Searches across Cores

2019-08-09 Thread Komal Motwani
Hi, I have a use case where I would like a query to span across Cores (Multi-Core); all the cores involved do have same schema. I have started using solr just recently and have been trying to find ways to achieve this but couldn’t find any solution so far (Distributed searches, shards are not wh

Query field alias - issue with circular reference

2019-08-09 Thread Jaroslaw Rozanski
Hi Folks, Question about query field aliases. Assuming one has fields: * foo1 * foo2 Sending "defType=edismax&q=foo:hello&f.foo.qf=foo1 foo2" will work. But what in case of, when one has fields: * foo * foo1 Say we want to add behaviour to queries that are already in use. We want to