[jira] [Created] (SOLR-10002) CORE Query Joins

["Moenieb (JIRA)" <ji...@apache.org>]

Moenieb created SOLR-10002:
------------------------------

             Summary: CORE Query Joins
                 Key: SOLR-10002
                 URL: https://issues.apache.org/jira/browse/SOLR-10002
             Project: Solr
          Issue Type: Improvement
      Security Level: Public (Default Security Level. Issues are Public)
          Components: search, SearchComponents - other
    Affects Versions: 6.3
            Reporter: Moenieb


Scenario:

If you have a DB type core schema configuration where a core = table, is it possible to join and interact as if you are writing a join in a normal DB.

SQL:
Select core1.field1, core1.field2, core2.field1, core2.field2 from core1 innerjoin core2 where core1.id = core2.id
where core1.filter = "" and core.filter = ""

Is it possible to return the result from a query that joins lets say 3 cores in the following format:

        "core1_id":"XXX",
        "_childDocuments_":[
        {
          "core2_id":"yyy",
          "core_2_fieldx":"ABC",
                  "_childDocuments_":[
                  {
                    "core3_id":"zzz",
                    "core_3_fieldx":"ABC",
                    "core3_fieldy":"123",
                  {
          "core2_fieldy":"123",
        {




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org