Re: [ANNOUNCE] New committers: Zhiwei Peng

2019-04-26 Thread Chunwei Lei
Congratulations, Zhiwei! Best, Chunwei On Sat, Apr 27, 2019 at 12:13 PM Yuzhao Chen wrote: > > Congratulations, Zhiwei! > > Best, > Danny Chan > 在 2019年4月27日 +0800 AM10:37,Francis Chuang ,写道: > > Apache Calcite's Project Management Committee (PMC) has invited Zhiwei > > Peng to become a

Re: [ANNOUNCE] New committers: Zhiwei Peng

2019-04-26 Thread Yuzhao Chen
Congratulations, Zhiwei! Best, Danny Chan 在 2019年4月27日 +0800 AM10:37,Francis Chuang ,写道: > Apache Calcite's Project Management Committee (PMC) has invited Zhiwei > Peng to become a committer, and we are pleased to announce that he has > accepted. > > Zhiwei has been contributing to Calcite for a

Re: [ANNOUNCE] New committers: Ruben Quesada Lopez

2019-04-26 Thread Chunwei Lei
Congratulations, Ruben! Best, Chunwei On Sat, Apr 27, 2019 at 12:06 PM Yuzhao Chen wrote: > > Congratulations, Ruben, and thx for your work! > > Best, > Danny Chan > 在 2019年4月27日 +0800 AM10:57,Haisheng Yuan ,写道: > > Congratulations, Ruben! I am impressed by your contributions. > > > > Thanks

Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC

2019-04-26 Thread Yuzhao Chen
Congrats, Stamatis. And thx for your help ! Best, Danny Chan 在 2019年4月27日 +0800 AM10:44,dev@calcite.apache.org,写道: > > Congrats, Stamatis. Thanks for your good work.

Re: [ANNOUNCE] New committers: Chunwei Lei

2019-04-26 Thread Yuzhao Chen
Congratulations, Chunwei! Best, Danny Chan 在 2019年4月27日 +0800 AM11:04,Haisheng Yuan ,写道: > Congratulations, Chunwei! > > Thanks ~ > Haisheng Yuan > -- > 发件人:Francis Chuang > 日 期:2019年04月27日 10:34:43 > 收件人: > 主 题:[ANNOUNCE] New

Re: [ANNOUNCE] New committers: Ruben Quesada Lopez

2019-04-26 Thread Yuzhao Chen
Congratulations, Ruben, and thx for your work! Best, Danny Chan 在 2019年4月27日 +0800 AM10:57,Haisheng Yuan ,写道: > Congratulations, Ruben! I am impressed by your contributions. > > Thanks ~ > Haisheng Yuan > -- > 发件人:Francis Chuang > 日 

Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC

2019-04-26 Thread Hongze Zhang
Congratulations, Stamatis! And thank you so much for your thoughtful suggestions and kindly help on different aspects and discussions. > On Apr 27, 2019, at 10:44, Francis Chuang wrote: > > I'm pleased to announce that Stamatis has accepted an invitation to > join the Calcite PMC. Stamatis has

Re: [ANNOUNCE] New committers: Ruben Quesada Lopez

2019-04-26 Thread Hongze Zhang
Congratulations, Ruben! > On Apr 27, 2019, at 10:39, Francis Chuang wrote: > > > Apache Calcite's Project Management Committee (PMC) has invited Ruben Quesada > Lopez to become a committer, and we are pleased to announce that he has > accepted. > > In just a few months, Ruben has

Re: [ANNOUNCE] New committers: Zhiwei Peng

2019-04-26 Thread Hongze Zhang
Congratulations, Zhiwei! > On Apr 27, 2019, at 10:37, Francis Chuang wrote: > > Zhiwei Peng

Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC

2019-04-26 Thread Chunwei Lei
Congrats, Stamatis. Thanks for your good work. Best, Chunwei On Sat, Apr 27, 2019 at 10:59 AM Haisheng Yuan wrote: > > Congrats, Stamatis. You are really helpful to Calcite community. Keep up the > good work. > > Thanks ~ > Haisheng Yuan >

Re: [ANNOUNCE] New committers: Chunwei Lei

2019-04-26 Thread Haisheng Yuan
Congratulations, Chunwei! Thanks ~ Haisheng Yuan -- 发件人:Francis Chuang 日 期:2019年04月27日 10:34:43 收件人: 主 题:[ANNOUNCE] New committers: Chunwei Lei Apache Calcite's Project Management Committee (PMC) has invited Chunwei Lei to become a

Re: [ANNOUNCE] New committers: Ruben Quesada Lopez

