[jira] [Created] (CALCITE-1661) Recognize aggregation function types as FRACTIONAL instead of DOUBLE

2017-02-27 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-1661: Summary: Recognize aggregation function types as FRACTIONAL instead of DOUBLE Key: CALCITE-1661 URL: https://issues.apache.org/jira/browse/CALCITE-1661

Re: Towards Calcite release 1.12

2017-02-27 Thread Jesus Camacho Rodriguez
Out of that list, these three are assigned to me, I will have them ready for this release. * https://issues.apache.org/jira/browse/CALCITE-1413 New CASE statement simplification * https://issues.apache.org/jira/browse/CALCITE-1421 Update website documentation to verify a release * https://issues.

[jira] [Created] (CALCITE-1662) TimestampDiffConvertlet uses second resolution even for sub-second units

2017-02-27 Thread Remus Rusanu (JIRA)
Remus Rusanu created CALCITE-1662: - Summary: TimestampDiffConvertlet uses second resolution even for sub-second units Key: CALCITE-1662 URL: https://issues.apache.org/jira/browse/CALCITE-1662 Project:

[jira] [Created] (CALCITE-1663) TIMESTAMPDIFF declares operand type DATETIME instead of TIMESTMAP

2017-02-27 Thread Remus Rusanu (JIRA)
Remus Rusanu created CALCITE-1663: - Summary: TIMESTAMPDIFF declares operand type DATETIME instead of TIMESTMAP Key: CALCITE-1663 URL: https://issues.apache.org/jira/browse/CALCITE-1663 Project: Calcit

[jira] [Created] (CALCITE-1664) CAST('' as TIMESTAMP) adds part of sub-second fraction to the value

2017-02-27 Thread Remus Rusanu (JIRA)
Remus Rusanu created CALCITE-1664: - Summary: CAST('' as TIMESTAMP) adds part of sub-second fraction to the value Key: CALCITE-1664 URL: https://issues.apache.org/jira/browse/CALCITE-1664 Project: Calc

Re: Towards Calcite release 1.12

2017-02-27 Thread Julian Hyde
Thanks, Jesus; I have added those to 1647’s dependencies. It doesn’t sound as if this release is urgent for anyone. Let’s put it on hold for now. Julian > On Feb 27, 2017, at 2:51 AM, Jesus Camacho Rodriguez > wrote: > > Out of that list, these three are assigned to me, I will have them > re

Re: Expressing windowed stream-stream joins in SQL

2017-02-27 Thread Julian Hyde
Your query SELECT STREAM a.foo, b.bar FROM a JOIN a.id = b.id GROUP BY TUMBLE(a. rowtime, INTERVAL '1' MINUTE) won't work because there is no constraint on b.rowtime. The system would literally have to wait forever before it could move on from a, or output a total. Let’s try this: SELE

Hyperunique aggregations in Calcite-Druid Adapter

2017-02-27 Thread Vihag Gupta
In my Druid data source, I have a hyperUnique aggregation (ingestion time) on one of the fields. I am trying to do the equivalent of COUNT(DISTINCT()) on this aggregated field. Is it supported in the Calcite Druid Adapter? If so, what is the correct way to go about it? P.S. In plywood, I can d