Re: Ability to access Calcite JDBC remotely from another JDBC client such as DBeaver/DataGrip

[Gavin Ray]

Heya, I actually wrote quite a long tutorial on how to connect to Calcite
via SQuirreL/DBeaver or similar tools.
It's not a simple process.

Here is the guide:
Making Apache Calcite work in SQuirreL SQL Client (github.com)




On Wed, Nov 8, 2023 at 1:55 PM TJ Banghart 
wrote:

> Hello Raja and welcome to Calcite!
>
> I have found it helpful to think of an Avatica server in terms of its main
> interfaces Service
> <
> https://github.com/apache/calcite-avatica/blob/519d1ceeb04cd99530bceb60c1a8e0966c413541/core/src/main/java/org/apache/calcite/avatica/remote/Service.java#L59C7-L59C7
> >
> and Meta
> <
> https://github.com/apache/calcite-avatica/blob/519d1ceeb04cd99530bceb60c1a8e0966c413541/core/src/main/java/org/apache/calcite/avatica/Meta.java#L53
> >.
> The service implementation determines what RPC message format to use as
> well as what RPCs are available. The meta implementation determines how the
> server retrieves metadata, executes queries, etc.
> When starting the server we can supply both the service and meta
> implementations we want to use. In this case we want the server to access
> Calcite locally while using the generic Avatica driver from a JDBC client
> like DBeaver. For example (in Kotlin):
>
> class MyJdbcServer(port: Int) {
> val meta: Meta = MyCalciteMetaFactory().create()
> val service: Service = LocalService(meta)
> val server: HttpServer = HttpServer(port, AvaticaJsonHandler(service))
>
> ... methods to start/stop server etc...
> }
>
> class MyCalciteMetaFactory() : Meta.Factory {
> override fun create(args: List?): Meta {
> val info: Properties = ...some method to generate Calcite
> connection props...
> val driver: Driver = Driver()
> val connection: AvaticaConnection = driver.connect("jdbc:calcite:",
> info) as AvaticaConnection?
>
> return driver.createMeta(connection)
> }
> }
>
>
> All RPCs from the JDBC client using the generic Avatica driver should be
> handled by the local CalciteMetaImpl
> <
> https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/jdbc/CalciteMetaImpl.java
> >
> instance
> associated with the server. This is the same as if you had a local Calcite
> connection. Note that this will not work behind a load-balancer as local
> Calcite connections are "stateful" (see CALCITE-668
> ).
> I'm sure others might have a better way but this has worked for us so far!
>
> On Wed, Nov 8, 2023 at 9:00 AM Raja Ranjan Senapati  >
> wrote:
>
> > Team,
> >   I am a newbie to Calcite and am excited about its potential. I have a
> > question. According to the status section on the docs page
> > , calcite supports Local and remote
> JDBC
> > drivers using Avatica.  My interpretation of that statement is we can
> wrap
> > any data source using Calcite and expose the data by creating a JDBC
> > server. This JDBC server can be accessed remotely using the remote
> Calcite
> > JDBC driver, from tools such as DBeaver/DataGrip.
> >
> >  I can create a local JDBC wrapper on my data source and use it from the
> > same JVM. However, I cannot find any sample code that would create a JDBC
> > server and serve remote clients using a remote JDBC server. I explored
> > concepts like Avatica Http Server
> > <
> >
> https://calcite.apache.org/avatica/javadocAggregate/org/apache/calcite/avatica/server/HttpServer.html
> > >but
> > could not find any concrete implementation using Calcite. Can you please
> > point me to some references/samples? I think it would be awesome if you
> > could add this to some FAQ/Tutorial page in Calcite as well.
> >
> > Thanks,
> > Raja Senapati
> >
>
>
> --
>
> TJ
>

Re: Ability to access Calcite JDBC remotely from another JDBC client such as DBeaver/DataGrip

[TJ Banghart]

Hello Raja and welcome to Calcite!

I have found it helpful to think of an Avatica server in terms of its main
interfaces Service

and Meta
.
The service implementation determines what RPC message format to use as
well as what RPCs are available. The meta implementation determines how the
server retrieves metadata, executes queries, etc.
When starting the server we can supply both the service and meta
implementations we want to use. In this case we want the server to access
Calcite locally while using the generic Avatica driver from a JDBC client
like DBeaver. For example (in Kotlin):

class MyJdbcServer(port: Int) {
val meta: Meta = MyCalciteMetaFactory().create()
val service: Service = LocalService(meta)
val server: HttpServer = HttpServer(port, AvaticaJsonHandler(service))

... methods to start/stop server etc...
}

