[jira] [Commented] (SOLR-8919) Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-8919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16683413#comment-16683413 ] Haochao Zhuang commented on SOLR-8919: -- We use an object of Pair to represent a tuple of AggFunctionName and Column. So how to represent the count function with DISTINCT? Maybe we have to have another function name to represent it by UNIQUE. This is okay for JSON Facet API. But it is not really okay for MAP_REDUCE model. > Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface > --- > > Key: SOLR-8919 > URL: https://issues.apache.org/jira/browse/SOLR-8919 > Project: Solr > Issue Type: Bug > Components: Parallel SQL >Reporter: Joel Bernstein >Assignee: Joel Bernstein >Priority: Major > Fix For: 6.2, 7.0 > > > While analyzing the Enron emails for SOLR-, I was wishing that > COUNT(DISTINCT) was implemented. This ticket is to implement it. -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-8919) Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-8919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15898430#comment-15898430 ] Joel Bernstein commented on SOLR-8919: -- I haven't yet looked at the query place that Calcite is generating for this, but I suspect it may not work properly with all the functionality that is being pushed down. I'd like to push down this functionality anyway, because we have some nice tools for doing this in Solr. > Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface > --- > > Key: SOLR-8919 > URL: https://issues.apache.org/jira/browse/SOLR-8919 > Project: Solr > Issue Type: Bug >Reporter: Joel Bernstein > Fix For: 6.2, master (7.0) > > > While analyzing the Enron emails for SOLR-, I was wishing that > COUNT(DISTINCT) was implemented. This ticket is to implement it. -- This message was sent by Atlassian JIRA (v6.3.15#6346) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-8919) Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-8919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15896014#comment-15896014 ] Kevin Risden commented on SOLR-8919: We should double check if this is still necessary or if SOLR-8593 is already generating a SQL plan that works. > Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface > --- > > Key: SOLR-8919 > URL: https://issues.apache.org/jira/browse/SOLR-8919 > Project: Solr > Issue Type: Bug >Reporter: Joel Bernstein > Fix For: 6.2, master (7.0) > > > While analyzing the Enron emails for SOLR-, I was wishing that > COUNT(DISTINCT) was implemented. This ticket is to implement it. -- This message was sent by Atlassian JIRA (v6.3.15#6346) - To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org
[jira] [Commented] (SOLR-8919) Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-8919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15553671#comment-15553671 ] Joel Bernstein commented on SOLR-8919: -- The approach I was going to use is to identify if it's a count distinct query and then just add a count stream to the select distinct logic. This would be in MapReduce mode. I believe count distinct is directly supported by the JSON facet API, so in facet mode, this might involve a change to the FacetStream. > Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface > --- > > Key: SOLR-8919 > URL: https://issues.apache.org/jira/browse/SOLR-8919 > Project: Solr > Issue Type: Bug >Reporter: Joel Bernstein > Fix For: 6.2, master (7.0) > > > While analyzing the Enron emails for SOLR-, I was wishing that > COUNT(DISTINCT) was implemented. This ticket is to implement it. -- 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] [Commented] (SOLR-8919) Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-8919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15553654#comment-15553654 ] Joel Bernstein commented on SOLR-8919: -- I planned on getting this in for Solr 6.2 but got side tracked on other tickets. So no patch yet. I'll un-assign myself. > Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface > --- > > Key: SOLR-8919 > URL: https://issues.apache.org/jira/browse/SOLR-8919 > Project: Solr > Issue Type: Bug >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Fix For: 6.2, master (7.0) > > > While analyzing the Enron emails for SOLR-, I was wishing that > COUNT(DISTINCT) was implemented. This ticket is to implement it. -- 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] [Commented] (SOLR-8919) Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface
[ https://issues.apache.org/jira/browse/SOLR-8919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15553538#comment-15553538 ] Kevin Risden commented on SOLR-8919: [~joel.bernstein] - Was there a patch you were working on for this? See that it says in progress. > Add SELECT COUNT(DISTINCT COL) queries to the SQL Interface > --- > > Key: SOLR-8919 > URL: https://issues.apache.org/jira/browse/SOLR-8919 > Project: Solr > Issue Type: Bug >Reporter: Joel Bernstein >Assignee: Joel Bernstein > Fix For: 6.2, master (7.0) > > > While analyzing the Enron emails for SOLR-, I was wishing that > COUNT(DISTINCT) was implemented. This ticket is to implement it. -- 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