[jira] [Created] (SOLR-18508) {!auxIndexJoin} - skip the column if confirming doc out of min..max to-side range

["Mikhail Khludnev (Jira)" <ji...@apache.org>]

Mikhail Khludnev created SOLR-18508:
---------------------------------------

             Summary: {!auxIndexJoin} - skip the column if confirming doc out of min..max to-side range
                 Key: SOLR-18508
                 URL: https://issues.apache.org/jira/browse/SOLR-18508
             Project: Solr
          Issue Type: Improvement
          Components: query
            Reporter: Mikhail Khludnev
            Assignee: Mikhail Khludnev
             Fix For: 10.1


Hereby I propose a new query-time join implementation

* it's segment parallel 
* it's lazy - utilizes Two-Phase searching and beneficial from highly selective filter in "to"-side, as well as leap over whole "to" segments. 
* uses Lucene DocValues in sidecar - just an addition, there's no hard surgery on existing codebase. It's just a QParserPlugin.  
* joins crosscore, and works in cloud mode
* may use Memory Directory for sidecar
* writes sidecar lazily, but you can write it ahead
* sweeps segments which are not needed anymore 
* the [simple benchmark|https://github.com/mkhludnev/aijoin-benchmark] demonstrates a few times gain 

WIP https://github.com/apache/solr/pull/4749
benchmark: https://github.com/mkhludnev/aijoin-benchmark

Caveat: during the demo 7/15/26 we evidence nearly the same size of sidecar index. it should be further investigated. 
Note: the name comes from Auxiliary Index Join. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org