Recently moved to Solr 8.4.1

report this exception to solr-user@lucene.apache.org Any help is appreciated. Reagrds, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

JOIN query

'. Is there any way to get field from collection1 while performing query from collection2 joining with collection1? Regards, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: $deleteDocByQuery is not working for me

Hi, I am able to get it done using following way - Thanks, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: $deleteDocByQuery and $deleteDocByID

Hi, I am able to get it done using following way - Thanks, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: $deleteDocByQuery and $deleteDocByID

Hi, I am able to get it done using following way - Thanks, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: $deleteDocByQuery and $deleteDocByID

: This will come from query executed on RDBMS - select columnName from Table where state = 'deleted' This columnName is the value populated in Solr for SolrColulmnName. Regards, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Solr 7.7.0: Log file not getting generated

. I want to debug if the query getting formed is correct or not - Here is the snippet of entity - The said entity, I am not able to delete the docs from solr using delta-import operation, so wanted to debug it. Regards, Paresh -- Sent from: https

Re: Solr 7.7.0: Log file not getting generated

How can we see SQL in log file? -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Solr 7.7.0: Log file not getting generated

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:

$deleteDocByQuery is not working for me

lName is Solr column-name for the collection. dbCol - database column name in Table1 I am trying to use $deleteDocByQuery clause to remove documents. Any help is appreciated. Regards, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Solr 7.7.0: Log file not getting generated

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

Solr 7.7.0: Log file not getting generated

is appreciated. Thanks, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Wild-card query behavior

E.g. In query, join with wild-card query using parenthesis I get error - "error-class","org.apache.solr.common.SolrException", "root-error-class","org.apache.solr.parser.ParseException"], "msg":"org.apache.solr.search.SyntaxError: Cannot parse 'solrField:(12*': Encountered \"\" at line

Wild-card query behavior

(-) wild-card like (12*) in filter query with ={!join to=... from=...}field:(12*) --> works well Why wild-card query does not work with {!join}? Regards, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html

How to read DebugQuery output

sed_filter_queries":["TC_0Y0_Occurrence_Name:6935 style rear MY11+", "TC_0Y0_ProductScope:xtWNf_fTAaLUgD", "JoinQuery({!join from=TC_0Y0_ItemRevision_0Y0_awp0Item_item_id to=TC_0Y0_Item_ID fromIndex=collection1}TC_0Y0_ItemRevision_0Y0_awp0Item_item_id:92138773)"], "timing":{ "time":1487.0, .. I am trying to see why fromTermCount is so high when fromSetSize and toSetSize is less? Where can I find the details about all the contents of debugQuery and how to read each component? Any help is appreciated. Regards, Paresh

Understanding DebugQuery

sed_filter_queries":["TC_0Y0_Occurrence_Name:6935 style rear MY11+", "TC_0Y0_ProductScope:xtWNf_fTAaLUgD", "JoinQuery({!join from=TC_0Y0_ItemRevision_0Y0_awp0Item_item_id to=TC_0Y0_Item_ID fromIndex=collection1}TC_0Y0_ItemRevision_0Y0_awp0Item_item_id:92138773)"], "timing":{ "time":1487.0, .. I am trying to see why fromTermCount is so high when fromSetSize and toSetSize is less? Where can I find the details about all the contents of debugQuery and how to read each component? Any help is appreciated. Regards, Paresh

JOIN Execution Plan

Hi, I have two collections - collection1 and collection2. I am doing HTTP request on collection2 using http://localhost:8983/solr/collection1/tcfts/?params={q=col:value AND _query_:{!join}...AND _query_:{!join}..} If my query is like - fieldOnCollection1:somevalue AND INNER JOIN (with

JOIN Execution Plan

Hi, I have two collections - collection1 and collection2. I am doing HTTP request on collection2 using http://localhost:8983/solr/collection1/tcfts/?params={q=col:value AND _query_:{!join}...AND _query_:{!join}..} If my query is like - fieldOnCollection1:somevalue AND INNER JOIN (with

Re: SOLR JOIN

They are logically different that is why kept in different collections. Collection1: The purpose is to do Global Text Search for all objects through multiple document types Collection3: The purpose is to have search for some other type of objects whose documents are in Millions and takes GBs size.

Re: SOLR JOIN

I am actually able to make this work by doing multiple JOINs - 1. Do query on Collection1 2. JOIN with Collection3 (document type1 field) 3. JOIN with Collection3 (document type2 field) 4. Do not fetch any data except faceting information But the other problem is, it is very slow. Are there any

Re: SOLR JOIN

Hi Erick, I am able to achieve querying on Collection3 with INNER JOIN between two document types and JOIN across collection1 using below mechanism. I am also getting facetting information from collection3 along with data.

Re: SOLR JOIN

Hi Erick, I am able to achieve querying on Collection3 with INNER JOIN between two document types and JOIN across collection1 using below mechanism. I am also getting facetting information from collection3 along with data.

SOLR JOIN

Hi, I have two collections both having different schema. Collection1: ID, Field1, Field2 Collection3: ID, Oc1, OC2, col3_Field1 ID1, col3_Oc1 I want to do following JOINs (-)Query on Collection1 (-)Field2:value2 (-)JOIN across collection3 Field1 = collection3.col3_Field1

Solr Core not able access latest data indexed by multiple server.

Paresh -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-Core-not-able-access-latest-data-indexed-by-multiple-server-tp3919113p3919113.html Sent from the Solr - User mailing list archive at Nabble.com.