class MyCalciteMetaFactory() : Meta.Factory {
override fun create(args: List?): Meta {
val info: Properties = ...some method to generate Calcite
connection props...
val driver: Driver = Driver()
val connection: AvaticaConnection = driver.connect("jdbc:calcite:",
info) as AvaticaConnection?

return driver.createMeta(connection)
}
}


All RPCs from the JDBC client using the generic Avatica driver should be
handled by the local CalciteMetaImpl

instance
associated with the server. This is the same as if you had a local Calcite
connection. Note that this will not work behind a load-balancer as local
Calcite connections are "stateful" (see CALCITE-668
).
I'm sure others might have a better way but this has worked for us so far!

On Wed, Nov 8, 2023 at 9:00 AM Raja Ranjan Senapati 
wrote:

> Team,
>   I am a newbie to Calcite and am excited about its potential. I have a
> question. According to the status section on the docs page
> , calcite supports Local and remote JDBC
> drivers using Avatica.  My interpretation of that statement is we can wrap
> any data source using Calcite and expose the data by creating a JDBC
> server. This JDBC server can be accessed remotely using the remote Calcite
> JDBC driver, from tools such as DBeaver/DataGrip.
>
>  I can create a local JDBC wrapper on my data source and use it from the
> same JVM. However, I cannot find any sample code that would create a JDBC
> server and serve remote clients using a remote JDBC server. I explored
> concepts like Avatica Http Server
> <
> https://calcite.apache.org/avatica/javadocAggregate/org/apache/calcite/avatica/server/HttpServer.html
> >but
> could not find any concrete implementation using Calcite. Can you please
> point me to some references/samples? I think it would be awesome if you
> could add this to some FAQ/Tutorial page in Calcite as well.
>
> Thanks,
> Raja Senapati
>


-- 

TJ

Ability to access Calcite JDBC remotely from another JDBC client such as DBeaver/DataGrip

[Raja Ranjan Senapati]

Team,
  I am a newbie to Calcite and am excited about its potential. I have a
question. According to the status section on the docs page
, calcite supports Local and remote JDBC
drivers using Avatica.  My interpretation of that statement is we can wrap
any data source using Calcite and expose the data by creating a JDBC
server. This JDBC server can be accessed remotely using the remote Calcite
JDBC driver, from tools such as DBeaver/DataGrip.

 I can create a local JDBC wrapper on my data source and use it from the
same JVM. However, I cannot find any sample code that would create a JDBC
server and serve remote clients using a remote JDBC server. I explored
concepts like Avatica Http Server
but
could not find any concrete implementation using Calcite. Can you please
point me to some references/samples? I think it would be awesome if you
could add this to some FAQ/Tutorial page in Calcite as well.

Thanks,
Raja Senapati

Re: [VOTE] Release Apache Calcite 1.36.0 (release candidate 0)

[Stamatis Zampetakis]

Ubuntu 20.04.6 LTS, jdk1.8.0_261, Gradle wrapper, Gradle 7.6.1

 * Checked signatures and checksums OK
 * Went over release note OK
 * Checked diff between repo and artifacts OK
 * Checked README, LICENSE, NOTICE files (Logged CALCITE-6095 to CALCITE-6099)
 * Built from git tag and run tests (./gradlew clean build) OK
 * Built from source distribution and run tests OK
 * Checked META-INF content/structure from calcite-core and
calcite-redis artifacts in nexus OK

I have the impression that all LICENSE/NOTICE issues logged under
CALCITE-609[5-9] are minor and can be fixed after the release. If
someone has a different opinion please comment under the respective
ticket and if necessary mark it as blocker.

+1 (binding)

Best,
Stamatis

On Wed, Nov 8, 2023 at 11:26 AM Ran Tao  wrote:
>
> Thanks Benchao for preparing this calcite-1.36 !
>
> 1.check calcite-src link, tag link, calcite-src-tar link, signature link
> OK
>
> 2.check SHA-512 & GPG signature
> OK
>
> 3.download calcite-1.36.0-src.tar.gz, gradle build with macos sonoma 14.0,
> m1 chip, open jdk-11
> OK
>
> 4.run sqlline with some version related sqls
> OK
>
> +1(non-binding) from my side.
>
> Best Regards,
> Ran Tao
>
>
> Benchao Li  于2023年11月8日周三 18:00写道：
>
> > Thank you all for helping verify the release. One small declaration,
> > only PMC voting is binding according to apache guidelines[1].
> >
> > [1] https://www.apache.org/foundation/voting.html#binding-votes
> >
> > Bertil Chapuis  于2023年11月8日周三 17:32写道：
> > >
> > > Thank you for preparing the release.
> > > - Checksum: ok
> > > - Signature: ok
> > > - Build + test: ok
> > >
> > > +1 (binding)
> > >
> > > Notice that the build requires Gradle v7.6.1 and fails with Gradle v8.4.
> > >
> > > Best,
> > >
> > > Bertil
> > >
> > >
> > > > On 8 Nov 2023, at 08:50, Ruben Q L  wrote:
> > > >
> > > > Thanks Benchao for preparing this release.
> > > >
> > > > - Release notes: ok
> > > > - Checksum: ok
> > > > - Signature: ok
> > > > - Diff source release and git repository: ok
> > > > - Build + tests: ok
> > > > - Calcite-based application test suite: ok
> > > >
> > > > +1 (binding)
> > > >
> > > > Best,
> > > > Ruben
> > > >
> > > >
> > > > On Tue, Nov 7, 2023 at 9:32 PM Francis Chuang <
> > francischu...@apache.org>
> > > > wrote:
> > > >
> > > >> Thanks for being RM for this release, Benchao!
> > > >>
> > > >> My vote is: +1 (binding)
> > > >>
> > > >> - Verified GPG signature - OK
> > > >> - Verified SHA512 - OK
> > > >> - Diffed source release and git repository - OK
> > > >> - Checked release notes on tag
> > > >> (
> > > >>
> > https://github.com/apache/calcite/blob/calcite-1.36.0-rc0/site/_docs/history.md
> > )
> > > >>
> > > >> - OK
> > > >> - Checked year and versions in NOTICE, README and HOWTO - OK
> > > >> - Ran tests (gradle check) - OK
> > > >> - Spot checked Nexus artifacts - OK
> > > >>
> > > >> Environment:
> > > >> Eclipse-temurin:19-jammy docker container in WSL2 (Ubuntu 22.04.3) on
> > > >> Windows 11 22h2
> > > >>
> > > >> $ docker version
> > > >> Client: Docker Engine - Community
> > > >>  Cloud integration: v1.0.35+desktop.5
> > > >>  Version:   24.0.6
> > > >>  API version:   1.43
> > > >>  Go version:go1.20.7
> > > >>  Git commit:ed223bc
> > > >>  Built: Mon Sep  4 12:32:16 2023
> > > >>  OS/Arch:   linux/amd64
> > > >>  Context:   default
> > > >>
> > > >> Server: Docker Desktop
> > > >>  Engine:
> > > >>   Version:  24.0.6
> > > >>   API version:  1.43 (minimum version 1.12)
> > > >>   Go version:   go1.20.7
> > > >>   Git commit:   1a79695
> > > >>   Built:Mon Sep  4 12:32:16 2023
> > > >>   OS/Arch:  linux/amd64
> > > >>   Experimental: false
> > > >>  containerd:
> > > >>   Version:  1.6.22
> > > >>   GitCommit:8165feabfdfe38c65b599c4993d227328c231fca
> > > >>  runc:
> > > >>   Version:  1.1.8
> > > >>   GitCommit:v1.1.8-0-g82f18fe
> > > >>  docker-init:
> > > >>   Version:  0.19.0
> > > >>   GitCommit:de40ad0
> > > >>
> > > >> $ gradle -v
> > > >>
> > > >> 
> > > >> Gradle 7.6.1
> > > >> 
> > > >>
> > > >> Build time:   2023-02-24 13:54:42 UTC
> > > >> Revision: 3905fe8ac072bbd925c70ddbf4463341f4b4
> > > >>
> > > >> Kotlin:   1.7.10
> > > >> Groovy:   3.0.13
> > > >> Ant:  Apache Ant(TM) version 1.10.11 compiled on July 10 2021
> > > >> JVM:  19.0.2 (Eclipse Adoptium 19.0.2+7)
> > > >> OS:   Linux 5.15.90.1-microsoft-standard-WSL2 amd64
> > > >>
> > > >> $ java --version
> > > >> openjdk 19.0.2 2023-01-17
> > > >> OpenJDK Runtime Environment Temurin-19.0.2+7 (build 19.0.2+7)
> > > >> OpenJDK 64-Bit Server VM Temurin-19.0.2+7 (build 19.0.2+7, mixed mode,
> > > >> sharing)
> > > >>
> > > >> Francis
> > > >>
> > > >> On 8/11/2023 7:55 am, Julian Hyde wrote:
> > > >>> Oops, 

[jira] [Created] (CALCITE-6099) Missing LICENSE entry for _pygments.scss

[Stamatis Zampetakis (Jira)]

Stamatis Zampetakis created CALCITE-6099:


 Summary: Missing LICENSE entry for _pygments.scss
 Key: CALCITE-6099
 URL: https://issues.apache.org/jira/browse/CALCITE-6099
 Project: Calcite
  Issue Type: Bug
Affects Versions: 1.36.0
Reporter: Stamatis Zampetakis


The 
[_pygment.scss|https://github.com/apache/calcite/blob/4c9011c388f826c36463ae7da875ddb525104376/site/_sass/_pygments.scss]
 file is present both in git and source distribution but there is no info about 
its LICENSE.

I don't know the exact provenance of the file but I found a lot of similarities 
with:
[desert.css|https://github.com/StylishThemes/Syntax-Themes/blob/bfeb1da4fbbb895b9c247e0f289b0e945243e94d/pygments/css-other/desert.css].

If that's the true origin of the file then we should examine the respective 
[LICENSE|https://github.com/StylishThemes/Syntax-Themes/blob/bfeb1da4fbbb895b9c247e0f289b0e945243e94d/LICENSE]
 and if necessary include it.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-6098) Remove mentions of Jekyll from LICENSE and NOTICE files

[Stamatis Zampetakis (Jira)]

Stamatis Zampetakis created CALCITE-6098:


 Summary: Remove mentions of Jekyll from LICENSE and NOTICE files
 Key: CALCITE-6098
 URL: https://issues.apache.org/jira/browse/CALCITE-6098
 Project: Calcite
  Issue Type: Task
Affects Versions: 1.36.0
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis


The NOTICE file contains the following statement:
{noformat}
The web site includes files generated by Jekyll.{noformat}
 
However, there is nothing in the [LICENSE of Jekyll 
|https://github.com/jekyll/jekyll/blob/3f3a283018a976da11a0bfcc13a20d43d37ee29f/LICENSE]
 that requires such attribution. 

According to the instructions of composing the [NOTICE 
file|https://infra.apache.org/licensing-howto.html#mod-notice] for ASF projects 
we shouldn't add anything in there that is not *legally* required.

Moreover the generated files are not necessary licensed under the same LICENSE 
with the generator. 

JavaCC, ANTLR, and lots of other source generators use a variety of licenses 
but the generated output is not licensed under the same terms. For instance, 
Calcite uses JavaCC, which is licensed under 
[BSD-3|https://github.com/javacc/javacc/blob/master/LICENSE]  but both the 
grammar as well as the generated .java files are AL2.

As long as we are not packaging bits of Jekyll in Calcite there is no need to 
add explicit mentions in LICENSE or NOTICE files.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-6097) cobyism/gridism CSS dependency is mispelled in LICENSE

[Stamatis Zampetakis (Jira)]

Stamatis Zampetakis created CALCITE-6097:


 Summary: cobyism/gridism CSS dependency is mispelled in LICENSE
 Key: CALCITE-6097
 URL: https://issues.apache.org/jira/browse/CALCITE-6097
 Project: Calcite
  Issue Type: Bug
Affects Versions: 1.36.0
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis


The website uses  the 
[gridism.css|https://github.com/apache/calcite/blob/4c9011c388f826c36463ae7da875ddb525104376/site/_sass/_gridism.scss]
 style for presentation purposes. The file is present in git and also in the 
source distribution of Calcite so it should have a proper reference in the 
[LICENSE|https://github.com/apache/calcite/blob/4c9011c388f826c36463ae7da875ddb525104376/LICENSE#L186]
 file.

There is an entry in the LICENSE file but it is mispelled: gridsim vs gridism



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-6096) Remove obsolete html5shiv and respond entries from LICENSE

[Stamatis Zampetakis (Jira)]

Stamatis Zampetakis created CALCITE-6096:


 Summary: Remove obsolete html5shiv and respond entries from LICENSE
 Key: CALCITE-6096
 URL: https://issues.apache.org/jira/browse/CALCITE-6096
 Project: Calcite
  Issue Type: Task
  Components: build
Affects Versions: 1.36.0
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis


The [LICENSE 
file|https://github.com/apache/calcite/blob/4c9011c388f826c36463ae7da875ddb525104376/LICENSE#L184C3-L184C26]
 includes the following entries:

* cobyism:html5shiv:3.7.2
* respond:respond:1.4.2

implying that we are bundling the respective dependencies in the project.

These dependencies correspond to minified javascript files that were removed 
completely from the project [some time 
ago|https://github.com/apache/calcite/commit/7f5e9b8b7e6b4afd8e4f21524aa3c4ce8b7ddb61].
 The references are obsolete and must be removed.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Re: [VOTE] Release Apache Calcite 1.36.0 (release candidate 0)

[Ran Tao]

Thanks Benchao for preparing this calcite-1.36 !

1.check calcite-src link, tag link, calcite-src-tar link, signature link
OK

2.check SHA-512 & GPG signature
OK

3.download calcite-1.36.0-src.tar.gz, gradle build with macos sonoma 14.0,
m1 chip, open jdk-11
OK

4.run sqlline with some version related sqls
OK

+1(non-binding) from my side.

Best Regards,
Ran Tao


Benchao Li  于2023年11月8日周三 18:00写道：

> Thank you all for helping verify the release. One small declaration,
> only PMC voting is binding according to apache guidelines[1].
>
> [1] https://www.apache.org/foundation/voting.html#binding-votes
>
> Bertil Chapuis  于2023年11月8日周三 17:32写道：
> >
> > Thank you for preparing the release.
> > - Checksum: ok
> > - Signature: ok
> > - Build + test: ok
> >
> > +1 (binding)
> >
> > Notice that the build requires Gradle v7.6.1 and fails with Gradle v8.4.
> >
> > Best,
> >
> > Bertil
> >
> >
> > > On 8 Nov 2023, at 08:50, Ruben Q L  wrote:
> > >
> > > Thanks Benchao for preparing this release.
> > >
> > > - Release notes: ok
> > > - Checksum: ok
> > > - Signature: ok
> > > - Diff source release and git repository: ok
> > > - Build + tests: ok
> > > - Calcite-based application test suite: ok
> > >
> > > +1 (binding)
> > >
> > > Best,
> > > Ruben
> > >
> > >
> > > On Tue, Nov 7, 2023 at 9:32 PM Francis Chuang <
> francischu...@apache.org>
> > > wrote:
> > >
> > >> Thanks for being RM for this release, Benchao!
> > >>
> > >> My vote is: +1 (binding)
> > >>
> > >> - Verified GPG signature - OK
> > >> - Verified SHA512 - OK
> > >> - Diffed source release and git repository - OK
> > >> - Checked release notes on tag
> > >> (
> > >>
> https://github.com/apache/calcite/blob/calcite-1.36.0-rc0/site/_docs/history.md
> )
> > >>
> > >> - OK
> > >> - Checked year and versions in NOTICE, README and HOWTO - OK
> > >> - Ran tests (gradle check) - OK
> > >> - Spot checked Nexus artifacts - OK
> > >>
> > >> Environment:
> > >> Eclipse-temurin:19-jammy docker container in WSL2 (Ubuntu 22.04.3) on
> > >> Windows 11 22h2
> > >>
> > >> $ docker version
> > >> Client: Docker Engine - Community
> > >>  Cloud integration: v1.0.35+desktop.5
> > >>  Version:   24.0.6
> > >>  API version:   1.43
> > >>  Go version:go1.20.7
> > >>  Git commit:ed223bc
> > >>  Built: Mon Sep  4 12:32:16 2023
> > >>  OS/Arch:   linux/amd64
> > >>  Context:   default
> > >>
> > >> Server: Docker Desktop
> > >>  Engine:
> > >>   Version:  24.0.6
> > >>   API version:  1.43 (minimum version 1.12)
> > >>   Go version:   go1.20.7
> > >>   Git commit:   1a79695
> > >>   Built:Mon Sep  4 12:32:16 2023
> > >>   OS/Arch:  linux/amd64
> > >>   Experimental: false
> > >>  containerd:
> > >>   Version:  1.6.22
> > >>   GitCommit:8165feabfdfe38c65b599c4993d227328c231fca
> > >>  runc:
> > >>   Version:  1.1.8
> > >>   GitCommit:v1.1.8-0-g82f18fe
> > >>  docker-init:
> > >>   Version:  0.19.0
> > >>   GitCommit:de40ad0
> > >>
> > >> $ gradle -v
> > >>
> > >> 
> > >> Gradle 7.6.1
> > >> 
> > >>
> > >> Build time:   2023-02-24 13:54:42 UTC
> > >> Revision: 3905fe8ac072bbd925c70ddbf4463341f4b4
> > >>
> > >> Kotlin:   1.7.10
> > >> Groovy:   3.0.13
> > >> Ant:  Apache Ant(TM) version 1.10.11 compiled on July 10 2021
> > >> JVM:  19.0.2 (Eclipse Adoptium 19.0.2+7)
> > >> OS:   Linux 5.15.90.1-microsoft-standard-WSL2 amd64
> > >>
> > >> $ java --version
> > >> openjdk 19.0.2 2023-01-17
> > >> OpenJDK Runtime Environment Temurin-19.0.2+7 (build 19.0.2+7)
> > >> OpenJDK 64-Bit Server VM Temurin-19.0.2+7 (build 19.0.2+7, mixed mode,
> > >> sharing)
> > >>
> > >> Francis
> > >>
> > >> On 8/11/2023 7:55 am, Julian Hyde wrote:
> > >>> Oops, Ubuntu 23.10. Obviously.
> > >>>
> > >>> On Tue, Nov 7, 2023 at 12:02 PM Julian Hyde 
> wrote:
> > 
> >  +1 (binding)
> > 
> >  Downloaded; checked signatures & hashes; checked LICENSE, NOTICE,
> >  README, README.md, howto.md, history.md; ran RAT; compared to git
> tag.
> >  Built and ran tests using Gradle 7.4.2, OpenJDK 19.0.2, Ubuntu
> 24.10.
> > 
> >  Thanks Benchao!
> > 
> >  Julian
> > 
> >  On Tue, Nov 7, 2023 at 7:41 AM LakeShen 
> > >> wrote:
> > >
> > > Thanks to Benchao’s contributions
> > >
> > > +1(binding)
> > >
> > > Best,
> > > LakeShen
> > >
> > > Benchao Li  于2023年11月7日周二 13:20写道：
> > >
> > >> Hi all,
> > >>
> > >> I have created a build for Apache Calcite 1.36.0, release
> > >> candidate 0.
> > >>
> > >> Thanks to everyone who has contributed to this release.
> > >>
> > >> You can read the release notes here:
> > >>
> > >>
> > >>
> 

Re: [VOTE] Release Apache Calcite 1.36.0 (release candidate 0)

[Benchao Li]

Thank you all for helping verify the release. One small declaration,
only PMC voting is binding according to apache guidelines[1].

[1] https://www.apache.org/foundation/voting.html#binding-votes

Bertil Chapuis  于2023年11月8日周三 17:32写道：
>
> Thank you for preparing the release.
> - Checksum: ok
> - Signature: ok
> - Build + test: ok
>
> +1 (binding)
>
> Notice that the build requires Gradle v7.6.1 and fails with Gradle v8.4.
>
> Best,
>
> Bertil
>
>
> > On 8 Nov 2023, at 08:50, Ruben Q L  wrote:
> >
> > Thanks Benchao for preparing this release.
> >
> > - Release notes: ok
> > - Checksum: ok
> > - Signature: ok
> > - Diff source release and git repository: ok
> > - Build + tests: ok
> > - Calcite-based application test suite: ok
> >
> > +1 (binding)
> >
> > Best,
> > Ruben
> >
> >
> > On Tue, Nov 7, 2023 at 9:32 PM Francis Chuang 
> > wrote:
> >
> >> Thanks for being RM for this release, Benchao!
> >>
> >> My vote is: +1 (binding)
> >>
> >> - Verified GPG signature - OK
> >> - Verified SHA512 - OK
> >> - Diffed source release and git repository - OK
> >> - Checked release notes on tag
> >> (
> >> https://github.com/apache/calcite/blob/calcite-1.36.0-rc0/site/_docs/history.md)
> >>
> >> - OK
> >> - Checked year and versions in NOTICE, README and HOWTO - OK
> >> - Ran tests (gradle check) - OK
> >> - Spot checked Nexus artifacts - OK
> >>
> >> Environment:
> >> Eclipse-temurin:19-jammy docker container in WSL2 (Ubuntu 22.04.3) on
> >> Windows 11 22h2
> >>
> >> $ docker version
> >> Client: Docker Engine - Community
> >>  Cloud integration: v1.0.35+desktop.5
> >>  Version:   24.0.6
> >>  API version:   1.43
> >>  Go version:go1.20.7
> >>  Git commit:ed223bc
> >>  Built: Mon Sep  4 12:32:16 2023
> >>  OS/Arch:   linux/amd64
> >>  Context:   default
> >>
> >> Server: Docker Desktop
> >>  Engine:
> >>   Version:  24.0.6
> >>   API version:  1.43 (minimum version 1.12)
> >>   Go version:   go1.20.7
> >>   Git commit:   1a79695
> >>   Built:Mon Sep  4 12:32:16 2023
> >>   OS/Arch:  linux/amd64
> >>   Experimental: false
> >>  containerd:
> >>   Version:  1.6.22
> >>   GitCommit:8165feabfdfe38c65b599c4993d227328c231fca
> >>  runc:
> >>   Version:  1.1.8
> >>   GitCommit:v1.1.8-0-g82f18fe
> >>  docker-init:
> >>   Version:  0.19.0
> >>   GitCommit:de40ad0
> >>
> >> $ gradle -v
> >>
> >> 
> >> Gradle 7.6.1
> >> 
> >>
> >> Build time:   2023-02-24 13:54:42 UTC
> >> Revision: 3905fe8ac072bbd925c70ddbf4463341f4b4
> >>
> >> Kotlin:   1.7.10
> >> Groovy:   3.0.13
> >> Ant:  Apache Ant(TM) version 1.10.11 compiled on July 10 2021
> >> JVM:  19.0.2 (Eclipse Adoptium 19.0.2+7)
> >> OS:   Linux 5.15.90.1-microsoft-standard-WSL2 amd64
> >>
> >> $ java --version
> >> openjdk 19.0.2 2023-01-17
> >> OpenJDK Runtime Environment Temurin-19.0.2+7 (build 19.0.2+7)
> >> OpenJDK 64-Bit Server VM Temurin-19.0.2+7 (build 19.0.2+7, mixed mode,
> >> sharing)
> >>
> >> Francis
> >>
> >> On 8/11/2023 7:55 am, Julian Hyde wrote:
> >>> Oops, Ubuntu 23.10. Obviously.
> >>>
> >>> On Tue, Nov 7, 2023 at 12:02 PM Julian Hyde  wrote:
> 
>  +1 (binding)
> 
>  Downloaded; checked signatures & hashes; checked LICENSE, NOTICE,
>  README, README.md, howto.md, history.md; ran RAT; compared to git tag.
>  Built and ran tests using Gradle 7.4.2, OpenJDK 19.0.2, Ubuntu 24.10.
> 
>  Thanks Benchao!
> 
>  Julian
> 
>  On Tue, Nov 7, 2023 at 7:41 AM LakeShen 
> >> wrote:
> >
> > Thanks to Benchao’s contributions
> >
> > +1(binding)
> >
> > Best,
> > LakeShen
> >
> > Benchao Li  于2023年11月7日周二 13:20写道：
> >
> >> Hi all,
> >>
> >> I have created a build for Apache Calcite 1.36.0, release
> >> candidate 0.
> >>
> >> Thanks to everyone who has contributed to this release.
> >>
> >> You can read the release notes here:
> >>
> >>
> >> https://github.com/apache/calcite/blob/calcite-1.36.0-rc0/site/_docs/history.md
> >>
> >> The commit to be voted upon:
> >>
> >>
> >> https://gitbox.apache.org/repos/asf?p=calcite.git;a=commit;h=0be8eaebcf27afae9ecda8ab79db63c214426561
> >>
> >> Its hash is 0be8eaebcf27afae9ecda8ab79db63c214426561
> >>
> >> Tag:
> >> https://github.com/apache/calcite/tree/calcite-1.36.0-rc0
> >>
> >> The artifacts to be voted on are located here:
> >>
> >> https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-1.36.0-rc0
> >> (revision 65079)
> >>
> >> The hashes of the artifacts are as follows:
> >>
> >>
> >> 3bf003a87f76f2fa85b6af9b5243cddf67c767cb5caa828532784bd380e0d929da097677a453dc8d6a0d31f8cf97085031cf66b15a390571065b666095db3b80
> >> 

Re: [VOTE] Release Apache Calcite 1.36.0 (release candidate 0)

[Bertil Chapuis]

Thank you for preparing the release.
- Checksum: ok
- Signature: ok
- Build + test: ok

+1 (binding)

Notice that the build requires Gradle v7.6.1 and fails with Gradle v8.4.

Best,

Bertil


> On 8 Nov 2023, at 08:50, Ruben Q L  wrote:
> 
> Thanks Benchao for preparing this release.
> 
> - Release notes: ok
> - Checksum: ok
> - Signature: ok
> - Diff source release and git repository: ok
> - Build + tests: ok
> - Calcite-based application test suite: ok
> 
> +1 (binding)
> 
> Best,
> Ruben
> 
> 
> On Tue, Nov 7, 2023 at 9:32 PM Francis Chuang 
> wrote:
> 
>> Thanks for being RM for this release, Benchao!
>> 
>> My vote is: +1 (binding)
>> 
>> - Verified GPG signature - OK
>> - Verified SHA512 - OK
>> - Diffed source release and git repository - OK
>> - Checked release notes on tag
>> (
>> https://github.com/apache/calcite/blob/calcite-1.36.0-rc0/site/_docs/history.md)
>> 
>> - OK
>> - Checked year and versions in NOTICE, README and HOWTO - OK
>> - Ran tests (gradle check) - OK
>> - Spot checked Nexus artifacts - OK
>> 
>> Environment:
>> Eclipse-temurin:19-jammy docker container in WSL2 (Ubuntu 22.04.3) on
>> Windows 11 22h2
>> 
>> $ docker version
>> Client: Docker Engine - Community
>>  Cloud integration: v1.0.35+desktop.5
>>  Version:   24.0.6
>>  API version:   1.43
>>  Go version:go1.20.7
>>  Git commit:ed223bc
>>  Built: Mon Sep  4 12:32:16 2023
>>  OS/Arch:   linux/amd64
>>  Context:   default
>> 
>> Server: Docker Desktop
>>  Engine:
>>   Version:  24.0.6
>>   API version:  1.43 (minimum version 1.12)
>>   Go version:   go1.20.7
>>   Git commit:   1a79695
>>   Built:Mon Sep  4 12:32:16 2023
>>   OS/Arch:  linux/amd64
>>   Experimental: false
>>  containerd:
>>   Version:  1.6.22
>>   GitCommit:8165feabfdfe38c65b599c4993d227328c231fca
>>  runc:
>>   Version:  1.1.8
>>   GitCommit:v1.1.8-0-g82f18fe
>>  docker-init:
>>   Version:  0.19.0
>>   GitCommit:de40ad0
>> 
>> $ gradle -v
>> 
>> 
>> Gradle 7.6.1
>> 
>> 
>> Build time:   2023-02-24 13:54:42 UTC
>> Revision: 3905fe8ac072bbd925c70ddbf4463341f4b4
>> 
>> Kotlin:   1.7.10
>> Groovy:   3.0.13
>> Ant:  Apache Ant(TM) version 1.10.11 compiled on July 10 2021
>> JVM:  19.0.2 (Eclipse Adoptium 19.0.2+7)
>> OS:   Linux 5.15.90.1-microsoft-standard-WSL2 amd64
>> 
>> $ java --version
>> openjdk 19.0.2 2023-01-17
>> OpenJDK Runtime Environment Temurin-19.0.2+7 (build 19.0.2+7)
>> OpenJDK 64-Bit Server VM Temurin-19.0.2+7 (build 19.0.2+7, mixed mode,
>> sharing)
>> 
>> Francis
>> 
>> On 8/11/2023 7:55 am, Julian Hyde wrote:
>>> Oops, Ubuntu 23.10. Obviously.
>>> 
>>> On Tue, Nov 7, 2023 at 12:02 PM Julian Hyde  wrote:
 
 +1 (binding)
 
 Downloaded; checked signatures & hashes; checked LICENSE, NOTICE,
 README, README.md, howto.md, history.md; ran RAT; compared to git tag.
 Built and ran tests using Gradle 7.4.2, OpenJDK 19.0.2, Ubuntu 24.10.
 
 Thanks Benchao!
 
 Julian
 
 On Tue, Nov 7, 2023 at 7:41 AM LakeShen 
>> wrote:
> 
> Thanks to Benchao’s contributions
> 
> +1(binding)
> 
> Best,
> LakeShen
> 
> Benchao Li  于2023年11月7日周二 13:20写道：
> 
>> Hi all,
>> 
>> I have created a build for Apache Calcite 1.36.0, release
>> candidate 0.
>> 
>> Thanks to everyone who has contributed to this release.
>> 
>> You can read the release notes here:
>> 
>> 
>> https://github.com/apache/calcite/blob/calcite-1.36.0-rc0/site/_docs/history.md
>> 
>> The commit to be voted upon:
>> 
>> 
>> https://gitbox.apache.org/repos/asf?p=calcite.git;a=commit;h=0be8eaebcf27afae9ecda8ab79db63c214426561
>> 
>> Its hash is 0be8eaebcf27afae9ecda8ab79db63c214426561
>> 
>> Tag:
>> https://github.com/apache/calcite/tree/calcite-1.36.0-rc0
>> 
>> The artifacts to be voted on are located here:
>> 
>> https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-1.36.0-rc0
>> (revision 65079)
>> 
>> The hashes of the artifacts are as follows:
>> 
>> 
>> 3bf003a87f76f2fa85b6af9b5243cddf67c767cb5caa828532784bd380e0d929da097677a453dc8d6a0d31f8cf97085031cf66b15a390571065b666095db3b80
>> *apache-calcite-1.36.0-src.tar.gz
>> 
>> A staged Maven repository is available for review at:
>> 
>> 
>> https://repository.apache.org/content/repositories/orgapachecalcite-1219/org/apache/calcite/
>> 
>> Release artifacts are signed with the following key:
>> https://people.apache.org/keys/committer/libenchao.asc
>> https://www.apache.org/dist/calcite/KEYS
>> 
>> To create the jars and test Apache Calcite: "gradle build"
>> (requires an appropriate Gradle/JDK installation)