Re: [VOTE] Release apache-calcite-avatica-1.19.0 (release candidate 0)

2021-10-07 Thread Jacques Nadeau
+1 (binding). Thanks for putting this together. Validated keys, that gradle-wrapper is excluded, built and tested on macos big sur. Worked with JDK8u302. Two issues I found: - Failed with JDK17 with a nonsensical gradle stacktrace. Guessing that isn't supported despite docs saying java8+? We

[jira] [Created] (CALCITE-4840) Readme from source release clearly state how to build

2021-10-07 Thread Jacques Nadeau (Jira)
Jacques Nadeau created CALCITE-4840: --- Summary: Readme from source release clearly state how to build Key: CALCITE-4840 URL: https://issues.apache.org/jira/browse/CALCITE-4840 Project: Calcite

Re: Problem using MySQL with JDBC

2021-10-07 Thread Justin Swanhart
And I immediately hit another little roadblock: Transaction isolation level TRANSACTION_REPEATABLE_READ is not supported. Default (TRANSACTION_NONE) will be used instead. 0: jdbc:calcite:schemaType=JDBC> !tables

Re: Problem using MySQL with JDBC

2021-10-07 Thread Justin Swanhart
Hi, I had to really go down a rabbit hole here to figure out exactly what was wrong (see below) but I was able to resolve the problem by adding the following to core/build.gradle.kts: implementation(files("/home/justin/testing/calcite/mysql-connector-java.jar")) It seems that the environmental

Re: [DISCUSS] Next releases

2021-10-07 Thread Jacques Nadeau
I merged the last patch and have linked the release ticket to a release note gist for the changes. Thanks. On Wed, Oct 6, 2021, 10:21 PM Jacques Nadeau wrote: > FYI, the last patch for immutables is up and passing all checks. I'll do > another pass in the morning to make sure everything looks

[jira] [Created] (CALCITE-4839) Remove remnants of ImmutableBeans post 1.28 release

2021-10-07 Thread Jacques Nadeau (Jira)
Jacques Nadeau created CALCITE-4839: --- Summary: Remove remnants of ImmutableBeans post 1.28 release Key: CALCITE-4839 URL: https://issues.apache.org/jira/browse/CALCITE-4839 Project: Calcite

[jira] [Created] (CALCITE-4838) add roundingMode in SqlConformance to document how to cast an approximate numeric to int

2021-10-07 Thread duan xiong (Jira)
duan xiong created CALCITE-4838: --- Summary: add roundingMode in SqlConformance to document how to cast an approximate numeric to int Key: CALCITE-4838 URL: https://issues.apache.org/jira/browse/CALCITE-4838

Re: [VOTE] Release apache-calcite-avatica-1.19.0 (release candidate 0)

2021-10-07 Thread Sergey Nuyanzin
+1 (non-binding) from my side, thanks Julian for preparing the RC! - Checked GPG signature - OK - Checked SHA512 - OK - Checked release notes on stage branch (https://github.com/apache/calcite-avatica/blob/stage/site/_docs/history.md) - OK (except probably the misprint mentioned by Alessandro) -

??????[DISCUSS] Apply materialized recognition to streaming compute of time-window aggregate.

2021-10-07 Thread 953396112
Hi Xurenhe Browse the design documents roughly. It seems that your materialized view scene is specialized, not universal and not applicable to Calcite. Now the materialized view recognition framework is extensible. You can customize the materialized view recognition rules and use the

[DISCUSS] Apply materialized recognition to streaming compute of time-window aggregate.

2021-10-07 Thread 徐仁和
Hello, calcite developers! Framework of Flink is widely used in our company for data cleaning and simple processing. And we found that some tasks can be rewritten and re-arranged by the materialized recognition, which reduces the overall computing resources. Calcite has the SQL semantics of

[jira] [Created] (CALCITE-4837) FLOOR and CEIL of DATE/TIMESTAMP return wrong results for DECADE, CENTURY and MILLENNIUM

2021-10-07 Thread Sergey Nuyanzin (Jira)
Sergey Nuyanzin created CALCITE-4837: Summary: FLOOR and CEIL of DATE/TIMESTAMP return wrong results for DECADE, CENTURY and MILLENNIUM Key: CALCITE-4837 URL:

Re: [ANNOUNCE] New committer: Zhaohui Xu

2021-10-07 Thread Alessandro Solimando
Congratulations Zhaohui, I have followed some of the contributions on the view-based rewritings, thanks for all the improvements! Best regards, Alessandro On Thu, 7 Oct 2021 at 07:27, Haisheng Yuan wrote: > Congratulations, Zhaohui, well deserved! > > Haisheng > > On 2021/10/06 21:14:00,

Re: [VOTE] Release apache-calcite-avatica-1.19.0 (release candidate 0)

2021-10-07 Thread Alessandro Solimando
+1 (non-binding), thanks Julian for preparing the RC! -) Checked hash and signature: OK -) Checked release notes: OK (but NoboGo should be NobiGo I think) -) Checked the release tag with right commit: OK -) Checking the tag and the tar.gz content: OK diff -qr apache-calcite-avatica-1.19.0-src