[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - Attachment: SOLR-8086.patch Patch with pre-commit passing. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Attachments: SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch, > SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[
https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joel Bernstein updated SOLR-8086:
-
Attachment: SOLR-8086.patch
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:
{code}
select distinct 'a', 'b' from tableX.
{code}
> Add support for SELECT DISTINCT queries to the SQL interface
>
>
> Key: SOLR-8086
> URL: https://issues.apache.org/jira/browse/SOLR-8086
> Project: Solr
> Issue Type: New Feature
>Reporter: Joel Bernstein
>Assignee: Joel Bernstein
> Attachments: SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch,
> SOLR-8086.patch, SOLR-8086.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - Attachment: SOLR-8086.patch Added support for case *insensitive* table names. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Attachments: SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch, > SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - Attachment: SOLR-8086.patch Initial patch with one passing test for Map/Reduce implementation. More unit tests coming. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Attachments: SOLR-8086.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - Attachment: SOLR-8086.patch Added initial test for JSON Facet API implementation. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Attachments: SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - Attachment: SOLR-8086.patch Added tests with a simple WHERE clause. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Attachments: SOLR-8086.patch, SOLR-8086.patch, SOLR-8086.patch, > SOLR-8086.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - Attachment: SOLR-8086.patch More Map/Reduce implementation tests including parallel tests. Still need to add tests for the JSON Facet API. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Attachments: SOLR-8086.patch, SOLR-8086.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - 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. was: 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. A flag will be added to the FacetStream to only add the distinct terms to the tuples and ignore the facet counts. 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. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - 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. A flag will be added to the FacetStream to only add the distinct terms to the tuples and ignore the facet counts. 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. was: 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. A flag will be added to the FacetStream to only add the distinct terms to the tuples and ignore the facet counts. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > > 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. A flag will be added to the > FacetStream to only add the distinct terms to the tuples and ignore the facet > counts. > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Updated] (SOLR-8086) Add support for SELECT DISTINCT queries to the SQL interface
[ https://issues.apache.org/jira/browse/SOLR-8086?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joel Bernstein updated SOLR-8086: - 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. A flag will be added to the FacetStream to only add the distinct terms to the tuples and ignore the facet counts. was: This ticket will add the SELECT DISTINCT query to the SQL interface. There will be a Map/Reduce implementation using the UniqueStream and an JSON Facet API implementation using the FacetStream. A flag will be added to the FacetStream to only add the distinct terms to the tuples and ignore the facet counts. > Add support for SELECT DISTINCT queries to the SQL interface > > > Key: SOLR-8086 > URL: https://issues.apache.org/jira/browse/SOLR-8086 > Project: Solr > Issue Type: New Feature >Reporter: Joel Bernstein >Assignee: Joel Bernstein > > 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. A flag will be added to the > FacetStream to only add the distinct terms to the tuples and ignore the facet > counts. -- This message was sent by Atlassian JIRA (v6.3.4#6332) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
