Re: date function error

2017-08-15 Thread Josh Elser
Hi, This sounds like a timezone issue to me. Depending on how you wrote the date, conversion from GMT into your local timezone can appear to "change" a date. Can you try setting the timeZone[1] parameter in the JDBC URL? [1]

date function error

2017-08-15 Thread apache_...@163.com
Hi, when i run sql by kyline GUI,Right result is 2011-02-28,but i got 2011-03-01,is bug? select cast('2011-03-31' as date) - INTERVAL '1' month from KYLIN_CAL_DT apache_...@163.com

[jira] [Created] (CALCITE-1945) Allow custom return types for AVG/VARIANCE/STDDEV/COVAR

2017-08-15 Thread MinJi Kim (JIRA)
MinJi Kim created CALCITE-1945: -- Summary: Allow custom return types for AVG/VARIANCE/STDDEV/COVAR Key: CALCITE-1945 URL: https://issues.apache.org/jira/browse/CALCITE-1945 Project: Calcite

[jira] [Created] (CALCITE-1944) Wrong plan for query with window functions and subquery with star

2017-08-15 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-1944: Summary: Wrong plan for query with window functions and subquery with star Key: CALCITE-1944 URL: https://issues.apache.org/jira/browse/CALCITE-1944

[jira] [Created] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Dian Fu (JIRA)
Dian Fu created CALCITE-1943: Summary: Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl Key: CALCITE-1943 URL: https://issues.apache.org/jira/browse/CALCITE-1943 Project: Calcite