Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-8593

Integrate Apache Calcite into the SQLHandler

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Resolved
    • Affects Version/s: None
    • Fix Version/s: 6.5, 7.0
    • Component/s: Parallel SQL
    • Labels:
      None

      Description

      The Presto SQL Parser was perfect for phase one of the SQLHandler. It was nicely split off from the larger Presto project and it did everything that was needed for the initial implementation.

      Phase two of the SQL work though will require an optimizer. Here is where Apache Calcite comes into play. It has a battle tested cost based optimizer and has been integrated into Apache Drill and Hive.

      This work can begin in trunk following the 6.0 release. The final query plans will continue to be translated to Streaming API objects (TupleStreams), so continued work on the JDBC driver should plug in nicely with the Calcite work.

        Attachments

        1. SOLR-8593.patch
          329 kB
          Kevin Risden
        2. SOLR-8593.patch
          43 kB
          Joel Bernstein
        3. SOLR-8593.patch
          256 kB
          Cao Manh Dat

          Issue Links

            Activity

              People

              • Assignee:
                joel.bernstein Joel Bernstein
                Reporter:
                joel.bernstein Joel Bernstein
              • Votes:
                2 Vote for this issue
                Watchers:
                15 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: