Hi Erik,
I am also looking for some example of deleteDocByQuery. Here is my
requirement -
I want to do the database query and get the list of values of which matching
documents should be deleted from Solr.
I want to delete the docs which matches following query
SolrColumnName:
This will c
Hi Paras,
I have db-data-config.xml file with entities defined for data population and
update.
As a part of some process, I want to delete the documents from Solr for data
deleted in RDBMS. For this purpose I am writing SQL to fetch data from RDBMS
and delete it in Solr using $deleteDocByQuery.
(1) no. The internal Ram buffer will pretty much limit the amount of heap used
however.
(2) You actually have several segments. “.cfs” stands for “Compound File”, see:
https://lucene.apache.org/core/7_1_0/core/org/apache/lucene/codecs/lucene70/package-summary.html
"An optional "virtual" file co
Based on the info provided, it's hard to be certain, but reading between
the lines here are hte assumptions i'm making...
1) your core name is "dbtr"
2) the uniqueId field for the "dbtr" core is "debtor_id"
..are those assumptions correct?
Two key pieces of information that doesn't seem to be
On 11/11/2019 1:40 PM, siddharth teotia wrote:
I have a few questions about Lucene indexing and file handling. It would be
great if someone can help with these. I had earlier asked these questions
on gene...@lucene.apache.org but was asked to seek help here.
This mailing list (solr-user) is for
Hello,
I am trying to keep multiple versions of same document (empId,
empName,deptID,effectiveDt,empTitle..,..) with different effective dates
(composite key: deptID,empID,effectiveDt) but mark/ soft delete (deleted=Y)
the older ones and keep deleted=N for the latest one.
This way i can query the
Hi All,
I have a few questions about Lucene indexing and file handling. It would be
great if someone can help with these. I had earlier asked these questions
on gene...@lucene.apache.org but was asked to seek help here.
(1) During indexing, is there any knob to tell the writer to use off-heap
fo
Grep on the source of the manual (which ships with Solr source).
Google search with domain or keywords limitations.
Online copy searching is not powered by Solr yet. Yes, we are aware of the
irony and are discussing it.
Regards,
Aled
On Tue, Nov 12, 2019, 1:25 AM Luke Miller, wrote:
> Hi,
i am using this logic in perl:
my $decoded = decode_json( $solrResponse->{_content} );
my $numFound = $decoded->{response}{numFound};
$cursor = "*";
$prevCursor = '';
while ( $prevCursor ne $cursor )
{
my $solrURI = "\"http://[SOLR URL]:8983/solr/";
$solrURI .= $fdat{core};
$solrSort = (
Is it something like https://issues.apache.org/jira/browse/SOLR-10673 ?
On Mon, Nov 11, 2019 at 3:47 PM Vasily Ogar wrote:
> it's show nothing because I got an error
> "metadata":[ "error-class","org.apache.solr.common.SolrException",
> "root-error-class","org.apache.solr.search.SyntaxError"],
Thank you both. I will look into the options.
-AA
On Mon, Nov 11, 2019 at 6:05 AM Emir Arnautović <
emir.arnauto...@sematext.com> wrote:
> Hi Antony,
> Like Erick explained, you still have to preprocess your field in order to
> be able to use doc values. What you can do is use update request pro
: Some of the log files that Solr generated contain <0x00> (null characters)
: in log files (like below)
I don't know of any reason why solr would write any null bytes to the
logs, and certainly not in either of the places mentioned in your examples
(where it would be at the end of an otherwis
Hi,
I just noticed that since Solr 8.2 the Apache Solr Reference Guide is not
available anymore as PDF.
Is there a way to perform a full-text search using the HTML manual? E.g. I'd
like to find every hit for "luceneMatchVersion".
* Using the integrated "Page title lookup." does no
Thanks , its worked for me.
--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Hi Antony,
Like Erick explained, you still have to preprocess your field in order to be
able to use doc values. What you can do is use update request processor chain
and have all the logic in Solr. Here is blog post explaining how it could work:
https://www.od-bits.com/2018/02/solr-docvalues-on-
it's show nothing because I got an error
"metadata":[ "error-class","org.apache.solr.common.SolrException",
"root-error-class","org.apache.solr.search.SyntaxError"],
"msg":"org.apache.solr.search.SyntaxError:
geodist - not enough parameters:[]",
If I set parameters then I got another error
"metada
Thanks
> Removing stopwords is another story. I'm curious to find the reason
> assuming that you keep on using stopwords. In some cases, stopwords are
> really necessary.
Yes. It always make sense the way we've been using.
> If q.alt is giving you responses, it's confirmed that your stopwords filt
Hey Paresh,
I have never worked with "SQL". Did you mean DIH logging? A simple google
search yields this:
https://grokbase.com/t/lucene/solr-user/12618pmah7/how-to-show-dih-query-sql-in-log-file
Turn the Solr logging level to "FINE" for the DIH packages/classes and
they will
> show up in the log.
Hello, Community:
I am using Solr7.4.0 currently, and I was testing how Solr actually behaves
when it has a corrupted index.
And I used Luke to fix the broken index from GUI.
I just came up with the following questions.
Is it possible to use the repair index tool from CLI? (in the case, Solr
was o
Hello, Vasily.
Why not? What have you got in debugQuery=true?
On Mon, Nov 11, 2019 at 1:19 PM Vasily Ogar wrote:
> Hello,
> Is it possible to sort by score in join by geodist()? For instance,
> something like this
> q={!join from=site_id to=site_id fromIndex=stores score=max}
> +{!func}gedist()
Thanks Erick/Hossman,
I appreciate your input it's always an interesting read seeing Solr legends
like yourselves work through a problem! I certainly learn a lot from following
your responses in this user group.
As you recommended I ran the distrib=false query on each shard and the results
we
How can we see SQL in log file?
--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Hi,
After creating admin user in Solr when security is enabled, we have to store
the admin user's credentials in plain text format. Is there any option or a way
to encrypt the plain text password?
Thanks,
Vinodh
DTCC DISCLAIMER: This email and any files transmitted with it are confidential
and
Hello,
Is it possible to sort by score in join by geodist()? For instance,
something like this
q={!join from=site_id to=site_id fromIndex=stores score=max}
+{!func}gedist() +{!geofilt sfield=coordinates
pt=54.6973867999,25.22481530046 d=10}
sort=score desc
Thank you
In my environment I was creating a windows service for Solr and there I
forgot to specify -Dsolr.log.dir as a command line for Windows Service.
After defining it to correct path and reinstalling solr as service solved
the issue.
--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068
Hi Paresh,
Glad that it worked. For the sake of future views, please try to explain
how it worked and what you did. It will help users having similar issues in
future.
On Mon, 11 Nov 2019 at 14:32, Paresh wrote:
> Thanks Paras. It solved my problem. I am now able to see the logs.
>
>
>
> --
> S
Hi,
I am trying to write an entity to delete documents for the records marked as
deleted in my rdbms database using db-data-config.xml file with following
entry in an entity -
query="SELECT CONCAT( 'ColName:', dbCol ) AS '$deleteDocByQuery' FROM TABLE1
t1 WHERE t1.state = 1 AND t1.lmd > TO_DAT
Ok, thank you
On Mon, Nov 11, 2019 at 9:56 AM Mikhail Khludnev wrote:
> Oh.. gosh. Sure. Subquery yields doc results only, neither of facets,
> highlighting is attached to response.
>
> On Mon, Nov 11, 2019 at 10:07 AM Vasily Ogar
> wrote:
>
> > My subquery is products I tried
> product.hl=on&p
Thanks paras, after your comment i realized/found it is using managed
schema.
After reading solr documentations
https://lucene.apache.org/solr/guide/6_6/schema-factory-definition-in-solrconfig.html
Added on solrconfig.xml , reloaded and it works thanks
Thanks Erick Erickson & Alexandre Rafalovi
Thanks Paras. It solved my problem. I am now able to see the logs.
--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html
30 matches
Mail list logo
