[jira] [Created] (CALCITE-1592) UnsupportedOperationException for queries with not(not()) filters

hongbin ma created CALCITE-1592: --- Summary: UnsupportedOperationException for queries with not(not()) filters Key: CALCITE-1592 URL: https://issues.apache.org/jira/browse/CALCITE-1592 Project: Calcite

[jira] [Commented] (CALCITE-1583) Wrong results for query with correlated subqueries with aggregate subquery expression

[ https://issues.apache.org/jira/browse/CALCITE-1583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828897#comment-15828897 ] Vineet Garg commented on CALCITE-1583: -- Similar scalar query {code} select * from emps where

[jira] [Updated] (CALCITE-1591) Druid adapter: Use "groupBy" query with extractionFn for time dimension

[ https://issues.apache.org/jira/browse/CALCITE-1591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1591: - Summary: Druid adapter: Use "groupBy" query with extractionFn for time dimension (was: Drill

[jira] [Created] (CALCITE-1591) Drill adapter: Use "groupBy" query with extractionFn for time dimension

Julian Hyde created CALCITE-1591: Summary: Drill adapter: Use "groupBy" query with extractionFn for time dimension Key: CALCITE-1591 URL: https://issues.apache.org/jira/browse/CALCITE-1591 Project:

[jira] [Created] (CALCITE-1590) Support Guava version 21.0

Julian Hyde created CALCITE-1590: Summary: Support Guava version 21.0 Key: CALCITE-1590 URL: https://issues.apache.org/jira/browse/CALCITE-1590 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-1584) ProjectRemoveRule loses field names

[ https://issues.apache.org/jira/browse/CALCITE-1584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828738#comment-15828738 ] Julian Hyde commented on CALCITE-1584: -- Ah, yes; not enough L1 cache in my brain; sorry I didn't

[jira] [Commented] (CALCITE-1584) ProjectRemoveRule loses field names

[ https://issues.apache.org/jira/browse/CALCITE-1584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828731#comment-15828731 ] Jess Balint commented on CALCITE-1584: -- hey Julian, This is the same issue I brought up on the

[jira] [Commented] (CALCITE-1589) Druid adapter: timeseries query shows all days, even if no data

[ https://issues.apache.org/jira/browse/CALCITE-1589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828700#comment-15828700 ] Jesus Camacho Rodriguez commented on CALCITE-1589: -- [~gian], in any case thanks for all

[jira] [Commented] (CALCITE-1589) Druid adapter: timeseries query shows all days, even if no data

[ https://issues.apache.org/jira/browse/CALCITE-1589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828691#comment-15828691 ] Gian Merlino commented on CALCITE-1589: --- You want "skipEmptyBuckets" : true in your query context.

[jira] [Commented] (CALCITE-1589) Druid adapter: timeseries query shows all days, even if no data

[ https://issues.apache.org/jira/browse/CALCITE-1589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828690#comment-15828690 ] Jesus Camacho Rodriguez commented on CALCITE-1589: -- [~nishantbangarwa] suggested the

[jira] [Updated] (CALCITE-1589) Druid adapter: timeseries query shows all days, even if no data

[ https://issues.apache.org/jira/browse/CALCITE-1589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated CALCITE-1589: - Description: Following query is transformed into timeseries Druid query

[jira] [Created] (CALCITE-1589) Druid adapter: timeseries query shows all days, even if no data

Jesus Camacho Rodriguez created CALCITE-1589: Summary: Druid adapter: timeseries query shows all days, even if no data Key: CALCITE-1589 URL: https://issues.apache.org/jira/browse/CALCITE-1589

[jira] [Issue Comment Deleted] (CALCITE-1587) Druid adapter: topN returns approximate results

[ https://issues.apache.org/jira/browse/CALCITE-1587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gian Merlino updated CALCITE-1587: -- Comment: was deleted (was: In Druid's SQL dialect, for distinct-count, even if you disable

[jira] [Commented] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

[ https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828664#comment-15828664 ] Gian Merlino commented on CALCITE-1588: --- In Druid's SQL dialect, for distinct-count, even if you

[jira] [Commented] (CALCITE-1587) Druid adapter: topN returns approximate results

[ https://issues.apache.org/jira/browse/CALCITE-1587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828660#comment-15828660 ] Gian Merlino commented on CALCITE-1587: --- In Druid's SQL dialect, for distinct-count, even if you

[jira] [Commented] (CALCITE-1587) Druid adapter: topN returns approximate results

[ https://issues.apache.org/jira/browse/CALCITE-1587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828662#comment-15828662 ] Gian Merlino commented on CALCITE-1587: --- Oops I commented on the wrong issue. Meant that for

[jira] [Commented] (CALCITE-1581) UDTF like in hive

[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828640#comment-15828640 ] Julian Hyde commented on CALCITE-1581: -- Ah, I understand. It is the same as [LINQ's SelectMany

[jira] [Commented] (CALCITE-1584) ProjectRemoveRule loses field names

[ https://issues.apache.org/jira/browse/CALCITE-1584?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828630#comment-15828630 ] Julian Hyde commented on CALCITE-1584: -- I don't understand. Maybe you're making some assumptions

[jira] [Comment Edited] (CALCITE-1575) Literals may lose precision during expression reduction

[ https://issues.apache.org/jira/browse/CALCITE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828584#comment-15828584 ] Julian Hyde edited comment on CALCITE-1575 at 1/18/17 7:17 PM: --- Thanks for

[jira] [Created] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

Julian Hyde created CALCITE-1588: Summary: Add SQL syntax to allow approximate LIMIT and distinct-COUNT Key: CALCITE-1588 URL: https://issues.apache.org/jira/browse/CALCITE-1588 Project: Calcite

[jira] [Commented] (CALCITE-1587) Druid adapter: topN returns approximate results

[ https://issues.apache.org/jira/browse/CALCITE-1587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828599#comment-15828599 ] Julian Hyde commented on CALCITE-1587: -- Agree with [~gian], we should enable approximation only if

[jira] [Commented] (CALCITE-1575) Literals may lose precision during expression reduction

[ https://issues.apache.org/jira/browse/CALCITE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828584#comment-15828584 ] Julian Hyde commented on CALCITE-1575: -- Thanks for reviewing, [~jcamachorodriguez]. I force-pushed

[jira] [Updated] (CALCITE-1575) Literals may lose precision during expression reduction

[ https://issues.apache.org/jira/browse/CALCITE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1575: - Summary: Literals may lose precision during expression reduction (was: Literals may loose

[jira] [Commented] (CALCITE-1587) Druid adapter: topN returns approximate results

[ https://issues.apache.org/jira/browse/CALCITE-1587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828547#comment-15828547 ] Gian Merlino commented on CALCITE-1587: --- In Druid's built-in SQL we make this an option,

[jira] [Commented] (CALCITE-1578) Druid adapter: wrong semantics of topN query limit with granularity

[ https://issues.apache.org/jira/browse/CALCITE-1578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828546#comment-15828546 ] slim bouguerra commented on CALCITE-1578: - [~julianhyde] please check the comments on

[jira] [Commented] (CALCITE-1566) Better documentation on the use of materialized views

[ https://issues.apache.org/jira/browse/CALCITE-1566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828544#comment-15828544 ] Michael Mior commented on CALCITE-1566: --- Thanks for the suggestions! Agreed that it would be

[jira] [Commented] (CALCITE-1578) Druid adapter: wrong semantics of topN query limit with granularity

[ https://issues.apache.org/jira/browse/CALCITE-1578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828493#comment-15828493 ] Nishant Bangarwa commented on CALCITE-1578: --- Here is a sample query using extraction function,

[jira] [Created] (CALCITE-1587) Druid adapter: topN returns approximate results

Jesus Camacho Rodriguez created CALCITE-1587: Summary: Druid adapter: topN returns approximate results Key: CALCITE-1587 URL: https://issues.apache.org/jira/browse/CALCITE-1587 Project:

[jira] [Commented] (CALCITE-1578) Druid adapter: wrong semantics of topN query limit with granularity

[ https://issues.apache.org/jira/browse/CALCITE-1578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15828486#comment-15828486 ] slim bouguerra commented on CALCITE-1578: - as per [~gian] suggested the best way to do this is

[jira] [Comment Edited] (CALCITE-1578) Druid adapter: wrong semantics of topN query limit with granularity

[ https://issues.apache.org/jira/browse/CALCITE-1578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15827694#comment-15827694 ] Jesus Camacho Rodriguez edited comment on CALCITE-1578 at 1/18/17 4:02 PM:

[jira] [Resolved] (CALCITE-1575) Literals may loose precision during expression reduction

[ https://issues.apache.org/jira/browse/CALCITE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-1575. -- Resolution: Fixed Fix Version/s: 1.12.0 Fixed in

[jira] [Comment Edited] (CALCITE-1575) Literals may loose precision during expression reduction

[ https://issues.apache.org/jira/browse/CALCITE-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15827773#comment-15827773 ] Jesus Camacho Rodriguez edited comment on CALCITE-1575 at 1/18/17 10:09 AM:

[jira] [Commented] (CALCITE-1578) Druid adapter: wrong semantics of topN query limit with granularity

[ https://issues.apache.org/jira/browse/CALCITE-1578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15827694#comment-15827694 ] Jesus Camacho Rodriguez commented on CALCITE-1578: -- [~julianhyde], +1, patch LGTM,

[jira] [Updated] (CALCITE-1578) Druid adapter: wrong semantics of topN query limit with granularity

[ https://issues.apache.org/jira/browse/CALCITE-1578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated CALCITE-1578: - Assignee: Julian Hyde (was: Jesus Camacho Rodriguez) > Druid adapter:

[jira] [Commented] (CALCITE-1581) UDTF like in hive

[ https://issues.apache.org/jira/browse/CALCITE-1581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15827594#comment-15827594 ] Xiaoyong Deng commented on CALCITE-1581: Thanks, Julian. My request is a stream compute