2019-04-26 Thread Haisheng Yuan
Congratulations, Ruben! I am impressed by your contributions. Thanks ~ Haisheng Yuan -- 发件人:Francis Chuang 日 期:2019年04月27日 10:39:18 收件人: 主 题:[ANNOUNCE] New committers: Ruben Quesada Lopez Apache Calcite's Project Management

Re: [ANNOUNCE] New committers: Zhiwei Peng

2019-04-26 Thread Haisheng Yuan
Congratulations, Zhiwei! Thanks ~ Haisheng Yuan -- 发件人:Francis Chuang 日 期:2019年04月27日 10:37:11 收件人: 主 题:[ANNOUNCE] New committers: Zhiwei Peng Apache Calcite's Project Management Committee (PMC) has invited Zhiwei Peng to become a

Re: Calcite fuzz testing

2019-04-26 Thread Michael Mior
It would be interesting if the Tracehash author had a source of bug reports identified as duplicates along with stack traces to see how well it works in practice. At this point, it seems like it's just a heuristic based on an opinion of what's important. -- Michael Mior mm...@apache.org Le ven.

[ANNOUNCE] Stamatis Zampetakis joins Calcite PMC

2019-04-26 Thread Francis Chuang
I'm pleased to announce that Stamatis has accepted an invitation to join the Calcite PMC. Stamatis has been a consistent and helpful figure in the Calcite community for which we are very grateful. We look forward to the continued contributions and support. Please join me in congratulating

[ANNOUNCE] New committers: Ruben Quesada Lopez

2019-04-26 Thread Francis Chuang
Apache Calcite's Project Management Committee (PMC) has invited Ruben Quesada Lopez to become a committer, and we are pleased to announce that he has accepted. In just a few months, Ruben has contributed more than 15 pull requests to the project, fixing bugs and implementing new features.

[ANNOUNCE] New committers: Zhiwei Peng

2019-04-26 Thread Francis Chuang
Apache Calcite's Project Management Committee (PMC) has invited Zhiwei Peng to become a committer, and we are pleased to announce that he has accepted. Zhiwei has been contributing to Calcite for a while, racking up an impressive 20 pull requests, in particular, doing a lot of work to

[ANNOUNCE] New committers: Chunwei Lei

2019-04-26 Thread Francis Chuang
Apache Calcite's Project Management Committee (PMC) has invited Chunwei Lei to become a committer, and we are pleased to announce that he has accepted. Over the past few months, Chunwei has proposed numerous pull requests, reviewed PRs and opened JIRA issues for the project. Chunwei,

Re: Function sets (aka flavor and dialect)

2019-04-26 Thread Hongze Zhang
I slightly prefer "function set" (should be "FunctionSet"?), as long as starting with "fun", which names the existing connection property. Hongze > On Apr 27, 2019, at 06:45, Yuzhao Chen wrote: > > Thx for the discussing, Julian > > I’m also confused about the difference between

Re: JIRA usage reminders

2019-04-26 Thread Hongze Zhang
Thanks for the summing up, Stamatis. That helps a lot, and I am convinced by the advantages. Also, I've re-checked the original definition[1] of the status flags CLOSED, RESOLVED, etc. Following is what "RESOLVED" is for: > RESOLVED: The issue is considered finished, the resolution is correct.

Re: How to traverse RelNode’s parent conviniently?

2019-04-26 Thread Yuzhao Chen
Thx Julian Mostly got your idea, but one thing needs to confirm: Now the MetadataHandler is kind of query lazy the cache is code-gen ed in the handler class, the metadata also propagate from inputs, when I got an RelNode’s hint, how can I cache it in the metadata handler for querying ? Best,

Re: Function sets (aka flavor and dialect)

2019-04-26 Thread Yuzhao Chen
Thx for the discussing, Julian I’m also confused about the difference between SqlConformance and SqlDialect, and now the Flavor, why not just use one word SqlDialect uniformly ? My interpretation about sql dialect includes the functions, cause they are part of the sql syntax as operators.

Re: Calcite fuzz testing

2019-04-26 Thread Julian Hyde
What is the evidence that Tracehash actually works? In GeoHash there is a notion of proximity, so it is clear that if two locations are within 10 miles then there will be a maximum distance between their hashes. When Tracehash removes part of the stack, is this based on a human expert’s

Re: How to traverse RelNode’s parent conviniently?

2019-04-26 Thread Julian Hyde
The RelMetadata system is designed for these kinds of annotations - if there is a “global hints cache” there’s no benefit to doing it outside the RelMetadata system. That said, I don’t know (and I don’t think anyone knows) how we want hints to be propagated as we generate RelNodes from

Re: How to traverse RelNode’s parent conviniently?

2019-04-26 Thread Yuzhao Chen
Thx, Julian Let me repeat my thoughts about the details again, in order to implement the hints, maybe these things are needed: The main diff is that we will maintain a global hints cache 1. Supports hints grammar for parser.jj 2. During/after sql-to-rel, we may pass a hints cache to the

Re: Support non-equi join condition for EnumerableJoin, EnumerableMergeJoin and EnumerableSemiJoin ? Just a discussing..

2019-04-26 Thread Yuzhao Chen
Thx, Stamatis Finally I think that [3] will provide better compatibility, just like you said that some engines may not support non-equi HashJoin, so pushing into non-equi join conditions seems not that necessary. The better way is to give more join algorithm :), I will try my best to

Re: calcite-test-dataset VM has issues with Druid

2019-04-26 Thread Stamatis Zampetakis
As a workaround for making Druid work you can do the following: $ vagrant ssh $ cd /dataset/druid $ ./install.sh On Fri, Apr 26, 2019 at 4:48 AM Yuzhao Chen wrote: > I also ran this issue, and make sure stop/up will definitely make Druid > not work any more. > > Best, > Danny Chan > 在

Re: Calcite fuzz testing

2019-04-26 Thread Michael Mior
I could see some might dismiss this as noise, but I really like the idea of tracehash and it would be nice to see that catch on. (I think it would be interesting if it could be structured something like a geohash so truncation would reduce specificity, but it's less obvious how to do this here.)

Re: Re: Function sets (aka flavor and dialect)

2019-04-26 Thread Haisheng Yuan
Catalog or Namespace? Thanks ~ Haisheng Yuan -- 发件人:Michael Mior 日 期:2019年04月27日 02:47:37 收件人: 主 题:Re: Function sets (aka flavor and dialect) I think "function set" sounds like a reasonable name. My current interpretation of dialect

Re: Function sets (aka flavor and dialect)

2019-04-26 Thread Michael Mior
I think "function set" sounds like a reasonable name. My current interpretation of dialect is that it's more related to the SQL syntax accepted by each system. I'm not really sure what the intended difference is between dialect and conformance is, but it seems like perhaps these two concepts could

Re: Calcite fuzz testing

2019-04-26 Thread Vladimir Sitnikov
Let me post a couple of links I've came across today (it comes out of this Twitter thread: https://twitter.com/backendsecret/status/1121290210464034816 ): https://github.com/alexknvl/fuzzball -- it is a machine learning driven fuzzer for Scala which identifies quite a few bugs in Scala compiler.

Re: JIRA usage reminders

2019-04-26 Thread Stamatis Zampetakis
Thanks everybody for the feedback. I will try to gather up everything said here and complete the website. @Hongze Using directly closed for duplicates, won't fix, etc., is a subject to debate so I am ok with any decision we take on this. Summing up below some pros and cons. Advantages: *

Re: Google BigQuery - zetasql parser/analyzer

2019-04-26 Thread Julian Hyde
Thanks for chiming in, Andrew. I’m a little confused about the purpose of ZetaSQL currently. (I’m sure it will start to click as time goes on.) My initial reaction is that ZetaSQL has similar goals to Calcite - to decompose the traditional DBMS into components from which people can roll their

Re: Support non-equi join condition for EnumerableJoin, EnumerableMergeJoin and EnumerableSemiJoin ? Just a discussing..

2019-04-26 Thread Stamatis Zampetakis
Hi Danny, Yes, I agree that we don't need two variations of hash joins (EnumerableHashJoin and EnumerableThetaHashJoin) as it is the code right now. Having that said, I am not sure if we can really handle the general case of theta joins with hash-based algorithms. The approach in [3] does not

Re: Google BigQuery - zetasql parser/analyzer

2019-04-26 Thread Michael Mior
This is basically the point of the Babel parser, to be as liberal as possible in what SQL is accepted and configurable where things necessarily conflict between different implementations. Andrew, could you clarify what you're hoping to contribute to Babel? I think support for any dialect of SQL

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

2019-04-26 Thread Stamatis Zampetakis
System: Windows 10 Pro, jdk12, maven 3.6.1 -checked signatures and checksums OK -went quickly over release note OK -run unit tests (mvn clean install) on git repo OK -run unit tests of Calcite current master (mvn clean install -fn) with Avatica 1.14.0 KO All errors are of the following form: