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

Add support for SELECT DISTINCT queries to the SQL interface

    Details

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

      Description

      This ticket will add the SELECT DISTINCT query to the SQL interface.

      There will be a Map/Reduce implementation using the UniqueStream and a JSON Facet API implementation using the FacetStream. SQL clients will be able to switch between Map/Reduce and JSON Facet API using the aggregationMode [map_reduce or facet] http param introduced in SOLR-7903.

      1. SOLR-8086.patch
        45 kB
        Joel Bernstein
      2. SOLR-8086.patch
        45 kB
        Joel Bernstein
      3. SOLR-8086.patch
        44 kB
        Joel Bernstein
      4. SOLR-8086.patch
        31 kB
        Joel Bernstein
      5. SOLR-8086.patch
        30 kB
        Joel Bernstein
      6. SOLR-8086.patch
        25 kB
        Joel Bernstein
      7. SOLR-8086.patch
        17 kB
        Joel Bernstein

        Issue Links

          Activity

          Hide
          joel.bernstein Joel Bernstein added a comment - - edited

          Initial patch with one passing test for the Map/Reduce implementation. More unit tests coming.

          Show
          joel.bernstein Joel Bernstein added a comment - - edited Initial patch with one passing test for the Map/Reduce implementation. More unit tests coming.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          More Map/Reduce implementation tests including parallel tests.

          Still need to add tests for the JSON Facet API.

          Show
          joel.bernstein Joel Bernstein added a comment - More Map/Reduce implementation tests including parallel tests. Still need to add tests for the JSON Facet API.
          Hide
          joel.bernstein Joel Bernstein added a comment - - edited

          Added initial tests for JSON Facet API implementation.

          Show
          joel.bernstein Joel Bernstein added a comment - - edited Added initial tests for JSON Facet API implementation.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          Added tests with a simple WHERE clause.

          Show
          joel.bernstein Joel Bernstein added a comment - Added tests with a simple WHERE clause.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          Added support for string literal field identifiers along with tests. This effects all queries so tests have been updated to include string literal field identifiers. Example:

          select distinct 'a', 'b' from tableX.
          
          Show
          joel.bernstein Joel Bernstein added a comment - Added support for string literal field identifiers along with tests. This effects all queries so tests have been updated to include string literal field identifiers. Example: select distinct 'a', 'b' from tableX.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          Added support for case insensitive table names.

          Show
          joel.bernstein Joel Bernstein added a comment - Added support for case insensitive table names.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          I believe this ticket is now functionally complete. I plan to do some manual testing and commit to trunk in a day or two.

          Show
          joel.bernstein Joel Bernstein added a comment - I believe this ticket is now functionally complete. I plan to do some manual testing and commit to trunk in a day or two.
          Hide
          joel.bernstein Joel Bernstein added a comment -

          Patch with pre-commit passing.

          Show
          joel.bernstein Joel Bernstein added a comment - Patch with pre-commit passing.
          Hide
          jira-bot ASF subversion and git services added a comment -

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

          SOLR-8086: Add support for SELECT DISTINCT queries to the SQL interface

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1707819 from Joel Bernstein in branch 'dev/trunk' [ https://svn.apache.org/r1707819 ] SOLR-8086 : Add support for SELECT DISTINCT queries to the SQL interface

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development