Re: [ANNOUNCE] New committers: Zhiwei Peng
Welcome Zhiwei and thanks for your contributions! -- Michael Mior mm...@apache.org Le ven. 26 avr. 2019 à 22:37, Francis Chuang a écrit : > > 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 > improve RexSimplify. > > Zhiwei, welcome, thank you for your contributions, and we look forward > your further interactions with the community! If you wish, please feel > free to tell us more about yourself and what you are working on. > > Francis (on behalf of the Apache Calcite PMC)
Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC
Congratulations Stamatis and thanks for all you've done! -- Michael Mior mm...@apache.org Le ven. 26 avr. 2019 à 22:44, Francis Chuang a écrit : > > 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 Stamatis! > > - Francis (on behalf of the Calcite PMC)
Re: [ANNOUNCE] New committers: Ruben Quesada Lopez
Welcome Ruben! -- Michael Mior mm...@apache.org Le ven. 26 avr. 2019 à 22:39, Francis Chuang a écrit : > > > 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. > > Ruben, welcome, thank you for your contributions, and we look forward > your further interactions with the community! If you wish, please feel > free to tell us more about yourself and what you are working on. > > Francis (on behalf of the Apache Calcite PMC)
Re: [ANNOUNCE] New committers: Chunwei Lei
Congratulations and welcome Chunwei! -- Michael Mior mm...@apache.org Le ven. 26 avr. 2019 à 22:34, Francis Chuang a écrit : > > 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, welcome, thank you for your contributions, and we look forward > your further interactions with the community! If you wish, please feel > free to tell us more about yourself and what you are working on. > > Francis (on behalf of the Apache Calcite PMC)
Re: [ANNOUNCE] New committers: Zhiwei Peng
Thanks very much for the introduction an you warm welcome! I have build streaming sql engine based on calcite for two years in Ant Financial Group. It is really an excellent project! It is a great honor for me to join the apache calcite. I will continue the work on and contribute more to the community. . 2019年4月27日 上午10: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 while, racking up an impressive 20 pull requests, in particular, doing a lot of work to improve RexSimplify. Zhiwei, welcome, thank you for your contributions, and we look forward your further interactions with the community! If you wish, please feel free to tell us more about yourself and what you are working on. Francis (on behalf of the Apache Calcite PMC)
Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC
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 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 Stamatis! > > > > - Francis (on behalf of the Calcite PMC) > >
[jira] [Created] (CALCITE-3028) Support FULL OUTER JOIN with AggregateJoinTransposeRule
Vineet Garg created CALCITE-3028: Summary: Support FULL OUTER JOIN with AggregateJoinTransposeRule Key: CALCITE-3028 URL: https://issues.apache.org/jira/browse/CALCITE-3028 Project: Calcite Issue Type: Improvement Reporter: Vineet Garg Assignee: Vineet Garg This is continuation of CALCITE-3011, which supported LEFT OUTER and RIGHT OUTER joins without aggregate functions. FULL OUTER JOIN was not supported at the time due to CALCITE-3012 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
Re: [ANNOUNCE] New committers: Chunwei Lei
Congratulations Chunwei! On Sat, Apr 27, 2019 at 11:20 AM Kevin Risden wrote: > Congrats and welcome! > > Kevin Risden > > > On Sat, Apr 27, 2019 at 11:36 AM Stamatis Zampetakis > wrote: > > > It's great to have you onboard Chunwei! > > > > I would love to see some those of optimizations land in Calcite. > > > > Great work so far, keep it up :) > > > > On Sat, Apr 27, 2019 at 4:39 PM Chunwei Lei > > wrote: > > > > > Thank you all for the warm welcome! > > > > > > I am currently working at optimizer team of Alibaba MaxCompute which > > > uses Calcite > > > for cost-based query optimization. In the past few months, I have been > > > focusing on > > > reducing optimization latency including reducing rule attempts, > > > introducing plan cache > > > and so on. > > > > > > It is my great honor to become a committer of Apache Calcite and I > > > will do my best to > > > make more contributions. > > > > > > > > > Best, > > > Chunwei > > > > > > On Sat, Apr 27, 2019 at 12:05 PM Yuzhao Chen > > wrote: > > > > > > > > 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 committers: Chunwei Lei > > > > > > > > > > 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, welcome, thank you for your contributions, and we look > > forward > > > > > your further interactions with the community! If you wish, please > > feel > > > > > free to tell us more about yourself and what you are working on. > > > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > > > > >
Re: [ANNOUNCE] New committers: Ruben Quesada Lopez
Congratulations Ruben. On Sat, Apr 27, 2019 at 11:19 AM Kevin Risden wrote: > Congrats and welcome! > > Kevin Risden > > > On Sat, Apr 27, 2019 at 1:48 PM Ruben Q L wrote: > > > Thank you everyone for your kind messages. > > > > Currently I am working with Stamatis in the Core Engine team at TIBCO > > (formerly Orchestra Networks) in Paris, France. We are developing a new > > Calcite-based Query Execution Framework for our product TIBCO EBX. > > > > It is an honor to be part of this community, I will do my best to > > contribute to the project. > > > > Best regards, > > Ruben Q. L. > > > > > > Le sam. 27 avr. 2019 à 18:00, Stamatis Zampetakis a > > écrit : > > > > > Congrats Ruben! > > > > > > It's been a pleasure working with you. > > > > > > Looking forward to see recursive queries and many more great > > contributions > > > in Calcite. > > > > > > > > > On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei > > > wrote: > > > > > > > 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 ~ > > > > > > Haisheng Yuan > > > > > > > -- > > > > > > 发件人：Francis Chuang > > > > > > 日 期：2019年04月27日 10:39:18 > > > > > > 收件人： > > > > > > 主 题：[ANNOUNCE] New committers: Ruben Quesada Lopez > > > > > > > > > > > > > > > > > > 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. > > > > > > > > > > > > Ruben, welcome, thank you for your contributions, and we look > > forward > > > > > > your further interactions with the community! If you wish, please > > > feel > > > > > > free to tell us more about yourself and what you are working on. > > > > > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > > > > > > > > >
Re: [ANNOUNCE] New committers: Zhiwei Peng
Congratulations Zhiwei! On Sat, Apr 27, 2019 at 11:19 AM Kevin Risden wrote: > Congrats and welcome! > > Kevin Risden > > > On Sat, Apr 27, 2019 at 11:44 AM Stamatis Zampetakis > wrote: > > > Congratulations Zhiwei! > > > > With so many high quality contributions there is nothing left to say. > Well > > deserved! > > > > On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei > > wrote: > > > > > 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 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 > > > > > improve RexSimplify. > > > > > > > > > > Zhiwei, welcome, thank you for your contributions, and we look > > forward > > > > > your further interactions with the community! If you wish, please > > feel > > > > > free to tell us more about yourself and what you are working on. > > > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > > > > >
Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC
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 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 Stamatis! > > - Francis (on behalf of the Calcite PMC) >
Re: [ANNOUNCE] New committers: Zhiwei Peng
Congrats and welcome! Kevin Risden On Sat, Apr 27, 2019 at 11:44 AM Stamatis Zampetakis wrote: > Congratulations Zhiwei! > > With so many high quality contributions there is nothing left to say. Well > deserved! > > On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei > wrote: > > > 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 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 > > > > improve RexSimplify. > > > > > > > > Zhiwei, welcome, thank you for your contributions, and we look > forward > > > > your further interactions with the community! If you wish, please > feel > > > > free to tell us more about yourself and what you are working on. > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > >
Re: [ANNOUNCE] New committers: Chunwei Lei
Congrats and welcome! Kevin Risden On Sat, Apr 27, 2019 at 11:36 AM Stamatis Zampetakis wrote: > It's great to have you onboard Chunwei! > > I would love to see some those of optimizations land in Calcite. > > Great work so far, keep it up :) > > On Sat, Apr 27, 2019 at 4:39 PM Chunwei Lei > wrote: > > > Thank you all for the warm welcome! > > > > I am currently working at optimizer team of Alibaba MaxCompute which > > uses Calcite > > for cost-based query optimization. In the past few months, I have been > > focusing on > > reducing optimization latency including reducing rule attempts, > > introducing plan cache > > and so on. > > > > It is my great honor to become a committer of Apache Calcite and I > > will do my best to > > make more contributions. > > > > > > Best, > > Chunwei > > > > On Sat, Apr 27, 2019 at 12:05 PM Yuzhao Chen > wrote: > > > > > > 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 committers: Chunwei Lei > > > > > > > > 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, welcome, thank you for your contributions, and we look > forward > > > > your further interactions with the community! If you wish, please > feel > > > > free to tell us more about yourself and what you are working on. > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > >
Re: [ANNOUNCE] Stamatis Zampetakis joins Calcite PMC
Congrats Stamatis! Kevin Risden On Sat, Apr 27, 2019 at 12:13 AM Yuzhao Chen wrote: > 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: Ruben Quesada Lopez
Congrats and welcome! Kevin Risden On Sat, Apr 27, 2019 at 1:48 PM Ruben Q L wrote: > Thank you everyone for your kind messages. > > Currently I am working with Stamatis in the Core Engine team at TIBCO > (formerly Orchestra Networks) in Paris, France. We are developing a new > Calcite-based Query Execution Framework for our product TIBCO EBX. > > It is an honor to be part of this community, I will do my best to > contribute to the project. > > Best regards, > Ruben Q. L. > > > Le sam. 27 avr. 2019 à 18:00, Stamatis Zampetakis a > écrit : > > > Congrats Ruben! > > > > It's been a pleasure working with you. > > > > Looking forward to see recursive queries and many more great > contributions > > in Calcite. > > > > > > On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei > > wrote: > > > > > 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 ~ > > > > > Haisheng Yuan > > > > > -- > > > > > 发件人：Francis Chuang > > > > > 日 期：2019年04月27日 10:39:18 > > > > > 收件人： > > > > > 主 题：[ANNOUNCE] New committers: Ruben Quesada Lopez > > > > > > > > > > > > > > > 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. > > > > > > > > > > Ruben, welcome, thank you for your contributions, and we look > forward > > > > > your further interactions with the community! If you wish, please > > feel > > > > > free to tell us more about yourself and what you are working on. > > > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > > > > >
Re: [ANNOUNCE] New committers: Ruben Quesada Lopez
Thank you everyone for your kind messages. Currently I am working with Stamatis in the Core Engine team at TIBCO (formerly Orchestra Networks) in Paris, France. We are developing a new Calcite-based Query Execution Framework for our product TIBCO EBX. It is an honor to be part of this community, I will do my best to contribute to the project. Best regards, Ruben Q. L. Le sam. 27 avr. 2019 à 18:00, Stamatis Zampetakis a écrit : > Congrats Ruben! > > It's been a pleasure working with you. > > Looking forward to see recursive queries and many more great contributions > in Calcite. > > > On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei > wrote: > > > 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 ~ > > > > Haisheng Yuan > > > > -- > > > > 发件人：Francis Chuang > > > > 日 期：2019年04月27日 10:39:18 > > > > 收件人： > > > > 主 题：[ANNOUNCE] New committers: Ruben Quesada Lopez > > > > > > > > > > > > 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. > > > > > > > > Ruben, welcome, thank you for your contributions, and we look forward > > > > your further interactions with the community! If you wish, please > feel > > > > free to tell us more about yourself and what you are working on. > > > > > > > > Francis (on behalf of the Apache Calcite PMC) > > >
Re: [ANNOUNCE] New committers: Ruben Quesada Lopez
Congrats Ruben! It's been a pleasure working with you. Looking forward to see recursive queries and many more great contributions in Calcite. On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei wrote: > 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 ~ > > > Haisheng Yuan > > > -- > > > 发件人：Francis Chuang > > > 日 期：2019年04月27日 10:39:18 > > > 收件人： > > > 主 题：[ANNOUNCE] New committers: Ruben Quesada Lopez > > > > > > > > > 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. > > > > > > Ruben, welcome, thank you for your contributions, and we look forward > > > your further interactions with the community! If you wish, please feel > > > free to tell us more about yourself and what you are working on. > > > > > > Francis (on behalf of the Apache Calcite PMC) >
Re: [ANNOUNCE] New committers: Zhiwei Peng
Congratulations Zhiwei! With so many high quality contributions there is nothing left to say. Well deserved! On Sat, Apr 27, 2019 at 6:14 AM Chunwei Lei wrote: > 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 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 > > > improve RexSimplify. > > > > > > Zhiwei, welcome, thank you for your contributions, and we look forward > > > your further interactions with the community! If you wish, please feel > > > free to tell us more about yourself and what you are working on. > > > > > > Francis (on behalf of the Apache Calcite PMC) >
Re: [ANNOUNCE] New committers: Chunwei Lei
It's great to have you onboard Chunwei! I would love to see some those of optimizations land in Calcite. Great work so far, keep it up :) On Sat, Apr 27, 2019 at 4:39 PM Chunwei Lei wrote: > Thank you all for the warm welcome! > > I am currently working at optimizer team of Alibaba MaxCompute which > uses Calcite > for cost-based query optimization. In the past few months, I have been > focusing on > reducing optimization latency including reducing rule attempts, > introducing plan cache > and so on. > > It is my great honor to become a committer of Apache Calcite and I > will do my best to > make more contributions. > > > Best, > Chunwei > > On Sat, Apr 27, 2019 at 12:05 PM Yuzhao Chen wrote: > > > > 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 committers: Chunwei Lei > > > > > > 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, welcome, thank you for your contributions, and we look forward > > > your further interactions with the community! If you wish, please feel > > > free to tell us more about yourself and what you are working on. > > > > > > Francis (on behalf of the Apache Calcite PMC) >
Re: [ANNOUNCE] New committers: Chunwei Lei
Thank you all for the warm welcome! I am currently working at optimizer team of Alibaba MaxCompute which uses Calcite for cost-based query optimization. In the past few months, I have been focusing on reducing optimization latency including reducing rule attempts, introducing plan cache and so on. It is my great honor to become a committer of Apache Calcite and I will do my best to make more contributions. Best, Chunwei On Sat, Apr 27, 2019 at 12:05 PM Yuzhao Chen wrote: > > 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 committers: Chunwei Lei > > > > 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, welcome, thank you for your contributions, and we look forward > > your further interactions with the community! If you wish, please feel > > free to tell us more about yourself and what you are working on. > > > > Francis (on behalf of the Apache Calcite PMC)
Re: How to traverse RelNode’s parent conviniently?
This is a very interesting topic, thanks for starting this discussion Danny! Metadata seems a very reasonable way to handle hints and I guess the proposal by Julian is the way to go. For the sake of discussion (brainstorming), I was thinking that rules from hints do not differ too much. The final goal is to allow end-users to affect the planning process for a given query towards a particular plan. I guess this could be achieved by registering custom rules that are taken into account by the planner (and can be possibly ignored). I admit that passing hints alongside the SQL query is convenient for end-users so most likely we cannot avoid changing the grammar. Following the rules idea, I was wondering if instead of attaching hints to the SqlNode/RelNode(s) as metadata or so we could rather enable/disable/generate rules for the planner. A small example below: /* +EnumerableHashJoinRule(e1,d1) */ SELECT e1.name FROM emp e1 INNER JOIN dept d1 ON e1.did=d1.id WHERE d1.name = 'HR' The rule matches when the operator is a Join.class and left child is aliased to e1 and right child is aliased to d1; it transforms the LogicalJoin to an EnumerableHashJoin. I haven't thought a lot on this but maybe this hint/rule based approach gives some inspiration to somebody in this list. Best, Stamatis On Sat, Apr 27, 2019 at 1:40 AM Yuzhao Chen wrote: > 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, > Danny Chan > 在 2019年4月27日 +0800 AM6:57，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 RelNodes. I think we > should focus on really simple cases first (e.g. hints about the whole > query, or about particular table scans), and not try to automatically > propagate them. > > > > We can make the hints propagation mechanism more sophisticated when we > have an actual use case to drive us. > > > > Julian > > > > > > > On Apr 26, 2019, at 3:41 PM, Yuzhao Chen wrote: > > > > > > 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 > SqlToRelConverter, there is a visitor to setup/init the RelNodes’hints to > the cache once at a time, this cache scope is global and would be active > the whole query planning time. The cache only keep hints for few top nodes > that really needs > > > 3. In the Planner, add set/get hints cache method, so that in the > planning rules, we can see the hints cache, > > > And we can also ban some rule matching in the planner > > > 4. Hook the RelOptCall#transformTo method to handle logic of hints > propagating(invoke the hints logic again same as sql-to-rel phrase), this > will also update the global hints cache > > > It seems that given the global hints cache, we do not need the > MetaDataHandler any more, this is the thing I most want to make sure. > > > Hope for your suggestions. > > > > > > Best, > > > Danny Chan > > > 在 2019年4月25日 +0800 AM3:07，Julian Hyde ，写道： > > > > I think it’s OK to attach hints to the (few) RelNodes that come out > of the SqlToRelConverter. > > > > > > > > But it would be a mistake to try to propagate those hints to all of > the RelNodes that are created during query planning. Even if we changed all > of the copy methods (a huge task) there are many other ways that RelNodes > get created. We would end up with a RelNode graph with lots of hints, and > most of those hints would be inaccurate or not applicable. > > > > > > > > For a particular hint, say "/*+ nohashjoin */“, some piece of code > would need to look at the initial RelNode tree and take its own action: > say, build a data structure to be used by planner rules, or enable or > disable planner rules. > > > > > > > > > > > > > On Apr 23, 2019, at 9:31 PM, Chunwei Lei > wrote: > > > > > > > > > > Thanks Danny. > > > > > > > > > > Those are good points. I think it depends on what we consider hint > as. > > > > > IMHO, if we consider hint as a kind of metadata, > > > > > it is not a good idea to store the hints in the RelNode instance. > > > > > > > > > > > > > > > > > > > > Best, > > > > > Chunwei > > > > > > > > > > On Wed, Apr 24, 2019 at 11:09 AM Yuzhao Chen > wrote: > > > > > > > > > > > > Thx, Julian > > > > > > > > > > > > I think the hint path is a good way for searching RelNode’s > parents, broadly, there may be these
Re: [VOTE] Release apache-calcite-avatica-1.14.0 (release candidate 0)
+1 Checked hashes and signatures and compiled and ran tests. Thanks Francis! -- Michael Mior mm...@apache.org Le jeu. 25 avr. 2019 à 18:18, Francis Chuang a écrit : > > Hi all, > > I have created a build for Apache Calcite Avatica 1.14.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-avatica/blob/branch-avatica-1.14/site/_docs/history.md > > The commit to be voted upon: > https://gitbox.apache.org/repos/asf?p=calcite-avatica.git;a=commit;h=4fe0f9b8c7df2aa061caaff12e5ff02ceb8c02c0 > > Its hash is 4fe0f9b8c7df2aa061caaff12e5ff02ceb8c02c0. > > The artifacts to be voted on are located here: > https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-avatica-1.14.0-rc0/ > > The hashes of the artifacts are as follows: > src.tar.gz.sha512 > 58b264957da88c43ab1aa650a47b3728f9c94403a29ddf34d57d1fc24e8d4c005b58dd9f81fd6a0e7ce0dddbe6123a98f94b19c8cd760935890df4e78b5476c9 > > A staged Maven repository is available for review at: > https://repository.apache.org/content/repositories/orgapachecalcite-1058 > > Release artifacts are signed with the following key: > https://people.apache.org/keys/committer/francischuang.asc > > If you do not have a Java environment available, you can run the tests > using docker. To do so, install docker and docker-compose, then run > docker-compose run test" from the root of the directory. > > Please vote on releasing this package as Apache Calcite Avatica 1.14.0. > > The vote is open for the next 72 hours and passes if a majority of > at least three +1 PMC votes are cast. > > [ ] +1 Release this package as Apache Calcite 1.14.0 > [ ] 0 I don't feel strongly about it, but I'm okay with the release > [ ] -1 Do not release this package because... > > > Here is my vote: > > +1 (binding) > > Francis
[jira] [Created] (CALCITE-3027) Support like query in Elasticsearch
yeyonghao created CALCITE-3027:
--
Summary: Support like query in Elasticsearch
Key: CALCITE-3027
URL: https://issues.apache.org/jira/browse/CALCITE-3027
Project: Calcite
Issue Type: New Feature
Components: elasticsearch-adapter
Reporter: yeyonghao
In Elasticsearch, fuzzy matching is implemented by wildcard query:
{code:java}
GET /company/_search
{
"query": {
"constant_score": {
"filter": {
"wildcard":{
"name_text":"*Alle_"
}
}
}
}
}
{code}
The symbols % and _ in sql are equivalent to the symbols * and ? in es,
respectively.
So I added a new QueryBuilder class to support wildcard queries:
{code:java}
static class WildcardQueryBuilder extends QueryBuilder {
private final String fieldName;
private final String value;
WildcardQueryBuilder(String fieldName, String value) {
this.fieldName = fieldName;
this.value = transformValue(value);
}
@Override void writeJson(JsonGenerator generator) throws IOException {
generator.writeStartObject();
generator.writeFieldName("wildcard");
generator.writeStartObject();
generator.writeFieldName(fieldName);
writeObject(generator, value);
generator.writeEndObject();
generator.writeEndObject();
}
// The symbols % and _ in sql are equivalent to the symbols * and ? in es,
respectively.
private String transformValue(String value) {
if (value != null) {
value = value
.replaceAll("%", "*")
.replaceAll("_", "?");
}
return value;
}
}
{code}
Below I give some examples to illustrate this like query.
*Elasticsearch Version*
{code:java}
$ ./elasticsearch --version
Version: 6.1.2, Build: Unknown/2019-03-19T15:31:12.734Z, JVM: 1.8.0_181
{code}
*Mock Data In Elasticsearch*
{code:java}
PUT company
{
"mappings": {
"doc": {
"properties": {
"name_keyword":{
"type": "keyword"
},
"name_text":{
"type": "text"
}
}
}
}
}
PUT /company/doc/_bulk?refresh
{"index":{}}
{"name_keyword":"hello to Allen","name_text":"hello to Allen"}
{"index":{}}
{"name_keyword":"say hi william","name_text":"say hi william"}
{"index":{}}
{"name_keyword":"hello to Rose","name_text":"hello to Rose"}
{code}
*Test in sqlline*
model.json
{code:java}
{
"version": "1.0",
"defaultSchema": "elasticsearch",
"schemas": [
{
"type": "custom",
"name": "elasticsearch",
"factory":
"org.apache.calcite.adapter.elasticsearch.ElasticsearchSchemaFactory",
"operand": {
"coordinates": "{'127.0.0.1': 9200}",
"index": "company"
}
}
]
}
{code}
sqlline test
{code:java}
$ ./sqlline
sqlline version 1.7.0
sqlline> !connect jdbc:calcite:model=model.json admin admin
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/Users/yeyonghao/maven/repository/org/slf4j/slf4j-log4j12/1.7.25/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/Users/yeyonghao/maven/repository/ch/qos/logback/logback-classic/1.1.3/logback-classic-1.1.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Transaction isolation level TRANSACTION_REPEATABLE_READ is not supported.
Default (TRANSACTION_NONE) will be used instead.
0: jdbc:calcite:model=model.json> select * from "doc";
+-+
| _MAP |
+-+
| {name_keyword=hello to Allen, name_text=hello to Allen} |
| {name_keyword=hello to Rose, name_text=hello to Rose} |
| {name_keyword=say hi william, name_text=say hi william} |
+-+
3 rows selected (1.536 seconds)
0: jdbc:calcite:model=model.json>
0: jdbc:calcite:model=model.json> select * from "doc" where
_MAP['name_keyword'] like '%Alle_';
+-+
| _MAP |
+-+
| {name_keyword=hello to Allen, name_text=hello to Allen} |
+-+
1 row selected (0.092 seconds)
0: jdbc:calcite:model=model.json>
0: jdbc:calcite:model=model.json> select * from "doc" where
_MAP['name_keyword'] like 'hello to Rose';
+---+
| _MAP |
+---+
| {name_keyword=hello to Rose, name_text=hello to Rose} |
+---+
1 row selected (0.063 seconds)
0: jdbc:calcite:model=model.json>
0: jdbc:calcite:model=model.json> select * from "doc" where
Re: Subscribe Apache Calcite
Hi xpleaf, If you want to subscribe the mailing list of Apache Calcite, you may send email to dev-subscr...@calcite.apache.org. BTW, you can find more in https://calcite.apache.org/develop/#contributing. Best, Chunwei On Sat, Apr 27, 2019 at 3:45 PM 叶泳豪 wrote: > > Hi, > I would like to contribute to Apache Calcite and share some of my ideas. > _ > xpleaf. >
Subscribe Apache Calcite
Hi, I would like to contribute to Apache Calcite and share some of my ideas. _ xpleaf.
Re: Re: [VOTE] Release apache-calcite-avatica-1.14.0 (release candidate 0)
Environment: Mac OS X 10.13.4, JDK 1.8.0_162, Maven 3.5.2 - Checked signatures and checksums, OK - Checked release note, OK - Ran unit tests (mvn clean install), OK - Ran unit tests on Calcite master with Avatica 1.14.0 rc0, OK +1 (non-binding) Thanks ~ Haisheng Yuan -- 发件人：Stamatis Zampetakis 日 期：2019年04月26日 16:26:16 收件人： 主 题：Re: [VOTE] Release apache-calcite-avatica-1.14.0 (release candidate 0) 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: [ERROR] testNonSqlException(org.apache.calcite.test.ExceptionMessageTest) java.lang.AssertionError: Expected: "Error while executing SQL \"select * from \"badEntries\"\": Can't iterate over badEntries" but: was "Error while executing SQL \"select * from \"badEntries\"\"" at org.apache.calcite.test.ExceptionMessageTest.testNonSqlException(ExceptionMessageTest.java:108) which seem related to CALCITE-2845 so I guess normal and expected. +1 (binding) On Fri, Apr 26, 2019 at 12:18 AM Francis Chuang wrote: > Hi all, > > I have created a build for Apache Calcite Avatica 1.14.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-avatica/blob/branch-avatica-1.14/site/_docs/history.md > > The commit to be voted upon: > > https://gitbox.apache.org/repos/asf?p=calcite-avatica.git;a=commit;h=4fe0f9b8c7df2aa061caaff12e5ff02ceb8c02c0 > > Its hash is 4fe0f9b8c7df2aa061caaff12e5ff02ceb8c02c0. > > The artifacts to be voted on are located here: > > https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-avatica-1.14.0-rc0/ > > The hashes of the artifacts are as follows: > src.tar.gz.sha512 > > 58b264957da88c43ab1aa650a47b3728f9c94403a29ddf34d57d1fc24e8d4c005b58dd9f81fd6a0e7ce0dddbe6123a98f94b19c8cd760935890df4e78b5476c9 > > A staged Maven repository is available for review at: > https://repository.apache.org/content/repositories/orgapachecalcite-1058 > > Release artifacts are signed with the following key: > https://people.apache.org/keys/committer/francischuang.asc > > If you do not have a Java environment available, you can run the tests > using docker. To do so, install docker and docker-compose, then run > docker-compose run test" from the root of the directory. > > Please vote on releasing this package as Apache Calcite Avatica 1.14.0. > > The vote is open for the next 72 hours and passes if a majority of > at least three +1 PMC votes are cast. > > [ ] +1 Release this package as Apache Calcite 1.14.0 > [ ] 0 I don't feel strongly about it, but I'm okay with the release > [ ] -1 Do not release this package because... > > > Here is my vote: > > +1 (binding) > > Francis >
