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

Parallel SQL Support

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 6.0
    • clients - java, search
    • None

    Description

      This ticket provides support for executing Parallel SQL queries across SolrCloud collections. The SQL engine will be built on top of the Streaming API (SOLR-7082), which provides support for parallel relational algebra and real-time map-reduce.

      Basic design:

      1) A new SQLHandler will be added to process SQL requests. The SQL statements will be compiled to live Streaming API objects for parallel execution across SolrCloud worker nodes.

      2) SolrCloud collections will be abstracted as Relational Tables.

      3) The Presto SQL parser will be used to parse the SQL statements.

      4) A JDBC thin client will be added as a Solrj client.

      This ticket will focus on putting the framework in place and providing basic SELECT support and GROUP BY aggregate support.

      Future releases will build on this framework to provide additional SQL features.

      Attachments

        1. SOLR-7560.calcite.patch
          29 kB
          Joel Bernstein
        2. SOLR-7560.patch
          156 kB
          Joel Bernstein
        3. SOLR-7560.patch
          125 kB
          Joel Bernstein
        4. SOLR-7560.patch
          118 kB
          Joel Bernstein
        5. SOLR-7560.patch
          99 kB
          Joel Bernstein

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            jbernste Joel Bernstein
            Votes:
            2 Vote for this issue
            Watchers:
            21 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment