Re: [ANNOUNCE] New Calcite PMC chair: Benchao Li

2023-12-21 Thread Enrico Olivelli
Congratulations ! Enrico Il giorno gio 21 dic 2023 alle ore 15:07 Tanner Clary ha scritto: > > Congrats, Benchao :) > > -Tanner > > On Thu, Dec 21, 2023 at 2:33 AM Alessandro Solimando < > alessandro.solima...@gmail.com> wrote: > > > Congratulations Benchao, and thanks again to Stamatis for his

Re: [VOTE] Release Apache Calcite 1.31.0 (release candidate 3)

2022-07-29 Thread Enrico Olivelli
+1 (non binding) All tests of HerdDB pass without any code changes CI results on this PR: https://github.com/diennea/herddb/pull/789 Thanks for driving the release Enrico Il giorno ven 29 lug 2022 alle ore 14:07 Andrei Sereda ha scritto: > > Hi all, > > I have created a build for Apache

Re: [VOTE] Release Apache Calcite 1.30.0 (release candidate 3)

2022-03-17 Thread Enrico Olivelli
+1 (non binding) Run HerdDB tests (https://github.com/diennea/herddb/pull/782) and a few applications, no issues. Calcite works like a charm, still with this RC (as expected) Enrico Il giorno mer 16 mar 2022 alle ore 16:49 Alessandro Solimando ha scritto: > > Hello everyone, > thanks a lot

Re: [VOTE] Release Apache Calcite 1.30.0 (release candidate 2)

2022-03-14 Thread Enrico Olivelli
+1 non binding HerdDB works like a charm without any changes https://github.com/diennea/herddb/pull/782 Thanks for running the release Enrico Il Lun 14 Mar 2022, 12:02 Fan Liya ha scritto: > Hi Ruben, > > Thanks a lot for your vote. > > Hi all, > > Since part of the voting period is during

Re: [VOTE] Release Apache Calcite 1.30.0 (release candidate 1)

2022-03-07 Thread Enrico Olivelli
+1 (non binding) Run all tests of HerdDB, all tests are passing without any code change. (https://github.com/diennea/herddb/pull/779) I would like to note that previous tests of HerdDB did not pass with 1.29.0 (and we were stuck to 1.28.0). With 1.29.0 tests on Github actions hang during some

Re: [ANNOUNCE] New Calcite PMC chair: Ruben Q L

2022-01-22 Thread Enrico Olivelli
Congrats! Enrico Il Sab 22 Gen 2022, 03:03 xiong duan ha scritto: > Congratulations to Ruben and thanks to Haisheng! > > Danny Chan 于2022年1月21日周五 12:19写道: > > > Congratulations, Ruben, and good luck! > > > > Haisheng, Thank you for serving as Chair. > > > > Yanjing Wang 于2022年1月21日

Re: [ANNOUNCE] New committer: Alessandro Solimando

2021-12-18 Thread Enrico Olivelli
Congrats! Enrico Il Sab 18 Dic 2021, 16:00 Alessandro Solimando < alessandro.solima...@gmail.com> ha scritto: > Hello everyone, > it's an honour and privilege to be part of this great community, I have > really learned a lot over the years by following discussions and > contributing, I am

Re: [ANNOUNCE] New Calcite PMC chair: Haisheng Yuan

2020-12-17 Thread Enrico Olivelli
Congrats! And thank you Stamatis for your efforts as chair in the past year Enrico Il Gio 17 Dic 2020, 14:49 Stamatis Zampetakis ha scritto: > Calcite community members, > > I am pleased to announce that we have a new PMC chair and VP as per our > tradition of rotating the chair once a year.

Re: Decouple core from linq4j and Avatica

2020-11-24 Thread Enrico Olivelli
Il Mer 25 Nov 2020, 05:57 Haisheng Yuan ha scritto: > > I would like to propose to decouple the "core" module from "ling4j" and > Avatica. > I like the idea. > > Moving Enumerable out of core may be time consuming and disruptive, > because many core tests are using Enumerable to verify plan

Re: Search/Sarg: untested feature merged to the default branch

2020-11-16 Thread Enrico Olivelli
Stamatis, Il Lun 16 Nov 2020, 10:20 Stamatis Zampetakis ha scritto: > Hello, > > I don't want the current situation to be disheartening for anybody, > especially those who spend significant time on these code changes (Julian, > Vladimir). > Our common goal is to release 1.27.0 in the best

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

2020-10-06 Thread Enrico Olivelli
nvironment: > > - java version 1.8.0_151 > > - MacOS Mojave 10.14.6 > > > > I also find the new introduced ersi library when i do upgrade for Flink. > I > > solves the problem by adding a dependency for it. It is awesome if we can > > avoid it. Bu

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

2020-10-05 Thread Enrico Olivelli
[1] https://issues.apache.org/jira/browse/CALCITE-1861 > [2] > > https://github.com/apache/calcite/commit/eab043f4ef43112c16a9f6708e6c53a15b1cfbe0 > > > On Mon, Oct 5, 2020 at 3:17 PM Enrico Olivelli > wrote: > > > Ruben, > > I am testing the RC, I found that no

Re: ApacheCon 2020 talks relevant to Apache Calcite

2020-09-28 Thread Enrico Olivelli
Stamatis, I am going to talk about HerdDB inside BigData2 track. https://www.apachecon.com/acah2020/tracks/bigdata-2.html "After NoSQL discover CloudSQL databases Romain Manni-Bucau, Enrico Olivelli" We are going to cite Calcite somehow in a couple of slides as it is the core of

Disabling JaninoRelMetadataProvider

2020-09-18 Thread Enrico Olivelli
Hi, I am seeing that JaninoRelMetadataProvider is quite expensive, at least for the "boostrap" phase of the system. It is a cool piece of software and it is working well, but in some cases probably it could be quite overkill, for instance in test cases of applications that mostly run only one

Re: Combining HepPLanner and VolcanoPlanner

2020-09-17 Thread Enrico Olivelli
that are applied. > I will send a demo when I have cycles. Thanks for your response. Enrico > > Best regards, > Ruben > > > Le mer. 16 sept. 2020 à 17:24, Enrico Olivelli a > écrit : > > > Ruben, > > thank you very much, using your snippet I g

Re: Combining HepPLanner and VolcanoPlanner

2020-09-16 Thread Enrico Olivelli
ult = (EnumerableRel) optPhases.run( > query.getCluster().getPlanner(), // this is a VolcanoPlanner > query, > desiredTraitSet, > Collections.emptyList(), > Collections.emptyList()); > return result; > } > > > I hope it helps. > > Best regards, > Ruben > >

Combining HepPLanner and VolcanoPlanner

2020-09-15 Thread Enrico Olivelli
Hi, I am trying to create a two stage planner using HepPlanner and then VolcanoPlanner Which is the correct sequence of steps to pass from SQL to Enumerable ? My goal is to use Hep for very simple queries like simple INSERTs, SELECT * FROM TABLE, SELECT * FROM TABLE WHERE pk=? Volcano is

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

2020-08-12 Thread Enrico Olivelli
Congrats Ruben! Enrico Il Mer 12 Ago 2020, 18:05 Michael Mior ha scritto: > Congrats Reuben! > > -- > Michael Mior > mm...@apache.org > > Le mer. 12 août 2020 à 09:32, Ruben Q L a écrit : > > > > Thanks everyone! > > It is an honor to join the Calcite PMC. > > > > Best regards, > > Ruben > >

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

2020-08-09 Thread Enrico Olivelli
+1 (non binding) run tests locally on Fedora + JDK14 run tests of HerdDB just by switching from 1.24 without any change Enrico Il giorno dom 9 ago 2020 alle ore 05:22 Andrei Sereda ha scritto: > Hi all, > > I have created a build for Apache Calcite 1.25.0, release > candidate 0. > > Thanks to

Re: Avatica and HepPlanner

2020-08-04 Thread Enrico Olivelli
Is there some documentation or best practice doc about how using both of the two planners ? I guess you have to pass a set of rules to the HepPlanner in order to perform some simpler steps and then pass other rules to VolcanoPlanner in order to create the physical plan. What is the RelNode to

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

2020-07-21 Thread Enrico Olivelli
+1 (non binding) - verified hashes and checksums - built from sources and run tests (JDK14 on Linux) - run tests of HerdDB and some client application I only had to fix a deprecation warning, changing from ReduceExpressionsRule.FILTER_INSTANCE to CoreRules.FILTER_REDUCE_EXPRESSIONS, see [1] below

Re: [DISCUSS] New RexNode: RexListCmp

2020-07-19 Thread Enrico Olivelli
Il Lun 20 Lug 2020, 03:00 Haisheng Yuan ha scritto: > Hi all, > > This is a rough idea, I'd like to see how the community think about it. > > RexListCmp extends RexNode / RexCall { > public final SqlOperator op; > public final RexNode left; > public final ImmutableList list; > public

Re: [DISCUSS] Binary files for testing InnoDB adapter

2020-07-16 Thread Enrico Olivelli
Il Gio 16 Lug 2020, 21:28 Julian Hyde ha scritto: > Michael, > > I think that sentence covers the situation where, say, we ship a > .class file without shipping the .java it was generated from. > > In our case, we are shipping the equivalent of the .class file and the > .java file (namely

Re: [DISCUSS] Binary files for testing InnoDB adapter

2020-07-15 Thread Enrico Olivelli
IMHO If you need those files for tests and you don't have a way to generate them it is allowed to keep them. You can add some readme file that explain their nature. You can also add a check sum file. Just my 2 cents Enrico Il Gio 16 Lug 2020, 05:40 Francis Chuang ha scritto: > I am +1 for

Re: [DISCUSS] Make RexNode serializable

2020-07-07 Thread Enrico Olivelli
Rui Il Mar 7 Lug 2020, 20:30 Rui Wang ha scritto: > Hi Community, > > In Apache Beam we are facing a use case where we need to keep RexNode in > our distributed primitives. Because of the nature of distributed computing, > Beam requires the usage of those primitives be serializable (thus those

Re: Deploy Calcite to local Maven Repository

2020-07-03 Thread Enrico Olivelli
t; > > > Best regards > xzh > > > ------原始邮件-- > 发件人:"Enrico Olivelli" 发送时间:2020年7月3日(星期五) 晚上10:15 > 收件人:"dev" > 主题:Deploy Calcite to local Maven Repository > > > > Hi, > I am trying to build Calcite and put j

Deploy Calcite to local Maven Repository

2020-07-03 Thread Enrico Olivelli
Hi, I am trying to build Calcite and put jars into local Maven repository Usually this is easy with the Maven plugin https://docs.gradle.org/current/userguide/maven_plugin.html ./gradlew install -x test I am trying to add the 'maven' plugin to Gradle configuration but without effect Is there

Re: Why migrate from Maven to Gradle

2020-06-16 Thread Enrico Olivelli
Il Mar 16 Giu 2020, 05:31 Haisheng Yuan ha scritto: > Hi Zoltan, > > > For example I use NetBeans, and things just work with maven. > Hi If you use NetBeans 11.3+ you can open Calcite again. Better 12.0 Enrico Have you tried intellij? It works fine with Gradle. And it is free. > > > Gradle

Re: [ANNOUNCE] Apache Calcite 1.23.0 released

2020-05-27 Thread Enrico Olivelli
Great Enrico Il Gio 28 Mag 2020, 05:12 Chunwei Lei ha scritto: > Nice job, Haisheng! > > > Best, > Chunwei > > > On Thu, May 28, 2020 at 10:42 AM XING JIN wrote: > > > Thanks a lot for driving this, Haisheng! > > > > Best, > > Jin > > > > Stamatis Zampetakis 于2020年5月28日周四 上午7:14写道: > > > >

Re: [VOTE] Release apache-calcite-1.23.0 (release candidate 1)

2020-05-26 Thread Enrico Olivelli
Vladimir o Haisheng could you please open a ticket to INFRA ? I can do it myself, with your permission (I am not in Calcite PMC/committers group) Otherwise it is not possible to use Calcite 1.23.0 from downstream projects Enrico Il giorno mar 26 mag 2020 alle ore 10:34 Vladimir Sitnikov <

Re: [VOTE] Release apache-calcite-1.23.0 (release candidate 1)

2020-05-26 Thread Enrico Olivelli
Haisheng I still can't see Calcite 1.23.0 on Maven Central https://search.maven.org/search?q=a:calcite-core did the release procedure complete successfully? Enrico Il giorno dom 24 mag 2020 alle ore 14:35 JiaTao Tao ha scritto: > Vote: +1 (non-binding) > > CALCITE-3819

Re: [VOTE] Release apache-calcite-1.23.0 (release candidate 1)

2020-05-17 Thread Enrico Olivelli
+1 (non binding) Local tests passes on Linux (Fedora 31) + JDK14 Checksums and signatures looks good. All tests are passing on HerdDB. Thank you very much Haisheng ! Enrico Il giorno sab 16 mag 2020 alle ore 23:21 Anton Haidai < anton.hai...@gmail.com> ha scritto: > Hello, > > Local Calcite

Re: [DISCUSS] DDL parsing, and relationship between "server" and "babel" modules

2020-05-15 Thread Enrico Olivelli
Il Ven 15 Mag 2020, 22:26 Julian Hyde ha scritto: > Currently, there is no DDL in Calcite's "core" module (or its SQL > parser) and the SQL parser in the "server" module adds DDL extensions > for Calcite's object types. > > There is a PR [1][2] to add support for "CREATE TABLE" to Babel, and >

Re: Problems on HerdDB with 1.23 was [VOTE] Release apache-calcite-1.23.0 (release candidate 0)

2020-05-15 Thread Enrico Olivelli
applications Thank you ! Enrico Il giorno mer 13 mag 2020 alle ore 15:05 Enrico Olivelli < eolive...@gmail.com> ha scritto: > Tickets: > https://issues.apache.org/jira/browse/CALCITE-3997 > https://issues.apache.org/jira/browse/CALCITE-3998 > > I will try to create the repr

Re: Problems on HerdDB with 1.23 was [VOTE] Release apache-calcite-1.23.0 (release candidate 0)

2020-05-13 Thread Enrico Olivelli
; > the problem. I did that way last time and Stamatis was able to create the > > test in Calcite code > > > > Does this approach work for you? > That would also work. > > Thanks, > Haisheng > On 2020/05/13 12:31:26, Enrico Olivelli wrote: >

[jira] [Created] (CALCITE-3998) Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER

2020-05-13 Thread Enrico Olivelli (Jira)
Enrico Olivelli created CALCITE-3998: Summary: Bad datatype for sum(n), it should be BIGINT but it is sometimes INTEGER Key: CALCITE-3998 URL: https://issues.apache.org/jira/browse/CALCITE-3998

[jira] [Created] (CALCITE-3997) Problem with MERGE JOIN: java.lang.AssertionError: cannot merge join: left input is not sorted on left keys

2020-05-13 Thread Enrico Olivelli (Jira)
Enrico Olivelli created CALCITE-3997: Summary: Problem with MERGE JOIN: java.lang.AssertionError: cannot merge join: left input is not sorted on left keys Key: CALCITE-3997 URL: https://issues.apache.org/jira

Re: Problems on HerdDB with 1.23 was [VOTE] Release apache-calcite-1.23.0 (release candidate 0)

2020-05-13 Thread Enrico Olivelli
u. > > Thanks, > Haisheng Yuan > > On 2020/05/13 08:15:30, Enrico Olivelli wrote: > > Haisheng, > > > > > > > > > > Il Mar 12 Mag 2020, 16:38 Haisheng Yuan ha scritto: > > > > > Hi Enrico, > > > > > > Thanks for reporting

Re: Problems on HerdDB with 1.23 was [VOTE] Release apache-calcite-1.23.0 (release candidate 0)

2020-05-13 Thread Enrico Olivelli
perators, > intentionally? Can we safely stop matching physical operators in these > rules? (ProjectMerge can be an exception, some people use it on physical > operator for post processing). > Do you think that I can safely disable those rules? Enrico > Thanks, > Haisheng >

Problems on HerdDB with 1.23 was [VOTE] Release apache-calcite-1.23.0 (release candidate 0)

2020-05-12 Thread Enrico Olivelli
Haisheng, I am sorry, I have a couple of problems with HerdDB. 1) JOIN order unsorted columns in presence of a WHERE over other columns This is my case: CREATE TABLE tblspace1.table1 (k1 string primary key,n1 int,s1 string) CREATE TABLE tblspace1.table3 (k1 string primary key,n3 int,s3 string)

Re: [ANNOUNCE] New committer: Wang Yanlin

2020-04-28 Thread Enrico Olivelli
Congrats! Enrico Il Mer 29 Apr 2020, 04:51 Feng Zhu ha scritto: > Congrations! Yanlin! > > best, > Feng > > Chunwei Lei 于2020年4月29日周三 上午10:16写道: > > > Congrats, Yanlin! > > > > > > Best, > > Chunwei > > > > > > On Wed, Apr 29, 2020 at 10:07 AM Forward Xu > > wrote: > > > > > Congrats > > >

Re: [ANNOUNCE] New committer: Forward Xu

2020-04-28 Thread Enrico Olivelli
Congrats! Enrico Il Mer 29 Apr 2020, 04:52 Feng Zhu ha scritto: > Congrations! Forward! > > best, > Feng > > Chunwei Lei 于2020年4月29日周三 上午10:17写道: > > > Congrats, Forward! > > > > > > > > Best, > > Chunwei > > > > > > On Wed, Apr 29, 2020 at 6:46 AM Rui Wang wrote: > > > > > Congrats! > > >

Re: [ANNOUNCE] New committer: Jin Xing

2020-04-28 Thread Enrico Olivelli
Congratulations! Enrico Il Mer 29 Apr 2020, 04:51 Feng Zhu ha scritto: > Congrations! > > best, > Feng > > Chunwei Lei 于2020年4月29日周三 上午10:16写道: > > > Congrats, Jin! > > > > > > Best, > > Chunwei > > > > > > On Wed, Apr 29, 2020 at 10:07 AM Forward Xu > > wrote: > > > > > Congrats > > > > >

Re: [ANNOUNCE] New committer: Vineet Garg

2020-04-25 Thread Enrico Olivelli
Congratulations Vineet! Enrico Il Dom 26 Apr 2020, 07:18 XING JIN ha scritto: > Congrats, Vineet! > > Best, > Jin > > Fan Liya 于2020年4月26日周日 上午11:45写道: > > > Congratulations, Vineet! > > > > Best, > > Liya Fan > > > > On Sun, Apr 26, 2020 at 10:30 AM Aman Sinha wrote: > > > > >

Re: TableModify does not keep UPSERT keyword

2020-03-25 Thread Enrico Olivelli
(because Phoenix inherited > limitations on consistency from the underlying HBase engine) but we should > deprecate UPSERT and move to INSERT … ON CONFLICT instead. > > Julian > > [1] https://www.postgresql.org/docs/current/sql-insert.html > <https://www.postgresql.org/docs/curre

Re: TableModify does not keep UPSERT keyword

2020-03-18 Thread Enrico Olivelli
PSERT. PostgreSQL for example has a guaranteed insert or update > >> semantics whereas MERGE could end with constraint violation errors: > >> https://wiki.postgresql.org/wiki/UPSERT > >> > >> Maybe it's worth adding that to the relational model after all? > &

Re: TableModify does not keep UPSERT keyword

2020-03-17 Thread Enrico Olivelli
in the RelNode (EnumerableTableModify oŕ LogicalTableModify) I saw the JIRA where you introduced UPSERT for Phoenix I will check deeper, thanks Enrico > Julian > > > On Mar 16, 2020, at 1:22 AM, Enrico Olivelli > wrote: > > > > Il Lun 16 Mar 2020, 09:06 Stamatis Zamp

Re: TableModify does not keep UPSERT keyword

2020-03-16 Thread Enrico Olivelli
/calcite/blob/d234626227954eefffe49f42abec65c649ffe3a6/core/src/test/java/org/apache/calcite/test/SqlToRelConverterTest.java#L2395 > > On Sun, Mar 15, 2020 at 6:53 PM Enrico Olivelli > wrote: > > > Hi, > > I am trying to use UPSERT but it seems to me that in TableModify (or &

TableModify does not keep UPSERT keyword

2020-03-15 Thread Enrico Olivelli
Hi, I am trying to use UPSERT but it seems to me that in TableModify (or best LogicalTableModify or EnumerableTableModify) there is no way to distinguish an INSERT from an UPSERT. Am I missing something? Regards Enrico

Re: [DISCUSS] Code reviews

2020-03-14 Thread Enrico Olivelli
Hi, I see that Calcite is a core and mission critical component for many applications and libraries, in many core libraries they follow strictly Review-Than-Commit and this rule is very useful. There is no hurry in committing a fix or a new feature, we are a great opensource project, without time

Re: [Needs Help] How to sync the jar to mvn repository

2020-03-06 Thread Enrico Olivelli
It is automatic. Just wait. It is not important. Downstream projects are able to already use Calcite 1.22.0 Enrico Il giorno ven 6 mar 2020 alle ore 08:42 Danny Chan ha scritto: > > I release the staging repository yesterday and it appears here > >

Re: [ANNOUNCE] New committer: Feng Zhu

2020-03-04 Thread Enrico Olivelli
Welcome ! Enrico Il giorno mer 4 mar 2020 alle ore 10:42 Matt Wang ha scritto: > > Congrats Feng! > > > --- > Best, > Matt Wang > > > On 03/4/2020 11:30,Xin Wang wrote: > Congrats Feng! > > - Xin > > Kevin Risden 于2020年3月4日周三 上午2:32写道: > > Congrats Feng! > > Sounds like an interesting project.

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-03 Thread Enrico Olivelli
+1 (non binding) Run tests locally (on Mac + JDK13) Run tests of HerdDB and a bunch of know applications that are using HerdDB Thank you Danny Enrico Il giorno mar 3 mar 2020 alle ore 11:06 Feng Zhu ha scritto: > > Hi Danny, thanks for your continuous effort! > > +1 (non-binding) > > - Build

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-27 Thread Enrico Olivelli
an wrote: > > > > Gives a -1 when you are sure that it is a bug, or the voting would be very > > depressing, anyone can give a -1 for any reasons. > > > > Best, > > Danny Chan > > 在 2020年2月26日 +0800 PM3:04,Enrico Olivelli ,写道: > >> Danny, > >>

Re: Problems on RC with HerdDB: was: [VOTE] Release apache-calcite-1.22.0 (release candidate 0)

2020-02-27 Thread Enrico Olivelli
prefer, it is a simpler JUnit based test case Hope this helps Enrico Il giorno mar 25 feb 2020 alle ore 14:50 Enrico Olivelli ha scritto: > > Il giorno mar 25 feb 2020 alle ore 14:43 Vladimir Sitnikov > ha scritto: > > > > >Does any ring bell ? > > > > Is

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-26 Thread Enrico Olivelli
o you PMC to accept formally the release. Enrico > > Best, > Danny Chan > 在 2020年2月26日 +0800 PM3:04,Enrico Olivelli ,写道: > > Danny, > > I have created https://issues.apache.org/jira/browse/CALCITE-3826 > > for the problem about bind variables in UPDATE statements. > >

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-25 Thread Enrico Olivelli
such test in a few minutes. > > The release is running a bit late already, so hopefully this won't be a > complicated fix. Yes, but it is worth to assess the problem, or we will deliver huge problems to our clients Enrico > > Francis > > On 26/02/2020 6:03 pm, Enrico Oli

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-25 Thread Enrico Olivelli
Danny, I have created https://issues.apache.org/jira/browse/CALCITE-3826 for the problem about bind variables in UPDATE statements. I feel this it can be a serious regression that can lead to data corruption (wrong data type in DML statements). AFAICT There is no way to workaround the problem in

[jira] [Created] (CALCITE-3826) UPDATE assigns wrong type to bind variables

2020-02-25 Thread Enrico Olivelli (Jira)
Enrico Olivelli created CALCITE-3826: Summary: UPDATE assigns wrong type to bind variables Key: CALCITE-3826 URL: https://issues.apache.org/jira/browse/CALCITE-3826 Project: Calcite

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 1)

2020-02-25 Thread Enrico Olivelli
-1 (non binding) Good news: I am able to build and run tests locally Bad news: - I have found a regression in Bind Variable handling in "UPDATE" statements due to https://issues.apache.org/jira/browse/CALCITE-3672 see the separate email Thread "Problems on RC with HerdDB: was: [VOTE] Release

Re: Problems on RC with HerdDB: was: [VOTE] Release apache-calcite-1.22.0 (release candidate 0)

2020-02-25 Thread Enrico Olivelli
Il giorno mar 25 feb 2020 alle ore 14:43 Vladimir Sitnikov ha scritto: > > >Does any ring bell ? > > Is it related to [CALCITE-3672] Support implicit type coercion for insert > and update ? > https://issues.apache.org/jira/browse/CALCITE-3672 > https://github.com/apache/calcite/pull/1720

Re: Problems on RC with HerdDB: was: [VOTE] Release apache-calcite-1.22.0 (release candidate 0)

2020-02-25 Thread Enrico Olivelli
, skipping the PK. Does any ring bell ? Enrico Il giorno mar 25 feb 2020 alle ore 12:32 Enrico Olivelli ha scritto: > > Danny, > We have found all of our showstoppers: > - We were not handling JoinInfo#nonEquiConditions (maybe it has been > added recently) > -

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 1)

2020-02-25 Thread Enrico Olivelli
I am building the RC I found this warning in logs, it looks like a serious LICENSE problem Enrico > Task :release:license Dependencies of license category B are not allowed for SOURCE artifacts === OFL-1.1 *

Re: Problems on RC with HerdDB: was: [VOTE] Release apache-calcite-1.22.0 (release candidate 0)

2020-02-25 Thread Enrico Olivelli
, but our previous code expected a call to "reset". We are testing downstream applications Thank you Enrico Il giorno mar 25 feb 2020 alle ore 10:25 Enrico Olivelli ha scritto: > > The issue is indeed about JoinInfo#nonEquiConditions and non equi > joins in general. > > I w

Problems on RC with HerdDB: was: [VOTE] Release apache-calcite-1.22.0 (release candidate 0)

2020-02-25 Thread Enrico Olivelli
you can check there 2 commits: > > > 1. > https://github.com/apache/calcite/commit/820f6ab4965d79946e4144db8e33aeef98c3d2ff > 2. > https://github.com/apache/calcite/commit/10a5b8a89d319e6fed563e7e49518cfc960b93d6 > > Both seem to be a result fix though ~ > > Best, > Dan

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

2020-02-24 Thread Enrico Olivelli
an you give more > details ? > > [1] https://issues.apache.org/jira/browse/CALCITE-3769 > > Best, > Danny Chan > 在 2020年2月24日 +0800 PM9:55,Enrico Olivelli ,写道: > > Danny, > > We are testing HerdDB with 1.22.0rc0 tag and we are seeing problems with > Joins. > > >

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

2020-02-24 Thread Enrico Olivelli
Danny, We are testing HerdDB with 1.22.0rc0 tag and we are seeing problems with Joins. We were still on 1.19.0 and in December we created a test branch against current Calcite's master. Unfortunately during the past few weeks we stopped checking continuously that branch and we missed the commit

Re: [DISCUSS] Towards Calcite 1.22

2020-02-09 Thread Enrico Olivelli
Il Dom 9 Feb 2020, 08:41 Stamatis Zampetakis ha scritto: > Thanks for fixing the build Vladimir! > > I like the idea of testing against other projects on a weekly basis. It > will certainly help detect regressions early on. It might be a bit hard to > maintain since there could be failures quite

Re: [DISCUSS] Towards Calcite 1.22

2020-02-08 Thread Enrico Olivelli
sy (things should be better in February). > > >> > > > >> > Another option is to swap with somebody doing next (1.2[345]) release. > > >> > > > >> > Please let me know what you think and apologies for the inconvenience. > > >> &g

Re: [DISCUSS] CALCITE-2450 reorder predicates to a canonical form

2019-12-29 Thread Enrico Olivelli
Il dom 29 dic 2019, 20:09 Vladimir Sitnikov ha scritto: > Hi, > > We have a 1-year old issue with an idea to sort RexNode operands so they > are consistent. > > For instance, "x=5" and "5=x" have the same semantics, so it would make > sense to stick to a single implementation. > A discussion can

Re: Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

2019-12-18 Thread Enrico Olivelli
Congratulations Stamatis! Enrico Il gio 19 dic 2019, 04:40 Rui Wang ha scritto: > Congratulations and Thanks Stamatis! > > > > -Rui > > On Wed, Dec 18, 2019 at 6:52 PM XING JIN wrote: > > > Congratulations Stamatis! > > > > -Jin > > > > Chunwei Lei 于2019年12月19日周四 上午10:33写道: > > > > >

Re: Release managers

2019-12-06 Thread Enrico Olivelli
Hi, AFAIK in all of the apache projects I am contributing to as committer every committer can sign the artifacts and be release manager, the PMC has just to VOTE or do some Apache reporter stuff or other bureaucratic stuff. Is there any particular rule here in Calcite project? If it is not the

Re: [DISCUSS] Towards Calcite 1.22

2019-12-02 Thread Enrico Olivelli
Andrei Il mar 3 dic 2019, 08:21 Rui Wang ha scritto: > Thank you for this notification. > > Please try to make CALCITE-3272[1] into 1.22 (change the fix version to > 1.22 already). > > > [1]: https://github.com/apache/calcite/pull/1587 > > -Rui > > On Mon, Dec 2, 2019 at 6:35 PM Chunwei Lei

Re: [ANNOUNCE] Danny Chan joins Calcite PMC

2019-11-04 Thread Enrico Olivelli
Congrat Danny ! Enrico Il giorno dom 3 nov 2019 alle ore 20:29 Julian Feinauer < j.feina...@pragmaticminds.de> ha scritto: > Congratulations Danny! Very well deserved! > > Julian > > Am 01.11.19, 20:49 schrieb "Muhammad Gelbana" : > > Congratulations! > > Thanks, > Gelbana > > >

Re: ApacheCon Europe 2019 talks which are relevant to Apache Calcite

2019-10-23 Thread Enrico Olivelli
Stamatis and Julian I am at the conference as well Enrico Il mer 23 ott 2019, 09:29 Julian Feinauer ha scritto: > That would be really nice! > Just ping me I will be there all days! > > Julian > > From: Stamatis Zampetakis > Sent: Wednesday, October 23, 2019

Re: Different performance of the same code in two laptops

2019-10-15 Thread Enrico Olivelli
Can you share the differences between the two machines? RAM, CPU, OS As far as I know internal java ergonomics make code run very differently depending on available resources Enrico Il mar 15 ott 2019, 15:40 Stamatis Zampetakis ha scritto: > Hi Makis, > > Use a profiler (e.g., VisualVM)

Hotfix release for CALCITE-3347 ?

2019-10-08 Thread Enrico Olivelli
Hello Calciters, in HerdDB community we are have recently upgraded Calcite to 1.21.0 but we are getting feedback from downstream project about a bad problem with subqueries with bind variables. The issue is tracked as CALCITE-3347 https://issues.apache.org/jira/browse/CALCITE-3347 This is the

Re: Trivial query simplification

2019-09-25 Thread Enrico Olivelli
t; > On Wed, Sep 25, 2019 at 5:31 PM Enrico Olivelli > wrote: > > > Thank you for your feedback. > > > > Actually ReduceExpressionsRule.FILTER_INSTANCE fixes the problem. > > > > RelOptPlanner optPlanner = cluster.getPlanner(); > > optPlanner.addRul

Re: Trivial query simplification

2019-09-25 Thread Enrico Olivelli
rfect order for > predicates, so we might come back in 6 months and want to change the order > again. Better to sort them during simplification but then spit them out in > the original order. > > Julian > > > > > On Sep 24, 2019, at 8:34 AM, Enrico Olivelli > wrote: >

Re: Trivial query simplification

2019-09-24 Thread Enrico Olivelli
> > Moreover, is it right for the below simplification (do you mean v is not > > null)? > > (v=1 and v is null) -> v=1 > > (do you mean v is not null?) > > > > Best regards > > > > Enrico Olivelli 于2019年9月24日周二 下午5:41写道: > > > > > Hi, >

Re: Trivial query simplification

2019-09-24 Thread Enrico Olivelli
null?) > Yes, sorry Enrico > > Best regards > > Enrico Olivelli 于2019年9月24日周二 下午5:41写道: > > > Hi, > > I have a query like > > SELECT * FROM MYTABLE WHERE v = 1 and v is null > > > > I am expecting Calcite to simplify it to > > SELECT * FROM

Trivial query simplification

2019-09-24 Thread Enrico Olivelli
Hi, I have a query like SELECT * FROM MYTABLE WHERE v = 1 and v is null I am expecting Calcite to simplify it to SELECT * FROM MYTABLE WHERE v = 1 but this does not happen. Is any rule I should enable in order to make it happen ? This is the configuration of my Volcano planner: final

Problems with Subqueries and simple aggregations on Calcite 1.20

2019-07-31 Thread Enrico Olivelli
Hello, We are upgrading HerdDB from Calcite 1.19 to 1.20 but we are falling into serious issues regarding subqueries and aggregations on very simple queries. I am really sorry I did not have time to test 1.20 before the release this time. I will create JIRAs but maybe someone has already an idea

Re: [DISCUSS] Towards Calcite 1.21.0

2019-07-21 Thread Enrico Olivelli
Stamatis, We are trying to upgrade HerdDB to 1.20 but we are stuck into a little problem with simple aggregations [1] I will try to give feedback as it is possible, if there is a problem in Calcite I will be happy to try to report it before 1.21. I hope it is only a problem on HerdDB Cheers

Re: [ANNOUNCE] New committer: Danny Chan

2019-05-14 Thread Enrico Olivelli
Congratulations! Enrico Il mer 15 mag 2019, 04:11 Rong Rong ha scritto: > Congratulations Danny! > > On Tue, May 14, 2019 at 2:45 PM Stamatis Zampetakis > wrote: > > > Congrats Danny, and thanks a lot for all the effort you are putting in > > helping others and improving Calcite. > > > >

Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC

2019-04-27 Thread Enrico Olivelli
Congrats ! Enrico Il giorno dom 28 apr 2019 alle ore 00:08 Vineet Garg ha scritto: > > Congratulations Stamatis! > > On Fri, Apr 26, 2019 at 7:44 PM Francis Chuang > wrote: > > > I'm pleased to announce that Stamatis has accepted an invitation to > > join the Calcite PMC. Stamatis has been a

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

2019-03-21 Thread Enrico Olivelli
great work Kevin +1 (non binding) checked signatures/checksum built from source on JDK11 (AdoptOpenJDK 11.0.2) on Linux, all tests passed. all tests of downstream project HerdDB passed, 100% compatible, upgrading from 1.17.0 Regards Enrico Il giorno mer 20 mar 2019 alle ore 22:58 Francis

Re: new RuntimeException(Throwable) vs SneakyThrows

2019-02-13 Thread Enrico Olivelli
Vladimir, Il giorno mer 13 feb 2019 alle ore 21:49 Vladimir Sitnikov ha scritto: > > Hi, > > I've recently discovered that new RuntimeException(Throwable) results in a > duplicated error messages. > In fact Throwable#(Throwable) just calls cause.getMessage() and uses > it as its own message. > >

Re: Calcite Plan Caching

2019-02-07 Thread Enrico Olivelli
Paul, Il giorno mer 6 feb 2019, 23:02 Paul Trepagnier ha scritto: > I am using calcite right now to test some data federation scenarios. I > have several collections of Java objects that I am querying right now. It > works beautifully, but it seems like Calcite does a ton of work with each >

Re: [ANNOUNCE] New committer: Stamatis Zampetakis

2019-01-30 Thread Enrico Olivelli
Kudos ! Enrico Il giorno mer 30 gen 2019, 19:27 Julian Hyde ha scritto: > Welcome, Stamatis! In addition to your code contributions, I have been > appreciating your wise & moderating contributions to technical discussions, > and answers to people’s questions on the dev list. > > Julian > > > >

Re: [ANNOUNCE] New committer: Zoltan Haindrich

2019-01-30 Thread Enrico Olivelli
Congrats! Enrico Il giorno mer 30 gen 2019, 19:25 Julian Hyde ha scritto: > Welcome, Zoltan! You’ve already contributed plenty of great work, and I > look forward to further contributions! > > Julian > > > > On Jan 30, 2019, at 10:05 AM, Jesus Camacho Rodriguez < > jcama...@apache.org> wrote:

Re: [ANNOUNCE] New Calcite PMC chair: Francis Chuang

2018-12-20 Thread Enrico Olivelli
t; >> resigned, and Francis was duly elected by the PMC and approved > unanimously > >> by the Board. > >> > >> Please join me in congratulating Francis! > >> > >> -Michael > >> > >> PS - This should not be indicative of a

Re: [VOTE] Release apache-calcite-1.18.0 (release candidate 2)

2018-12-19 Thread Enrico Olivelli
+1 (non binding) built from source artifacts, run tests, all passed on Linux fedora 28 run tests of HerdDB, all is ok checked signatures and checksums, all is ok great work Enrico Il giorno mer 19 dic 2018 alle ore 13:32 Stamatis Zampetakis ha scritto: > > +1 (non binding) > > System: Ubuntu

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

2018-12-07 Thread Enrico Olivelli
+1 (non binding) - checked signature and checksum - built from source, all tests pass on OracleJDK8 on Linux - all tests from downstream project (HerdDB) are passing Still great work ! Thank you Julian for driving the release Enrico Il giorno ven 7 dic 2018 alle ore 02:44 Francis Chuang ha

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

2018-12-04 Thread Enrico Olivelli
+1 (non binding) - compiled from the staged sources and run tests on linux, all passed - run tests of downstream project (HerdDB) - checked signatures and checksums great work ! Enrico Il giorno mar 4 dic 2018 alle ore 10:00 Julian Hyde ha scritto: > > Hi all, > > I have created a build for

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-19 Thread Enrico Olivelli
Il giorno lun 19 nov 2018 alle ore 22:41 Enrico Olivelli ha scritto: > > We can run the script in Travis, so that we will refuse any commit > message not compliant with the "specs" > In Travis you can run a shell script with uses directly the 'git' command What about this

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-19 Thread Enrico Olivelli
>>> > >>> On 20/11/2018 8:00 am, Michael Mior wrote: > >>>> Sorry, that link should have been > >>>> https://github.com/phillipuniverse/githook-maven-plugin. Anyway, I don't > >>>> have experience with any particular plugin,

Re: calcite-avatica git commit: [CALCITE-2412] Add appveyor.yml to have tests on Windows against jdk1.8, jdk9, jdk10 Add Appveyor badge Add -DskipDockerCheck because of CALCITE-2385 and to make it syn

2018-11-19 Thread Enrico Olivelli
; > > API, so ResultSetEnumerable.setDynamicParam could be removed > altogether. > > > > I agree. The commit didn’t seem quite perfect to me either. However, it > > seemed to be progress. Log an Avatica JIRA if you have ideas for how to > > improve it further. Since it will be in Avatica it will take a while to > > bubble through the release cycle. > > > > Julian > > > > > -- -- Enrico Olivelli

[jira] [Created] (CALCITE-2662) Planner: allow parsing directly a stream instead of a java.lang.String

2018-11-07 Thread Enrico Olivelli (JIRA)
Enrico Olivelli created CALCITE-2662: Summary: Planner: allow parsing directly a stream instead of a java.lang.String Key: CALCITE-2662 URL: https://issues.apache.org/jira/browse/CALCITE-2662

Re: Help with EnumerableMergeJoinRule which is losing a RelCollection trait

2018-09-29 Thread Enrico Olivelli
y much ! Enrico > > > Στις Παρ, 28 Σεπ 2018 στις 11:39 μ.μ., ο/η Enrico Olivelli < > eolive...@gmail.com> έγραψε: > > > Il ven 28 set 2018, 23:00 Stamatis Zampetakis ha > > scritto: > > > > > Hi Enrico, > > > > > > I

  1   2   >