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

Add StatsStream to the Streaming API and wire it into the SQLHandler

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0
    • Component/s: None
    • Labels:
      None

      Description

      Currently the SQL interface only supports aggregate functions when a GROUP BY clause is present. This ticket will add the capability to query for aggregates without a GROUP BY clause.

      Example:

      select max(a), sum(b), min(c) from table1.

      The underlying implementation will be a StatsStream class which outputs the results from a StatsComponent query as a single Tuple.

      1. SOLR-8038.patch
        20 kB
        Joel Bernstein
      2. SOLR-8038.patch
        16 kB
        Joel Bernstein
      3. SOLR-8038.patch
        16 kB
        Joel Bernstein
      4. SOLR-8038.patch
        13 kB
        Joel Bernstein

        Issue Links

          Activity

          Hide
          joel.bernstein Joel Bernstein added a comment -

          Initial patch with passing StreamingTest. Still need to add tests for the SQLHandler and test edge conditions.

          Show
          joel.bernstein Joel Bernstein added a comment - Initial patch with passing StreamingTest. Still need to add tests for the SQLHandler and test edge conditions.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          New patch with a working SQL test.

          Show
          joel.bernstein Joel Bernstein added a comment - New patch with a working SQL test.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          New patch testing aggregates without GROUP BY that contain a WHERE clause and zero hit StatStream output.

          Show
          joel.bernstein Joel Bernstein added a comment - New patch testing aggregates without GROUP BY that contain a WHERE clause and zero hit StatStream output.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          Patch with pre-commit passing and updated CHANGES.txt

          Show
          joel.bernstein Joel Bernstein added a comment - Patch with pre-commit passing and updated CHANGES.txt
          Hide
          joel.bernstein Joel Bernstein added a comment -

          I'll do some manual testing using the JDBC driver and if all looks good I'll commit to trunk.

          Show
          joel.bernstein Joel Bernstein added a comment - I'll do some manual testing using the JDBC driver and if all looks good I'll commit to trunk.
          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1704973 from Joel Bernstein in branch 'dev/trunk'
          [ https://svn.apache.org/r1704973 ]

          SOLR-8038: Add StatsStream to the Streaming API and wire it into the SQLHandler

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1704973 from Joel Bernstein in branch 'dev/trunk' [ https://svn.apache.org/r1704973 ] SOLR-8038 : Add StatsStream to the Streaming API and wire it into the SQLHandler

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development