Re: Trying to retrieve two values from two different collections by sql (V 7.2.1)

2018-10-16 Thread deniz
found out sth strange regarding this case. If i change one of the values into sth else, and the field names are not the same any more, then i can get the different values so the initial query was select *collection1.id* as collection1id, collection2.id as collection2id from collection1 join

Trying to retrieve two values from two different collections by sql (V 7.2.1)

2018-10-16 Thread deniz
I am trying to run a query like below to query against two different collections: select collection1.id as collection1id, collection2.id as collection2id from collection1 join collection2 on collection1.name = collection2.name where collection1.name = 'dummyname'; And as a result, I am only

hdfs - documents missing after hard poweroff

2018-10-16 Thread Kyle Fransham
Hi, Sometimes after a full poweroff of the solr cloud nodes, we see missing documents from the index. Is there anything about our setup or our recovery procedure that could cause this? Details are below: We see the following (somewhat random) behaviour: - add 10 documents to index. Commit. -

Streaming rollUp vs Streaming facet

2018-10-16 Thread RAUNAK AGRAWAL
Hi Guys, I am trying to do an aggregation (sum) using streaming API. I have around 10 billion documents in my collection and every document has around 10 docValues. So streaming facet is taking close to 6 secs to respond with aggregation on 10 fields while streaming rollup is returning the

Re: Device I/O trouble with solr 7.5

2018-10-16 Thread zoolette
Hi Shawn, Thanks for you're quick answer. I know it's not ideal to have mysql and SOLR on the same server. The use is perfect for replication, but actually is too short to handle a high query rate. And of course I didn't see the warning about pointed fields and performance on the documentation

Re: Device I/O trouble with solr 7.5

2018-10-16 Thread Shawn Heisey
On 10/16/2018 6:04 AM, zoolette wrote: We are today running under SOLR 6.6 on our production environnement. On the end of august, i planned to upgrade SOLR to 7.4 (7.5 since that moment) but I encounter some trouble. Our master SOLR is replicated to a slave SOLR. I tried to upgrade the replica

Re: qf an pf parameters question

2018-10-16 Thread Andrea Gazzarini
Hi, you may be interested in the mm [1] parameter, which in this case shout be set to 100%. However, if your requirements are more complicated than this, an mm=100% could have some unwanted side-effects because it's very "rigid". Best, Andrea [1]

qf an pf parameters question

2018-10-16 Thread Kempelen , Ákos
Hello, I use edismax qf and pf parameters, but for some field it would be desired to match ONLY if terms are in the same phrase. However, the qf parameter does not work with phrases, it is just for "filtering", and pf params affects only scoring. For example: qf=fulltext subject pf=fulltext

Device I/O trouble with solr 7.5

2018-10-16 Thread zoolette
Hi folks, We are today running under SOLR 6.6 on our production environnement. On the end of august, i planned to upgrade SOLR to 7.4 (7.5 since that moment) but I encounter some trouble. Our master SOLR is replicated to a slave SOLR. I tried to upgrade the replica first, this is this one that

RE: Correct join syntax

2018-10-16 Thread Vadim Ivanov
Hi You cannot join on two fields in SOLR as you do using SQL. Having the same situations I add new string field in collections(to concatenate Type and Id fields) and fill it at index time) Then join two collections on that field at query time -- Vadim -Original Message- From:

join

2018-10-16 Thread Karthik Gullapalli

join

2018-10-16 Thread Karthik Gullapalli

Re: SQL Query with NOT (V 7.2.1)

2018-10-16 Thread deniz
okay, found a work around for string fields for NOT queries This query does not filters for NOT: curl --data-urlencode "stmt=select id, name from collection where NOT (name = 'defaultmail')" 'http://server:port/solr/collection/sql' but after adding sth trivial i.e id > 0 o the where clause as

Re: SQL Query with NOT (V 7.2.1)

2018-10-16 Thread deniz
using integers in where clause with NOT is the same, though for that one using <> as workaround does the job - Zeki ama calismiyor... Calissa yapar... -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: SQL Query with NOT (V 7.2.1)

2018-10-16 Thread deniz
with curl the result is the same: curl --data-urlencode "stmt=select id, name from collection where NOT (name = 'defaultmail')" 'http://server:port/solr/collection/sql' then the response is . . . { "id":113, "name":"defaultmail"} ,{ "id":109,