[jira] [Created] (CALCITE-5415) In ByteString, add startsWith and endsWith methods

Julian Hyde created CALCITE-5415: Summary: In ByteString, add startsWith and endsWith methods Key: CALCITE-5415 URL: https://issues.apache.org/jira/browse/CALCITE-5415 Project: Calcite Issue

[jira] [Created] (CALCITE-5414) Use DateTimeUtils to correctly convert between java.sql types and unix timestamps

Gregory Hart created CALCITE-5414: - Summary: Use DateTimeUtils to correctly convert between java.sql types and unix timestamps Key: CALCITE-5414 URL: https://issues.apache.org/jira/browse/CALCITE-5414

[jira] [Created] (CALCITE-5413) Nested Subqueries with correlated variables are not decorrelated correctly

James Starr created CALCITE-5413: Summary: Nested Subqueries with correlated variables are not decorrelated correctly Key: CALCITE-5413 URL: https://issues.apache.org/jira/browse/CALCITE-5413

Re: Structuring SubQueries as Functions

Hi Julian, I want to propose changing calcite's RexSubQuery. So the SubQuery would have up to N+M rex children(N is the number of correlated variables used and M is the number of rex nodes for expression. SELECT t1.c1 IN ( SELECT t2.c1 FROM (VALUES (1, 2)) AS t2(c1, c2) WHERE t1.c2 =

Spatial type extension

Hello Everyone, I think that CALCITE-5362 [1, 2] is ready to be merged. It consists in spatial measurement functions of a relatively low complexity. Each function is covered by several test cases in the spatial.iq file. Similarly, CALCITE-5280 [3, 4] is in a decent shape. The ST_Union,

Re: Structuring SubQueries as Functions

I do agree that a correlated sub-query is a function call. If you write your queries using CROSS APPLY this becomes clear. Decorrelation is very useful. Some execution engines, especially the highly parallel/distributed ones, stopping and restarting subqueries requires a lot of communication.

Structuring SubQueries as Functions

Currently sub-query correlated variables have a brittle contract with their containing RelNode. Simple rules such as ones that transpose filters and projects are unaware of this contract and would be difficult to retrofit to handle all the rules to be sub-query aware. A correlated sub-query is

[jira] [Created] (CALCITE-5412) ROLLUP/CUBE non-standard syntax support logic is buggy

Leonid Chistov created CALCITE-5412: --- Summary: ROLLUP/CUBE non-standard syntax support logic is buggy Key: CALCITE-5412 URL: https://issues.apache.org/jira/browse/CALCITE-5412 Project: Calcite

[jira] [Created] (CALCITE-5411) Update Spark Dialect to support ROLLUP & CUBE aggregate functions.

Leonid Chistov created CALCITE-5411: --- Summary: Update Spark Dialect to support ROLLUP & CUBE aggregate functions. Key: CALCITE-5411 URL: https://issues.apache.org/jira/browse/CALCITE-5411 Project: