[jira] [Created] (CALCITE-1950) Avatica HSQLDB docker image hangs

2017-08-16 Thread Francis Chuang (JIRA)
Francis Chuang created CALCITE-1950: --- Summary: Avatica HSQLDB docker image hangs Key: CALCITE-1950 URL: https://issues.apache.org/jira/browse/CALCITE-1950 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-1949) CalciteStatement leads memory leak

2017-08-16 Thread fuping.wang (JIRA)
fuping.wang created CALCITE-1949: Summary: CalciteStatement leads memory leak Key: CALCITE-1949 URL: https://issues.apache.org/jira/browse/CALCITE-1949 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-1948) Publish avatica-hypersql, avatica-mysql and avatica-postgres to docker hub

2017-08-16 Thread Francis Chuang (JIRA)
Francis Chuang created CALCITE-1948: --- Summary: Publish avatica-hypersql, avatica-mysql and avatica-postgres to docker hub Key: CALCITE-1948 URL: https://issues.apache.org/jira/browse/CALCITE-1948 Pr

[jira] [Created] (CALCITE-1947) Add time/timestamp with time zone types to optimizer

2017-08-16 Thread Jesus Camacho Rodriguez (JIRA)
Jesus Camacho Rodriguez created CALCITE-1947: Summary: Add time/timestamp with time zone types to optimizer Key: CALCITE-1947 URL: https://issues.apache.org/jira/browse/CALCITE-1947 Project

Calcite-Master - Build # 95 - Failure

2017-08-16 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #95) Status: Failure Check console output at https://builds.apache.org/job/Calcite-Master/95/ to view the results.

[jira] [Created] (CALCITE-1946) Query containing cascaded aggregation gets converted to incorrect sql

2017-08-16 Thread Pawel Ruchaj (JIRA)
Pawel Ruchaj created CALCITE-1946: - Summary: Query containing cascaded aggregation gets converted to incorrect sql Key: CALCITE-1946 URL: https://issues.apache.org/jira/browse/CALCITE-1946 Project: Ca

How to use Calcite to optimize index scan like in traditional database?

2017-08-16 Thread Kaiwang Chen
Hi there, HepPlanner chooses the one with smallest Cumulative Cost from transformations by a rule. LoptOptimizeJoinRule searches for the best ordering of a MultiJoin. How to consider indices during the search? Is there any RelNode that is suitable to hold physical access path? Looks like TableSca

Re: date function error

2017-08-16 Thread Julian Hyde
This looks related to https://issues.apache.org/jira/browse/CALCITE-1639 , which was fixed in 1.13 but only dealt with the TIMESTAMPADD function. Maybe “ - ” should have the same behavior. Someone should consult the SQL standard and other DBs b

Re: date function error

2017-08-16 Thread Josh Elser
I'm not sure how to give you more context as I'm not familiar with how Kylin uses Calcite/Avatica. Best suggestion I can give you is to look at the raw value (if you can?) and compare that to what you receive via your SQL query. This is likely a problem with either the TZ configuration when yo

Re: Re: date function error

2017-08-16 Thread apache_...@163.com
HI, thinks . Can you describe it clearer? Local server(linux) timezone is correct. ZONE="Asia/Shanghai" apache_...@163.com From: Josh Elser Date: 2017-08-16 10:52 To: dev Subject: Re: date function error Hi, This sounds like a timezone issue to me. Depending on how you wrote the