Re: Supporting named row construction in Calcite SQL

2018-04-05 Thread Rong Rong
Thanks for the fantastic proposal @shuyi. I think the STRUCT idea is great considering ROW is not standard SQL either. As a user of calcite I have a couple questions. Since ROW constructor is so similar with STRUCT, would it be a good idea to consolidate the two syntax? Or have a clear

Re: Supporting named row construction in Calcite SQL

2018-04-05 Thread Andrew Pilloud
As a user of Calcite working on adding streaming SQL to Apache Beam this sounds like a fantastic proposal. Our initial goal is to be able to run SQL queries that transform arbitrary JSON objects. Without this syntax objects must be flattened when they pass through the transform. Is this something

[jira] [Created] (CALCITE-2241) Join equality condition should be considered while pushing down filter conditions with expressions disjunction for both tables

2018-04-05 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created CALCITE-2241: Summary: Join equality condition should be considered while pushing down filter conditions with expressions disjunction for both tables Key: CALCITE-2241 URL:

[jira] [Created] (CALCITE-2240) Predicate push into CASE statment doesn't happen in some cases

2018-04-05 Thread Zoltan Haindrich (JIRA)
Zoltan Haindrich created CALCITE-2240: - Summary: Predicate push into CASE statment doesn't happen in some cases Key: CALCITE-2240 URL: https://issues.apache.org/jira/browse/CALCITE-2240 Project:

Re: Supporting named row construction in Calcite SQL

2018-04-05 Thread Shuyi Chen
@Michael, @Albert, yes, I dont think it is SQL standard. But I think it's very useful in the context of streaming SQL, e.g. Flink SQL, where the sinks can be a database or endpoints with defined protobuf/thrift schema. They usually have complex structure. Supporting complex structure in SQL output

Calcite-Master - Build # 241 - Still Failing

2018-04-05 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #241) Status: Still Failing Check console output at https://builds.apache.org/job/Calcite-Master/241/ to view the results.