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

Add sql Streaming Expression

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Resolved
    • Affects Version/s: None
    • Fix Version/s: 6.7, 7.0
    • Component/s: None
    • Labels:
      None

      Description

      The existing jdbc Streaming Expression is really designed for querying outside SQL engines.

      The sql expression is designed to talk directly with Solr's parallel SQL interface.

      This will make it much easier to intermingle SQL queries with other expressions and leverage the new math expressions on top of SQL result sets.

      Sample syntax:

      sql(dbcollection, stmt="SELECT ...")
      

      The dbcollection parameter is the distributed front end to the database. Like all parallel SQL queries the stmt can reference any collection in the Zk instance.

        Attachments

        1. SOLR-10623.patch
          15 kB
          Joel Bernstein

          Issue Links

            Activity

              People

              • Assignee:
                jbernste Joel Bernstein
                Reporter:
                jbernste Joel Bernstein
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: