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

; > > >Version: 20.10.8 > > > >API version: 1.41 (minimum version 1.12) > > > >Go version: go1.16.6 > > > >Git commit: 75249d8 > > > >Built:Fri Jul 30 19:52:31 2021 > > > >OS/

Re: [DISCUSS] Next releases

up today > and if all goes well, get that merged before the release. > > On Wed, Oct 6, 2021 at 11:34 AM Julian Hyde wrote: > >> So, the vote for Avatica 1.19 is underway, and we will likely have a >> release in 4 or 5 days. >> >> Next up, Calcite release 1.28. I'l

Re: Can`t build master of calcite.

Vladimir, I think that's too harsh. In practice people aren't on the latest JDK version. (CI environments usually are, and therefore we'll tend to miss these issues.) We should make the process as painless as possible for everyone. Julian On 2021/10/06 10:54:17, Vladimir Sitnikov wrote: >

Re: Problem using MySQL with JDBC

on't understand why just using a connection string works, >> so I am really confused. I assume some other class name is being used when >> I just use the connection string, but I don't know how to figure out what >> that class name is. >> >> On Wed, Oct 6, 2021

Re: Problem using MySQL with JDBC

he MySQL documentation says to use > com.mysql.cj.jdbc.Driver: > https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-connect-drivermanager.html > > I suppose this is some kind of MySQL JDBC problem, so this may not be the > right mailing list, but if you have any s

Re: [DISCUSS] Next releases

ge but I can rebase on master and fix > > issues, if any. > > > > Best regards, > > Alessandro > > > > On Mon, 27 Sept 2021 at 07:52, Julian Hyde wrote: > > > >> Can people please try to review and merge the Avatica PRs this week? > >> Severa

[jira] [Created] (CALCITE-4835) Release Calcite 1.28.0

Julian Hyde created CALCITE-4835: Summary: Release Calcite 1.28.0 Key: CALCITE-4835 URL: https://issues.apache.org/jira/browse/CALCITE-4835 Project: Calcite Issue Type: Bug

Re: Problem using MySQL with JDBC

It looks as if com.mysql.cj.jdbc.Driver is not on your class path. If you are launching via SQLLine, you will need to edit the sqlline shell script to add a jar (or jars) to your class path. Julian > On Oct 6, 2021, at 10:43 AM, Justin Swanhart wrote: > > I am probably making some obvious

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

Hi all, I have created a build for Apache Calcite Avatica 1.19.0, release candidate 0. Thanks to everyone who has contributed to this release. And thank you to Francis, Vladimir and Stamatis for assistance with the release process. You can read the release notes here:

Re: (CALCITE-4292) Wrong results in ElasticSearch when query contains NOT EQUAL

I support Stamatis’ position. Our SQL adapter must implement SQL semantics. That is what users of a SQL interface want and expect. If Elasticsearch’s data model has nuances that cannot be captured in SQL, feel free to add extra operators. If name is a multi-valued attribute, then some ideas

Re: Avatica dry-run

311b85b8c8bacde6d2ff70c309930e/docker.sh#L251 > > Francis > > On 5/10/2021 7:24 pm, Julian Hyde wrote: > > Francis, > > > > That helped somewhat. I was able to get the Docker-powered server > > running using your instructions. (From reading the HOWTO, I had no >

Re: Avatica dry-run

signing.gnupg.executable=gpg > > signing.gnupg.useLegacyGpg=false > > signing.gnupg.keyName=D77C3383F1927570 > > signing.gnupg.passphrase= > > asfSvnUsername=zabetak > > asfSvnPassword=YYY > > asfGitSourceUsername=zabetak > > asfGitSourcePassword= >

Re: Avatica dry-run

I'm still running into this 'Connection refused' error. It's a show-stopper. I cannot make a release candidate unless this problem is solved. On Mon, Oct 4, 2021 at 10:58 AM Julian Hyde wrote: > > This is the command I used: > > docker-compose run -v ~/.gnupg:/.gnupg dry-run >

Re: Avatica dry-run

> Logs: > https://github.com/vlsi/vlsi-release-plugins/runs/3794304055?check_suite_focus=true > > Vladimir > > > пн, 4 окт. 2021 г. в 20:15, Julian Hyde : > > > As release manager for the upcoming Avatica 1.19, I just tried to use > > the docker-based dry-run.

Avatica dry-run

As release manager for the upcoming Avatica 1.19, I just tried to use the docker-based dry-run. I got the following failure: Build calcite-avatica FAILURE reason: Execution failed for task ':initializeNexusStagingRepository': java.io.UncheckedIOException: java.net.ConnectException:

Re: [DISCUSS] Add extra check for Avatica to run tests with different timezone

I don’t think we should do randomized CI. > On Oct 2, 2021, at 1:32 PM, Vladimir Sitnikov > wrote: > > Here's a randomized matrix for Avatica: > https://github.com/apache/calcite-avatica/pull/156 > https://github.com/apache/calcite-avatica/actions/runs/1298777387 > > Vladimir

Re: [DISCUSS] Add extra check for Avatica to run tests with different timezone

> Do you suggest test all OS, all Guava versions, all timezones in CI? > That is hard to maintain and it takes CI time No I don’t suggest that. That seemed to be what you were suggesting! My suggestion is to test a ‘diagonal’. Suppose we need to test 5 JDK versions, 5 Guava versions, and 5

Re: INSERT Query Question

I’m not sure whether ROW is ‘correct’ SQL, but I agree that it’s not idiomatic SQL to use ROW inside a VALUES inside an INSERT. SQL generation is controlled by the SqlDialect class. Typically we add tests to RelToSqlConverterTest. https://issues.apache.org/jira/browse/CALCITE-3344

Re: [DISCUSS] Add extra check for Avatica to run tests with different timezone

+1 for tests in different time zones. And also tests with different Guava versions. In fact I’m working on it: see https://github.com/julianhyde/calcite-avatica/commits/stage and

[jira] [Created] (CALCITE-4815) Avatica's Travis fails with 'LICENSE-like files are missing' error

Julian Hyde created CALCITE-4815: Summary: Avatica's Travis fails with 'LICENSE-like files are missing' error Key: CALCITE-4815 URL: https://issues.apache.org/jira/browse/CALCITE-4815 Project

Re: [DISCUSS] Syntax upgrade about Session Window Table Function

)); -- or with the named params -- >> note: the DATA param must be the first SELECT * FROM TABLE( SESSION( DATA >> => TABLE orders PARTITION BY product, TIMECOL => DESCRIPTOR(rowtime), SIZE >> => INTERVAL '20' MINUTE)); > > > Best, > JING ZHANG > > Julian

Re: [DISCUSS] Syntax upgrade about Session Window Table Function

Regarding changes to the syntax of the SESSION table function. I am open to this, even though it would be a breaking change. Can you give an example of a query before and after the syntax change? I would like to support the new PARTITIONED BY clause for table functions. I encourage you to make

Re: [DISCUSS] Next releases

Can people please try to review and merge the Avatica PRs this week? Several look ready: https://github.com/apache/calcite-avatica/pulls Julian > On Sep 24, 2021, at 6:22 PM, Haisheng Yuan wrote: > > Sounds good! > > On 2021/09/25 01:13:26, Julian Hyde wrote: >&g

Re: [DISCUSS] Pronouns

We should suggest that they add themselves to https://github.com/apache/calcite/blob/master/site/_data/contributors.yml. In that file, the instructions should note that the pronouns field is available if they wish to specify. On Fri, Sep 24, 2021 at 5:39 AM Stamatis Zampetakis wrote: > > +1 > >

Re: [DISCUSS] Next releases

4, 2021 at 3:35 AM Stamatis Zampetakis > wrote: > > > From the last discussion [1], the list was the following for Calcite: > > > > Julian Hyde for 1.28.0 > > Rui Wang for 1.29.0 > > Andrei Sereda for 1.30.0 > > Liya Fan for 1.31.0 &g

Re: Error parsing DATE("2021-01-01") for BigQuery, using Calcite

It’s possible you will also need to use the Babel parser, because DATE is a reserved keyword and therefore the parser needs to work in a different mode in order to see it as a function name. I think I made the DATE function work for Redshift but I’m not sure I did it for BigQuery. > On Sep

[DISCUSS] Next releases

We're about due for releases of Avatica and Calcite. Who's next up on the release manager schedule?

Re: [DISCUSS] Remove contributors name from commit summary

release. Or let people’s contributions speak for themselves (if you want to know who did a change, browse GitHub). I lean towards the last of these, but I want to hear what others think. The goal, as ever, is to build a strong community. Julian > On Sep 23, 2021, at 7:37 AM, Julian H

Re: [DISCUSS] Remove contributors name from commit summary

+1 > On Sep 23, 2021, at 2:23 AM, Stamatis Zampetakis wrote: > > Hi all, > > Currently we are supposed to append the contributors name to the commit > summary when they are not committers of the project. The main reason for > doing this if I am not mistaken is to give some credit to those

[jira] [Created] (CALCITE-4795) In class SqlBasicCall, make the "operands" field private.

Julian Hyde created CALCITE-4795: Summary: In class SqlBasicCall, make the "operands" field private. Key: CALCITE-4795 URL: https://issues.apache.org/jira/browse/CALCITE-4795 Projec

Re: SqlBasicCall.clone shallow copy

That looks like a bug. Cloning a SqlCall and then calling setOperand on it is valid, and should not modify the original SqlCall. We tend to avoid calling ’set’ methods on SqlNodes - we treat them as immutable except that the validator will replace an argument with an equivalent argument (e.g.

Re: COALESCE returns maximum of available CHAR capacity.

The current behavior looks ok to me. The expression has type CHAR(2) because the arguments have types CHAR(1) and CHAR(2). So ‘a’ is widened to ‘a ‘. Julian > On Sep 22, 2021, at 12:00 AM, stanilovsky evgeny > wrote: > > sorry for typo, 'fill the ticket' of course )) > >> hi community ! >>

Re: Guava version

va.version=19.0. > > James > > > On Tue, Sep 21, 2021 at 4:09 PM Julian Hyde wrote: > >> How do I set the Guava version from the Gradle command line? >> >> I’d expect >> >> ./gradlew -Dguava.version=19.0 >> >> to work but it d

[jira] [Created] (CALCITE-4789) Build is broken on Guava versions < 21

Julian Hyde created CALCITE-4789: Summary: Build is broken on Guava versions < 21 Key: CALCITE-4789 URL: https://issues.apache.org/jira/browse/CALCITE-4789 Project: Calcite Issue Type:

Guava version

How do I set the Guava version from the Gradle command line? I’d expect ./gradlew -Dguava.version=19.0 to work but it doesn’t. (We used to test the supported range of Guava versions in CI. Then we stopped because Gradle. And now it turns out that we’re broken on Gradle < 21.0.) Julian

Re: ApacheCon 2021 talks about Apache Calcite

It’s not ApacheCon, but I am giving a talk at StrangeLoop in 2 weeks. The talk is about Morel but Calcite gets a prominent mention. https://thestrangeloop.com/2021/morel-a-functional-query-language.html Julian > On Sep

Re: Tableau dialect specification for Calcite

ood place to start since it > uses Calcite: > > https://github.com/dremio-hub/tableau-connector > > > On Fri, Sep 10, 2021 at 12:37 PM Julian Hyde wrote: > >> Tableau has a text file [1] where you can define your dialect. It lets >> Tableau know how to

Tableau dialect specification for Calcite

Tableau has a text file [1] where you can define your dialect. It lets Tableau know how to generate SQL to extract a year from a date, for example. Has anyone written that dialect specification for Calcite or a system that uses Calcite's SQL parser (such as Druid, Phoenix)? Since those systems

[jira] [Created] (CALCITE-4763) EXISTS_AGG, an aggregate function that returns whether count is positive

Julian Hyde created CALCITE-4763: Summary: EXISTS_AGG, an aggregate function that returns whether count is positive Key: CALCITE-4763 URL: https://issues.apache.org/jira/browse/CALCITE-4763 Project

[jira] [Created] (CALCITE-4762) Upgrade to Avatica 1.19

Julian Hyde created CALCITE-4762: Summary: Upgrade to Avatica 1.19 Key: CALCITE-4762 URL: https://issues.apache.org/jira/browse/CALCITE-4762 Project: Calcite Issue Type: Bug

Re: [jira] [Created] (CALCITE-4760) Should not need to initialize a jdbc:calcite driver to make a RelBuilder

I am inclined to fix this by creating a connection directly, not via the JDBC DriverManager. But that has the potential to break people who are relying on the DriverManager. If this would affect you, please speak up by adding comments to the JIRA case. This particular case seems to be related

Re: Runtime Exception while using SqlParse.

Yes, the error message is not good enough. Can you please log a bug? The error comes from org.apache.calcite.linq4j.tree.BinaryExpression, which I very much doubt happens at parse time. If you can add a test case, or a complete error stack, that would be appreciated. > On Aug 18, 2021, at

Re: Analyzing SQL queries with default catalog/database names

A key step in validation is to fully-quality table names. Thus in your example, mytable would become the string array [“hive”, “my_database”, “mytable”]. Any my_database2.mytable2 would become [“hive”, “my_database2”, “mytable2”]. But foo would remain foo, because it is in the query and is not

Re: Visualization of Graphviz

or pointing out the visualizer in the Tempura branch. It looks > quite promising. > > Cordialement / Best Regards, > *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com > > > On Thu, Aug 12, 2021 at 7:19 PM Julian Hyde wrote: > >> I don’t have a st

[jira] [Created] (CALCITE-4737) Add Volcano visualizer for debugging

Julian Hyde created CALCITE-4737: Summary: Add Volcano visualizer for debugging Key: CALCITE-4737 URL: https://issues.apache.org/jira/browse/CALCITE-4737 Project: Calcite Issue Type: Bug

Re: Visualization of Graphviz

I don’t have a strong opinion on this, but I want to point out that there are some GraphViz improvements as part of Tempura (the case is https://issues.apache.org/jira/browse/CALCITE-4568 ; the specific commit is

[jira] [Created] (CALCITE-4728) Parse and validate procedural code (such as SQL/PSM, PL/SQL, PL/pgSQL, T-SQL)

Julian Hyde created CALCITE-4728: Summary: Parse and validate procedural code (such as SQL/PSM, PL/SQL, PL/pgSQL, T-SQL) Key: CALCITE-4728 URL: https://issues.apache.org/jira/browse/CALCITE-4728

Re: QueryableTable can only be implemented as ENUMERABLE convention

It’s a reasonable ask. Can you please log a JIRA case? Julian > On Aug 11, 2021, at 5:09 AM, Martin Jonsson > wrote: > > Hello all. > It is mentioned in the code (1.27) that QueryableTable can only be with > Enumerable Convention. Is there a workaround to have it work with Bindable >

[jira] [Created] (CALCITE-4723) Check whether JDBC adapter generates "GROUP BY ()" against Oracle, DB2, MSSQL

Julian Hyde created CALCITE-4723: Summary: Check whether JDBC adapter generates "GROUP BY ()" against Oracle, DB2, MSSQL Key: CALCITE-4723 URL: https://issues.apache.org/jira/browse/CA

Reviewer/committer needed for [CALCITE-4544] Deprecate Metadata API backed by Java Reflection

https://issues.apache.org/jira/browse/CALCITE-4544 looks like something we want, but I am too busy to commit it. It is a major change that requires due diligence. Can someone volunteer to review and commit this? Julian

Re: Integrate the Cosette prover in Calcite's RelNode rewrite tests

Shuxian, It would be great to carry on this integration. I downloaded and built your project. (I also opened a pull request[1], adding a maven wrapper and a README.) It’s difficult to get at the RelNodes in RelOptRulesTest if you’re outside Calcite. (Because it is a test, we don’t currently

[jira] [Created] (CALCITE-4720) Obsolete the Collect relational operator, using Aggregate and ARRAY_AGG (and new aggregate functions MULTISET_AGG and MAP_AGG) instead

Julian Hyde created CALCITE-4720: Summary: Obsolete the Collect relational operator, using Aggregate and ARRAY_AGG (and new aggregate functions MULTISET_AGG and MAP_AGG) instead Key: CALCITE-4720 URL: https

[jira] [Created] (CALCITE-4719) Add variants of RexSubQuery that collect sub-queries into MULTISET, ARRAY and MAP collections

Julian Hyde created CALCITE-4719: Summary: Add variants of RexSubQuery that collect sub-queries into MULTISET, ARRAY and MAP collections Key: CALCITE-4719 URL: https://issues.apache.org/jira/browse/CALCITE-4719

Fwd: [DISCUSS] Developing an "Arrow Compute IR [Intermediate Representation]" to decouple language front ends from Arrow-native compute engines

On dev@arrow, Wes McKinney just started a discussion of a language for “programming” Arrow. One of its explicit goals is for systems like Calcite to generate such code as their physical plan. This would be great for Calcite. Arrow started as an excellent runtime for high-performance data

Re: ClassCastException: FamilyOperandTypeChecker cannot be cast to SqlOperandMetadata

SqlOperandMetadata only needs to be implemented by user-defined functions. (User-defined functions have fixed number of parameters, and the parameters have names; built-in functions may have a variable number of arguments, but they do not have names.) So, maybe the cause is a function that

Re: does Calcite have the mathematical equation transformation such a + b = c to a = c - b

Calcite doesn’t transform a + b = c” to “a = c - b for good reason… someone would also want to transform a - b = c” to “a = c + b and the two transforms would cycle. To put it another way: Calcite’s expression simplification is not smart/powerful enough to do theorem proving. Our rule of

[jira] [Created] (CALCITE-4711) RexProgramBuilder should not simplify

Julian Hyde created CALCITE-4711: Summary: RexProgramBuilder should not simplify Key: CALCITE-4711 URL: https://issues.apache.org/jira/browse/CALCITE-4711 Project: Calcite Issue Type: Bug

Re: Changing the Parser

There is some documentation: https://calcite.apache.org/docs/adapter.html#extending-the-parser . > On Jul 29, 2021, at 7:04 PM, Vladimir Sitnikov > wrote: > > https://issues.apache.org/jira/browse/CALCITE-4701 seems

[jira] [Created] (CALCITE-4707) Optimize incremental maintenance of materialized views

Julian Hyde created CALCITE-4707: Summary: Optimize incremental maintenance of materialized views Key: CALCITE-4707 URL: https://issues.apache.org/jira/browse/CALCITE-4707 Project: Calcite

Re: Support on Avatica driver for Reactive JDBC (R2DBC)

Avatica does not currently support R2DBC. I was not previously aware of R2DBC but it looks like a useful extension to JDBC for streaming apps. (When I was at SQLstream, we had to make similar extensions, e.g. providing a callback method that would be executed each time a record was available

On vacation

I’m on vacation for the next week, pretty much offline. I’d appreciate if someone could review PRs, etc. Julian

[jira] [Created] (CALCITE-4687) Add LIMIT to WITHIN GROUP clause of aggregate functions

Julian Hyde created CALCITE-4687: Summary: Add LIMIT to WITHIN GROUP clause of aggregate functions Key: CALCITE-4687 URL: https://issues.apache.org/jira/browse/CALCITE-4687 Project: Calcite

Re: Support for constraints in jdbc adapter and optional decorrelation step in PlannerImpl.rel?

Re 1. It seems that the Server parser goes further than the Server implementation. You can specify PRIMARY KEY in the DDL, and we can parse it, but Server cannot create tables with primary keys. Please log a bug. Contributions welcome. One workaround is for you to parse but not execute. The

Re: Deduplicate correlate variables question.

Thanks, yes, that’s better. > On Jun 30, 2021, at 10:34 PM, stanilovsky evgeny > wrote: > > thanks! done, i hope ) > >> Thanks! Can you improve the JIRA subject, so that everyone reading the >> release notes will understand it? (I had to look up COLLECTION_TABLE.) >> >> >>> On Jun 30,

Re: Deduplicate correlate variables question.

Thanks! Can you improve the JIRA subject, so that everyone reading the release notes will understand it? (I had to look up COLLECTION_TABLE.) > On Jun 30, 2021, at 5:12 AM, stanilovsky evgeny > wrote: > > Guys, i fill the ticket [1] and PR is ready for check, can anyone take a look > on it

[jira] [Created] (CALCITE-4671) Allow Avatica connect-string properties in any case (lowerCamel, UPPER_SNAKE, etc.)

Julian Hyde created CALCITE-4671: Summary: Allow Avatica connect-string properties in any case (lowerCamel, UPPER_SNAKE, etc.) Key: CALCITE-4671 URL: https://issues.apache.org/jira/browse/CALCITE-4671

Re: [ANNOUNCE] New committer: Vladimir Ozerov

s might boost Apache Calcite adoption > dramatically. Hopefully, we will find time to invest in it. > > Regards, > Vladimir. > > пт, 25 июн. 2021 г. в 09:52, Fan Liya : > >> Congratulations, Vladimir! >> Thanks for the good articles. >> >> Best, >>

Re: why do We use inner class for CallCopyingArgHandler within SqlShuttle rather static nested class as ArgHandlerImpl within SqlBasicVisitor.

> I find the CallCopyingArgHandler is not static, but the doc doesn't specify > the reason. > Does someone know why? If you try making it static you will see that it is unable to use the current shuttle to visit the children. CallCopyingArgHandler exists for a very short duration - visit of one

Re: [ANNOUNCE] New committer: Vladimir Ozerov

Welcome, Vladimir! > On Jun 24, 2021, at 6:00 PM, Albert wrote: > > Congrats. > just found the blog: https://www.querifylabs.com/author/vladimir-ozerov > > On Thu, Jun 24, 2021 at 2:27 PM Alessandro Solimando < > alessandro.solima...@gmail.com> wrote: > >> Congratulations Vladimir, well

Re: Error encountered during build on ppc64le architecture

It looks as if the Redis adapter test is trying to get an unavailable port. See whether the build succeeds if the Redis adapter test is skipped: ./gradlew clean test -x :redis:test If that passes, it indicates that Calcite is sound. (The Redis adapter is probably sound, too, and its test would

Re: geometry type support problem

It’s possible that the problem is with the JDBC adapter. Calcite would need to connect to PostGIS via its JDBC driver, read the column types, and deduce that the column is of GEOMETRY type. JDBC does not have a type-id for GEOMETRY, so this process would be a little ad hoc. (Probably using

Re: Equals method of AggregateCall

Not a bug. The type is derived from the operator plus argument types, so it is impossible for two AggregateCalls to be the same except for type. There is no perfect “equals”. The current one seems to serve our needs. If you have different needs maybe you need a different “equals” (or use a

Re: should calcite tolerate some typo mistakes?

It would have to be a mode that people opt into, but it might be useful. Especially for interactive use. I think you should write a Jira case with a specification and examples. Note that we already detect when people use the right identifier with the wrong case, and alert them in the error

[jira] [Created] (CALCITE-4649) Add AggregateExpandGroupingSetsRule, a planner rule that removes GROUPING SETS

Julian Hyde created CALCITE-4649: Summary: Add AggregateExpandGroupingSetsRule, a planner rule that removes GROUPING SETS Key: CALCITE-4649 URL: https://issues.apache.org/jira/browse/CALCITE-4649

Re: Problem with Spool (de-)serialization

son(java.lang.Object) > doesn’t know how to handle enum > > @Override public RelWriter explainTerms(RelWriter pw) { > return super.explainTerms(pw) > .item("readType", readType) > .item("writeType", writeType); > } > > Does it m

Re: Optimizer (Hep) NOT scanning RelNodes of Subqqueries

I presume we’re talking about scalar sub-queries (e.g. sub-query in SELECT) and sub-queries with IN and EXISTS, as opposed to sub-queries in the FROM clause. The former are represented using RexSubQuery because the queries appear in scalar expressions. There are rules to expand RexSubQuery

Re: Problem with Spool (de-)serialization

Including class names in serialized JSON makes me nervous. It is a common attack surface. Could we, say, include the name of the enum (without package name) and map it to a list of supported Enums? > On Jun 8, 2021, at 9:20 AM, Konstantin Orlov wrote: > > Hi, folks! > > We have a problem

Re: [ANNOUNCE] Apache Calcite 1.27.0 released

Thank you, Stamatis! And the 50 other people who contributed to this release. On Fri, Jun 4, 2021 at 3:50 PM Haisheng Yuan wrote: > > Thank you Stamatis and all Calciters involved for leading the effort. > > Haisheng Yuan > > On 2021/06/04 22:16:21, Stamatis Zampetakis wrote: > > The Apache

Re: [DISCUSS] Release Managers

Yes, I am release manager for 1.28. I’ll aim to release first week of August. Somewhat related to the call for release managers: we need active committers. (Stamatis, can you run your stats on PRs and active committers?) On May 21, I noted that PR backlog is building up, and appealed for 5

Re: Deduplicate correlate variables question.

The PR needs to fix a bug or implement a feature. So, first you should log a JIRA case describing what doesn’t work. Write tests for what doesn’t work that you want to make work. (Or maybe you can refactor/generalize existing tests.) Then submit a PR, and we will review that PR on the basis of

Re: RelFieldTrimmer on union distinct

ou Julian. > > I am able to reproduce your findings. > > I am curious if the results highlight a bug in Calcite where we should expect > 4 to be returned or is this a query that Calcite should not support? > > Sean > >> On Jun 2, 2021, at 11:37 AM, Julian Hyde wrote

Re: Minified javascript in source releases

+0 to remove them entirely, if that is possible. -1 to keep in git but remove from source releases. We are already in compliance with Apache policy, best I can tell. On Wed, Jun 2, 2021 at 12:08 PM Haisheng Yuan wrote: > > +1 for removing them entirely. > > Thanks, > Haisheng Yuan > > On

Re: Deduplicate correlate variables question.

Master is a moving target. Apparently you are using a version of the code from sometime in March. These links work better: [1] https://github.com/apache/calcite/blob/796675c9b33e0461bc45a72780162d474a4b098b/core/src/main/java/org/apache/calcite/sql2rel/SqlToRelConverter.java#L2881 [2]

Re: RelFieldTrimmer on union distinct

Here’s a query that would give the wrong answer if you trim: select count(*) from ( select deptno from scott.emp union select deptno from scott.dept); returns 4. Note that ‘deptno’ is not used. But when I trim it away, select count(*) from ( select 'a' from scott.emp

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

FYI, I have just discovered https://issues.apache.org/jira/browse/CALCITE-4629 <https://issues.apache.org/jira/browse/CALCITE-4629> in 1.27 RC 0. I don’t have a repro case. I don’t think it is a show-stopper so my vote remains +1. > On Jun 1, 2021, at 2:59 PM, Julian Hyde wrote

[jira] [Created] (CALCITE-4629) RexNormalize.hashCode() throws NullPointerException

Julian Hyde created CALCITE-4629: Summary: RexNormalize.hashCode() throws NullPointerException Key: CALCITE-4629 URL: https://issues.apache.org/jira/browse/CALCITE-4629 Project: Calcite

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

+1 Downloaded, checked hashes and signature, compared tar.gz contents to git commit 60f07118f3. Confirmed that gradle-wrapper.jar is missing from tar.gz. Using instructions in site/_docs/howto.md, downloaded and installed gradle-6.8.3 from https://gradle.org/releases/

[jira] [Created] (CALCITE-4628) If SqlImplementor fails, include the RelNode in the exception

Julian Hyde created CALCITE-4628: Summary: If SqlImplementor fails, include the RelNode in the exception Key: CALCITE-4628 URL: https://issues.apache.org/jira/browse/CALCITE-4628 Project: Calcite

Re: Calcite Engine Support for Oracle SQL89 Outer Join Syntax

Calcite does not support Oracle’s outer join syntax (“(+)”) or, for that matter, SQL Server’s syntax (“(*)”). Please log a JIRA case, asking for both to be added to the Babel parser. (I don’t want to add it to the Core parser, because it will cause ambiguities.) I don’t know of a workaround.

Re: Question: Hints & Rules

My fear, when we introduced hints, was that there would be many cases where people would hope that rules propagate hints and the rules do not; and that in some cases, the expected behavior isn't even clear. Maybe this can be addressed by the power of open source: people find an issue, submit a

Re: [DISCUSS] Towards Calcite 1.27.0

that you need my help. I will check those soon. > > > -Rui > > On Mon, May 24, 2021 at 11:06 AM Julian Hyde wrote: > >> We still need 5 committers to review 5 PRs each. Please reply to this >> email to volunteer. >> >> On Fri, May 21, 2021 at 3:41

Re: [DISCUSS] Towards Calcite 1.27.0

y, if people agree on > this. > Alternatively, I will have a bit more time around 17 to 20 of June. > > I will try to get 2-3 PRs in before starting the RC. > > Best, > Stamatis > > > On Fri, May 21, 2021 at 9:15 PM Julian Hyde wrote: > > > Now Avatica 1.18 h

Re: [RESULT][VOTE] Release apache-calcite-avatica-1.18.0 (release candidate 1)

y much forbids releasing minified files as a part of the source > release. > > Vladimir > > > вт, 18 мая 2021 г. в 14:14, Francis Chuang : > > > Thanks to everyone who has tested the release candidate and given their > > comments and votes. > > > >

Re: [DISCUSS] Towards Calcite 1.27.0

avatica/pull/138 > > On Sun, Feb 28, 2021 at 2:22 AM Julian Hyde wrote: > > > Vladimir, > > > > Thanks for finding this bug. Please log it. > > > > I don't intend to fix any more bugs in this area before 1.27. It has > > been a huge effort on my part,

Re: Enumerable rules lost hint info

cal operators. But I am not sure whether there are downstream >> projects that are using hints for physical resource. >> >> On 2021/05/19 17:05:44, Julian Hyde wrote: >>> Sure, there’s a slot to hold the hints. But is there a benefit to keeping >> them in the

Re: AggregateUnionTransposeRule fails when some inputs have unique grouping key

Can you add your proposed fix to the bug, and we can discuss there. > On May 21, 2021, at 2:33 AM, Vladimir Ozerov wrote: > > Hi, > > I created two issues for two distinct bugs in AggregateUnionTransposeRule: > > 1. https://issues.apache.org/jira/browse/CALCITE-4616 - the problem with > a

Re: Issue with DDL Parsing - Postgres

The SQL string you posted does not contain the word “PRIMARY”, so the error message is surprising. That said, Calcite’s dialect is different from PostgreSQL, and we do not promise to be able to parse every PostgreSQL query. You might have a better chance with Babel parser, which is more

Re: Enumerable rules lost hint info

return project_(nodes, fieldNames, ImmutableList.of(), force); > } > > > > Regards! > > Aron Tao > > > Julian Hyde 于2021年5月19日周三 上午12:30写道： > >> Do we really need hints in physical operators? When hints were introduced, >> was that part of the p

Re: AggregateUnionTransposeRule fails when some inputs have unique grouping key

You have definitely found a bug. One solution is to remove some of the rule’s responsibilities - delegating to another rule that presumably doesn’t have the bug. That would be a breaking change. Another solution is to fix the rule. Please log a jira case, and let’s discuss further there.

Re: Enumerable rules lost hint info

Do we really need hints in physical operators? When hints were introduced, was that part of the plan? Julian > On May 17, 2021, at 11:50 PM, JiaTao Tao wrote: > > Hi > Recently, I'm integrating Calcite's hint into our system, and I've found > the Enumerable rules just throw the hint

<    4   5   6   7   8   9   10   11   12   13   >