This was extracted (@ 2025-02-19 21:10) from a list of minutes
which have been approved by the Board.
Please Note
The Board typically approves the minutes of the previous meeting at the
beginning of every Board meeting; therefore, the list below does not
normally contain details from the minutes of the most recent Board meeting.
WARNING: these pages may omit some original contents of the minutes.
Meeting times vary, the exact schedule is available to ASF Members and Officers, search for "calendar" in the Foundation's private index page (svn:foundation/private-index.html).
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: Current project status: ongoing (high activity) Issues for the board: none ## Membership Data: Apache Calcite was founded 2015-10-22 (9 years ago) There are currently 75 committers and 29 PMC members in this project. The Committer-to-PMC ratio is roughly 5:2. Community changes, past quarter: - No new PMC members. Last addition was Mihai Budiu on 2024-07-26. - No new committers. Last addition was Norman Jordan on 2024-08-13. ## Project Activity: Apache Calcite 1.38.0 was released on 2024-10-15. It contained contributions from 39 contributors, and resolved 165 issues. The main features of this release were the AS MEASURE clause to define measures and use them in simple queries, ASOF join, the EXCLUDE clause in window aggregates, Postgres-compatible implementations of the TO_DATE, TO_TIMESTAMP and TO_CHAR functions, and the extension of the type system to allow types with negative scale. There was no release for Apache Avatica in the last quarter, but discussions have started to release the next version (1.26.0) soon. Following our traditional yearly rotation, a new PMC Chair (Ruben Quesada Lopez) was chosen for 2025. ## Community Health: The community continues on a "Super healthy" status. Looking at the metrics, we have seen an increase on the commit activity (10% increase on commits, 42% increase on code contributors). Other metrics show a slight decrease, e.g. 9% decrease in traffic on the dev meailing list, or 16% / 10% decrease on opened / closed PRs, which is understandable considering the holiday period at the end of the year. The number of non-committer (contributor) commits per month: +------+-------+---------------------+ | year | month | contributor_commits | +------+-------+---------------------+ | 2024 | 10 | 16 | | 2024 | 11 | 19 | | 2024 | 12 | 19 | +------+-------+---------------------+ The number of active reviewers per month: +------+-------+------------------+ | year | month | active_reviewers | +------+-------+------------------+ | 2024 | 10 | 3 | | 2024 | 11 | 2 | | 2024 | 12 | 5 | +------+-------+------------------+ Top reviewers in the last 3 months: +-------------+---------+ | committer | reviews | +-------------+---------+ | Mihai Budiu | 39 | | ILuffZhe | 5 | | NobiGo | 4 | +-------------+---------+ We have seen a decrease in the number of reviewers compared to previous quarters, with one particular reviewer (Mihai Budiu) being the most active one and taking care of most of this job. The situation with PR reviewing and the lack of reviewers, especially in a non-release period (usually right before a release more reviewers tend to get involved), is a known issue within the community, which has been discussed several times on the mailing list with several proposals to try to mitigate it.
WHEREAS, the Board of Directors heretofore appointed Benchao Li (libenchao) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Benchao Li from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Ruben Q L (rubenql) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Benchao Li is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Ruben Q L be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7B, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: here are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (9 years ago) There are currently 75 committers and 29 PMC members in this project. The Committer-to-PMC ratio is roughly 5:2. Community changes, past quarter: - Mihai Budiu was added to the PMC on 2024-07-26 - Norman Jordan was added as committer on 2024-08-14 ## Project Activity: There was no release in Q3 yet, however, we've planned to release Calcite 1.38.0 and Avatica 1.26.0 lately. Calcite 1.38.0 is mostly ready, it's hopeful to release it in one or two weeks. Besides releases, I would like also to mention that several talks related to Apache Calcite were presented by Jiajun Xie, Cancai Cai, and Xuanda Wen in Apache Community Over Code Asia 2024 (happened in HangZhou on July 26-28). ## Community Health: The community maintains a super healthy status, previously it's healthy, the reason is that we've invited both a new Committer and a PMC member in Q3. Most of the statistics has increased compared to last quarter (dev@ increased by 42%, issues@ increased by 46%, commits increased by 90%, code contributors increased by 43%), and the numbers of non-committer commits and active reviewers are have also increased. All the numbers show that the community is in a good status, there are always new contributors coming in which is very important for the community. The number of non-committer (contributor) commits per month: +------+-------+---------------------+ | year | month | contributor_commits | +------+-------+---------------------+ | 2024 | 7 | 30 | | 2024 | 8 | 28 | | 2024 | 9 | 28 | +------+-------+---------------------+ The number of active reviewers per month: +------+-------+------------------+ | year | month | active_reviewers | +------+-------+------------------+ | 2024 | 7 | 7 | | 2024 | 8 | 4 | | 2024 | 9 | 7 | +------+-------+------------------+ Top reviewers in the last 3 months: +----------------------------------+---------+ | committer | reviews | +----------------------------------+---------+ | Mihai Budiu <mbudiu@feldera.com> | 37 | | NobiGo <nobigogle@gmail.com> | 24 | | Julian Hyde <jhyde@apache.org> | 11 | +----------------------------------+---------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (9 years ago) There are currently 74 committers and 28 PMC members in this project. The Committer-to-PMC ratio is roughly 5:2. Community changes, past quarter: - No new PMC members. Last addition was Sergey Nuyanzin on 2024-03-05. - No new committers. Last addition was Hongyu Guo on 2023-11-03. ## Project Activity: Apache Calcite Avatica 1.25.0 was released on 2024-04-05. It is a routine release featuring support for JDK 21, Gradle 8.5 and several bug fixes. Apache Calcite 1.37.0 was released on 2024-05-04. It contains contributions from 46 contributors, and resolves 138 issues. It introduces Apache Arrow adapter and StarRocks dialect, adds support for lambda expressions in SQL and ‘Must-filter’ columns. For table function calls it is now possible to use them without TABLE() wrapper in FROM. Furthermore, there is support for optional FORMAT of CAST operator from SQL:2016 and more than 15 new SQL functions in various libraries such as BigQuery, PostgreSQL and Spark. Besides releases, it's worth to mention that Julian Hyde presented "Measures in SQL" both in SF Distributed Systems Meetup in downtown SF on Wednesday May 22nd, and SIGMOD 2024 conference in Santiago, Chile, which has been implemented in Calcite. ## Community Health: The community maintains a healthy status, previously it's super healthy. The reason is that we did not invite new committers for more than 6 months. There are a few new faces in the community, hopefully we'll invite new committers in the near future. Most of the statistics slightly decreased compared to last quarter (dev@ decreased by 39%, issues@ decreased by 22%, commits decreased by 31%, code contributors decreased by 32%, active reviewers decreased by 36.8%). The reason I can see is there is less activity in supporting new SQL functions in variaous libraries recently, which is much more active in previous quaters. The number of non-committer (contributor) commits per month: +------+-------+---------------------+ | year | month | contributor_commits | +------+-------+---------------------+ | 2024 | 4 | 13 | | 2024 | 5 | 11 | | 2024 | 6 | 15 | +------+-------+---------------------+ The number of active reviewers per month: +------+-------+------------------+ | year | month | active_reviewers | +------+-------+------------------+ | 2024 | 4 | 5 | | 2024 | 5 | 4 | | 2024 | 6 | 3 | +------+-------+------------------+ Top reviewers in the last 3 months: +----------------------------------+---------+ | committer | reviews | +----------------------------------+---------+ | Mihai Budiu <mbudiu@feldera.com> | 19 | | NobiGo <nobigogle@gmail.com> | 9 | | Julian Hyde <jhyde@apache.org> | 3 | +----------------------------------+---------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (8 years ago) There are currently 74 committers and 28 PMC members in this project. The Committer-to-PMC ratio is roughly 5:2. Community changes, past quarter: - Sergey Nuyanzin was added to the PMC on 2024-03-05 - No new committers. Last addition was Hongyu Guo on 2023-11-03. It's worth mentioning that a few people in Calcite PMC have been invited as ASF members this year: - Benchao Li - Francis Chuang - Ruben Quesada Lopez - Sergey Nuyanzin ## Project Activity: There is no release rolled out in Q1 yet, but we have planned to release avatica 1.25.0 and calcite 1.37.0 lately. For now, avatica 1.25.0 RC0 is in voting stage, and calcite 1.37.0 will be kicked off just after avatica 1.25.0 is released since we have a few co-related issues for these two versions. ## Community Health: The community maintains a super healthy status, due to the new invitation of PMC member, previously it's healthy. Most of the statistics are steady compared to last quarter, except a slight decrease for the last three weeks. I assume the reason would be that we are in the process of calcite 1.37.0 release.It's a little bit longer than usual, the reason is that we have a few co-related issues for calcite and avatica, and we need to release avatica before calcite. The number of non-committer (contributor) commits per month: +------+-------+---------------------+ | year | month | contributor_commits | +------+-------+---------------------+ | 2024 | 1 | 20 | | 2024 | 2 | 20 | | 2024 | 3 | 14 | +------+-------+---------------------+ The number of active reviewers per month: +------+-------+------------------+ | year | month | active_reviewers | +------+-------+------------------+ | 2024 | 1 | 6 | | 2024 | 2 | 7 | | 2024 | 3 | 6 | +------+-------+------------------+ Top reviewers in the last 3 months: +---------------------------------------+---------+ | committer | reviews | +---------------------------------------+---------+ | hongyu guo <guohongyu217@gmail.com> | 15 | | Mihai Budiu <mbudiu@feldera.com> | 13 | | Tanner Clary <tannerclary@google.com> | 10 | +---------------------------------------+---------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (8 years ago) There are currently 74 committers and 27 PMC members in this project. The Committer-to-PMC ratio is roughly 5:2. Community changes, past quarter: - No new PMC members. Last addition was Benchao Li on 2023-01-27. - Hongyu Guo was added as committer on 2023-11-03 - Runkang He was added as committer on 2023-11-03 - Lei Shen was added as committer on 2023-11-01 - Mihai Budiu was added as committer on 2023-10-26 - Ran Tao was added as committer on 2023-10-28 Following our yearly rotation tradition, the PMC has elected a new chair: Benchao Li. ## Project Activity: Apache Calcite 1.36.0 was released on 2023-11-10. It contains contributions from 30 contributors, and resolves 125 issues. The new release adds 30 new SQL functions in various libraries such as BigQuery and Spark, contains many improvements hardening TABLESAMPLE, integrates SQL Logic Test suite, and many more core improvements such as the support of recursive WITH and CREATE TABLE ... LIKE DDL. Apache Calcite Avatica 1.24.0 was released on 2023-12-04. It features mostly dependency upgrades with some minor bug fixes and features, and contains a breaking change: due to CALCITE-5678, date literals not satisfying the Gregorian calendar will be rejected. Apache Calcite Avatica Go 5.3.0 was released on 2023-12-11. It is a maintenance release of Avatica Go including dependency updates and bug fixes. This release supports Go 1.20 and 1.21, which are currently the versions supported and maintained by the Go team. ## Community Health: The community maintains a healthy status. Mailing list and JIRA activity has slightly dropped (dev@ -4%, issues@ -36%, JIRA opened -47%, JIRA closed -33%) due to the holiday of Chrismas and New Year. However, commit (+52%) and PRs closed(+27%) has increased on the contrary, one reason is we have many commits/PRs testing the unstable test problem in CALCITE-6123, another reason is some new contributors are used to opening and closing the PR repeatedly. The number of non-committer (contributor) commits per month: +------+-------+---------------------+ | year | month | contributor_commits | +------+-------+---------------------+ | 2023 | 10 | 35 | | 2023 | 11 | 21 | | 2023 | 12 | 13 | +------+-------+---------------------+ The number of active reviewers per month: +------+-------+------------------+ | year | month | active_reviewers | +------+-------+------------------+ | 2023 | 10 | 8 | | 2023 | 11 | 12 | | 2023 | 12 | 6 | +------+-------+------------------+ Top reviewers in the last 3 months: +--------------------------------------+---------+ | committer | reviews | +--------------------------------------+---------+ | Jiajun <jiajunbernoulli@foxmail.com> | 11 | | Julian Hyde <jhyde@apache.org> | 11 | | Mihai Budiu <mbudiu@feldera.com> | 9 | +--------------------------------------+---------+ The number of non-committer commits and active reviewers are slightly decreased compared to Q3 due to the holidays, but the number is still very good compared to times before 2023 Q2.
WHEREAS, the Board of Directors heretofore appointed Stamatis Zampetakis (zabetak) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Stamatis Zampetakis from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Benchao Li (libenchao) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Stamatis Zampetakis is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Benchao Li be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7A, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: Current project status: ongoing Issues for the board: none ## Membership Data: Apache Calcite was founded 2015-10-22 (8 years ago) There are currently 69 committers and 27 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - No new PMC members. Last addition was Benchao Li on 2023-01-27. - TJ Banghart was added as committer on 2023-07-04 - Dan Zou was added as committer on 2023-07-04 ## Project Activity: Apache Calcite 1.35.0 was released on 2023-07-26. It contains contributions from 36 contributors, and resolves 140 issues. The new release has many improvements in the BigQuery and Spark dialect bringing in more than 40 SQL functions. Additionally, it comes with new optimizations for reducing the size of generated code and more powerful expression simplifications. On August 18, 2023, Benchao Li and Jiajun Xie represented the Calcite community at the Apache Con East Asia by giving talks related with the project. ## Community Health: The project is healthy. Previously, it was super healthy. The drop is likely to the fact that the PMC has not grown in the last six months but this will very likely change in the near future since a lot of our current committers are very involved with the project and hopefully they will join the PMC shortly. The dev list had a 38% in activity in the past quarter, with busiest threads been as usual those around releases and introduction of new committers. The 16% increase in activity of the JIRA also contributes to the general increase in traffic of the dev list. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2023 | 7 | 16 | | 2023 | 8 | 32 | | 2023 | 9 | 32 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2023 | 7 | 9 | | 2023 | 8 | 9 | | 2023 | 9 | 10 | +---------------------+---------------------+---------------------+ Top-3 reviewers in the last quarter: +--------------------------------------+---------------------+ | committer | reviews | +--------------------------------------+---------------------+ | Jiajun <jiajunbernoulli@foxmail.com> | 15 | | Julian Hyde <jhyde@apache.org> | 13 | | Benchao Li <libenchao@gmail.com> | 11 | +--------------------------------------+---------------------+ The number of non-committer commits has increased by 9% from the last quarter (73 commits in Q2 vs. 80 commits in Q3) keeping up the good momentum of having new people contributing to the project. The average number of active reviewers per month has increased slightly from the last quarter (7.6 in Q2 vs. 9.3 in Q3) showing that more people are participating in the review process which is among the main points of the project. In the top reviewers, we can observe that things are a bit more balanced in Q3. The review count per person in the top-3 tier is lower than usual but in conjunction with the increase in number of non-committer commits it shows that reviews are more evenly distributed among the members of the community.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Project Status: Current project status: ongoing Issues for the board: none ## Membership Data: Apache Calcite was founded 2015-10-22 (8 years ago) There are currently 67 committers and 27 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - No new PMC members. Last addition was Benchao Li on 2023-01-27. - Jacky Lau was added as committer on 2023-06-28 - Oliver Lee was added as committer on 2023-06-13 - Tanner Clary was added as committer on 2023-05-25 - Zhe Hu was added as committer on 2023-06-28 ## Project Activity: There were no releases during this quarter. The last release was Apache Calcite 1.34.0 on 2023-03-14. We are actively working towards Apache Calcite 1.35.0 and we plan to release the new version during July 2023. On 2023-06-29, the Calcite community organised a Virtual key signing party for expanding the Web of trust and empowering the cryptographic signatures of our members and future release managers. 4 PMC members and 2 committers attended the event. ## Community Health: The project remains super healthy. The traffic in JIRA, GitHub, issues@, commits, has increased overall, while dev@ has dropped by 18%. During this quarter there were more discussions and exchanges under specific issues/tickets shifting the traffic from dev@ to issues@ and other places. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2023 | 4 | 17 | | 2023 | 5 | 21 | | 2023 | 6 | 35 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2023 | 4 | 6 | | 2023 | 5 | 6 | | 2023 | 6 | 11 | +---------------------+---------------------+---------------------+ Top-3 reviewers in the last quarter: +-----------+---------------------+ | committer | reviews | +-----------+---------------------+ | Julian Hyde <jhyde@apache.org> | 28 | | Benchao Li <libenchao@gmail.com> | 12 | | rubenada <rubenql@gmail.com> | 8 | | Jiajun <jiajunbernoulli@foxmail.com> | 8 | +-----------+---------------------+ The number of non-committer commits has increased roughly by 43% from the last quarter (51 commits in Q1 vs. 73 commits in Q2) which is promising for inviting new committers in the near term. The number of active reviewers increased slightly compared to the last quarter with June being the most active month for everyone. The preparation for the 1.35.0 release and the call for action did help in bringing those numbers up during June. In terms of sharing the review load things are a bit better this quarter but still far from being completely balanced. There have been discussions around the topic in the last quarter but we obviously need more involvement from the community members.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (7 years ago) There are currently 63 committers and 27 PMC members in this project. The Committer-to-PMC ratio is 7:3. Community changes, past quarter: - Benchao Li was added to the PMC on 2023-01-27 - Alex Plehanov was added as committer on 2023-01-06 - Jiajun Xie was added as committer on 2023-02-10 - Istvan Toth was added as committer on 2023-01-25 ## Project Activity: Apache Calcite 1.34.0 was released on 2023-03-14. It contains contributions from 18 contributors, and resolves 34 issues. It’s worth highlighting the introduction of QUALIFY clause (CALCITE-5268), which facilitates filtering the results of window functions. Among other improvements and fixes, it adds roughly 15 new functions in BigQuery library for handling dates, times, and timestamps. Apache Calcite 1.33.0 was released on 2023-02-06. It contains contributions from 33 contributors, and resolves 107 issues. It’s worth highlighting the support for custom time frames (CALCITE-5155), the new MEASURE type and AGGREGATE aggregate function (CALCITE-5105) as well as the many improvements to the BigQuery dialect (CALCITE-5180). Apache Calcite Avatica 1.23.0 was released on 2023-01-19. It fixes bugs in Statement.getUpdateCount(), ResultSet.getObject; and supports HTTP_BAD_REQUEST and configuring fetch size and SSL key-store type. Also, there are various improvements to DateTimeUtils and ByteString. On 2023-03-15, there was an online meetup of the Calcite community with approximately 50 participants joining the call. We had three very interesting presentations around adding measures in SQL, incremental view maintenance for streaming engines, and debugging planner issues, followed by open discussion. The videos from the meetup as well as the slides were published online shortly after the event. ## Community Health: The project remains super healthy and there is a general increase in traffic almost in every aspect of the project (dev@, JIRA, and GitHub). The most notable increase in traffic was for dev mailing list (46%). One factor that led to this increase is the addition of four new members in the project and the traditional welcoming emails that usually come along. Another one, would probably be the various discussion/votes around releases; we had more this quarter compared to our usual cadence. Last there were also some changes in the CI (SonarCloud intergration) that sparked some additional exchanges. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2023 | 1 | 20 | | 2023 | 2 | 15 | | 2023 | 3 | 17 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2023 | 1 | 4 | | 2023 | 2 | 5 | | 2023 | 3 | 4 | +---------------------+---------------------+---------------------+ Top-3 reviewers in the last quarter: +-----------------------------------------+---------------------+ | committer | reviews | +-----------------------------------------+---------------------+ | Julian Hyde <jhyde@apache.org> | 34 | | Benchao Li <libenchao@gmail.com> | 9 | | Stamatis Zampetakis <zabetak@gmail.com> | 4 | +-----------------------------------------+---------------------+ The number of non-commiter commits has almost doubled in the last quarter which is a good thing. Unfortunately the number of active reviewers is still pretty low and few individuals namely Julian Hyde, and Benchao Li are pulling almost all the weight of reviewing contributors work.
WHEREAS, the Board of Directors heretofore appointed Ruben Q L (rubenql) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Ruben Q L from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Stamatis Zampetakis (zabetak) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Ruben Q L is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Stamatis Zampetakis be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7A, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (7 years ago) There are currently 60 committers and 26 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - No new PMC members. Last addition was Andrei Sereda on 2022-08-08. - Bertil Chapuis was added as committer on 2022-10-14 - Dmitry Sysolyatin was added as committer on 2022-11-07 Following our yearly rotation tradition, the PMC has elected a new chair: Stamatis Zampetakis. This is the first time that a previous chair has been re-elected. ## Project Activity: There has been no Apache Calcite releases in this quarter. The next one (1.33.0) is currently being discussed and its scope is being finalized, so it should be released soon. Apache Calcite Avatica Go 5.2.0 was released on 2022-10-13. This is a maintenance release of Avatica Go with some dependency updates, bug fixes and a new minor feature. This release supports Go 1.18 and 1.19, which are currently the versions supported and maintained by the Go team. ## Community Health: The community maintains a healthy status. There has been a generalized increment in all the metrics regarding the project activity (137% increase in traffic in the dev mailing list, 55% increase in opened issues in Jira, 78% increase in closed issues, 62% increase in commits, 50% increase in code contributors, 36% increase in opened PRs in GitHub, 69% increase in closed PRs). This is somehow expected after the slight decrease in the previous quarter due to the summer vacation, but nevertheless it confirms the positive trend on Calcite community health and project contributions. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2022 | 10 | 10 | | 2022 | 11 | 11 | | 2022 | 12 | 11 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2022 | 10 | 4 | | 2022 | 11 | 6 | | 2022 | 12 | 4 | +---------------------+---------------------+---------------------+ Top reviewers in the last 3 months: +-----------------------------------------------------------+---------+ | committer | reviews | +-----------------------------------------------------------+---------+ | Benchao Li <libenchao@gmail.com> | 13 | | Julian Hyde <jhyde@apache.org> | 6 | | rubenada <rubenql@gmail.com> | 4 | | Alessandro Solimando <alessandro.solimando@gmail.com> | 4 | | Jess Balint <jbalint@gmail.com> | 2 | | Dmitry Sysolyatin <sysolyatin.dima@yandex.ru> | 1 | | Volodymyr Vysotskyi <vvovyk@gmail.com> | 1 | | Stamatis Zampetakis <zabetak@gmail.com> | 1 | +-----------------------------------------------------------+---------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (7 years ago) There are currently 58 committers and 26 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - Andrei Sereda was added to the PMC on 2022-08-08 - Jing Zhang was added as committer on 2022-07-04 - Benchao Li was added as committer on 2022-07-04 ## Project Activity: Apache Calcite 1.31.0 was released on 2022-08-02. It contains contributions from 28 contributors, and resolves 81 issues. Among others, it is worth highlighting the following improvements: Allow table functions to be polymorphic; Support SQL hint for Filter, SetOp, Sort, Window, Values; Support parsing parenthesized joins; Derive IS NOT NULL filter for the inputs of inner join; and Firebolt dialect implementation. Apache Calcite 1.32.0 was released on 2022-09-10, with 19 issues fixed by 17 contributors. This release fixes CVE-2022-39135, an XML External Entity (XEE) vulnerability that allows a SQL query to read the contents of files via the SQL functions EXISTS_NODE, EXTRACT_XML, XML_TRANSFORM or EXTRACT_VALUE. Apart from that, it is worth highlighting that this release also replaces the ESRI spatial engine with JTS and proj4j, adds 65 spatial SQL functions including ST_Centroid, ST_Covers and ST_GeomFromGeoJSON, adds the CHAR SQL function, and improves the return type of the ARRAY and MULTISET functions. Apache Calcite Avatica 1.22.0 was released on 2022-07-28. This is a maintenance release to resolve CVE-2022-36364: Apache Calcite Avatica JDBC driver httpclient_impl connection property can be used as an RCE vector. ## Community Health: The community maintains a healthy status. There has been a generalized decrease in the Jira & Github activity in the last quarter (-14% issues opened, -27% issues closed, -25% commits, -21% code contributions, -11% PRs opened, -40% PRs closed). This is expected since many members of the community were probably on vacation during this summertime in the Northern Hemisphere. Nevertheless, the development mailing list has kept a big activity, even increasing its traffic 137% in this quarter. Is is worth mentioning that several vulnerabilities were reported in both Calcite and Avatica, and the PMC showed a great reactivity to deal with them swiftly. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2022 | 7 | 0 | | 2022 | 8 | 5 | | 2022 | 9 | 15 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2022 | 7 | 0 | | 2022 | 8 | 4 | | 2022 | 9 | 3 | +---------------------+---------------------+---------------------+ Top reviewers in the last 3 months: +-----------------------------------------+---------+ | committer | reviews | +-----------------------------------------+---------+ | Julian Hyde <jhyde@apache.org> | 9 | | Benchao Li <libenchao@gmail.com> | 7 | | Stamatis Zampetakis <zabetak@gmail.com> | 2 | | rubenada <rubenql@gmail.com> | 1 | | chunwei.lcw <chunwei.leii@gmail.com> | 1 | +-----------------------------------------+---------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. The last report got one comment from the board: "It's certainly up to you all, but please remember that these reports are published, publicly. Are you sure you want to have your names and email addresses as part of this (public) report?". There is no problem from our side. This report has been pre-approved by the Calcite community and the section with names / emails has already been part of our reports in the "community health" section for a while. We decided to add it some time ago to highlight the contributions from non-committers and the top reviewers, in order to encourage the members of the community. ## Membership Data: Apache Calcite was founded 2015-10-22 (7 years ago). There are currently 58 committers and 25 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - Chunwei Lei was added to the PMC on 2022-05-24 - Vladimir Ozerov was added to the PMC on 2022-05-24 - Jing Zhang was added as committer on 2022-07-04 - Benchao Li was added as committer on 2022-07-04 ## Project Activity: Avatica 1.21.0 was released on 2022-05-08, it was a maintenance release with dependency upgrades and added support for Oracle JDK 16 to 18. Of particular note is Log4j2 being upgrade to 2.16.0 and subsequently 2.17.0 and 2.17.1 to address CVE-2021-44228, CVE-2021-45105 and CVE-2021-44832. There has not been any Calcite release in this quarter. Calcite 1.31.0 was planned for mid-June, but it has suffered a small delay. It should be released during July. ## Community Health: The overall status of the community is healthy and stable. We are keeping the good momentum in terms of contributions and opened discussions to improve the project. This is reflected also on the statistics of Jira & GitHub activity: -1% issues opened, +9% issues closed, -9% commits, +18% code contributors, -11% PRs opened, +21% PRs closed. As usual, we struggle a bit on the PRs reviews, with some of them being opened and blocked for a while due a lack of active reviewers. This fact has triggered an interesting discussion in both the Apache Calcite and Apache Flink communities about the pros and cons of forking Calcite by the latter. Many voices from the Apache Calcite community advised against this idea, due to the elevated maintenance costs in the long term. Instead, we are discussing several ideas about how to improve our PR review situation, among them the possibility of increasing the number of reviewers by granting Calcite committership per request to people who are already ASF committers (in other projects) and have a proven record of working with Calcite (on a case by case basis to be approved by the Calcite PMC). The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2022 | 4 | 15 | | 2022 | 5 | 13 | | 2022 | 6 | 19 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2022 | 4 | 9 | | 2022 | 5 | 5 | | 2022 | 6 | 7 | +---------------------+---------------------+---------------------+ Top reviewers in the last 3 months: +--------------------------------------------------------------+---------+ | committer | reviews | +--------------------------------------------------------------+---------+ | Julian Hyde <jhyde@apache.org> | 13 | | chunwei <37774589+chunweilei@users.noreply.github.com> | 13 | | rubenada <rubenql@gmail.com> | 5 | | Stamatis Zampetakis <zabetak@gmail.com> | 4 | | chunwei.lcw <chunwei.leii@gmail.com> | 3 | | hsyuan <15352793+hsyuan@users.noreply.github.com> | 2 | | Jess Balint <jbalint@gmail.com> | 1 | | chunwei.lcw <chunwei.lcw@alibaba-inc.com> | 1 | | xzh <953396112@qq.com> | 1 | | yuzhao.cyz <yuzhao.cyz@gmail.com> | 1 | | Vladimir Ozerov <ppozerov@gmail.com> | 1 | | NobiGo <nobigogle@gmail.com> | 1 | | Alessandro Solimando <alessandro.solimando@gmail.com> | 1 | +--------------------------------------------------------------+---------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (6 years ago). There are currently 56 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. Community changes, past quarter: - No new PMC members. Last addition was Ruben Q L on 2020-08-10. - No new committers. Last addition was Alessandro Solimando on 2021-12-17. ## Project Activity: Calcite 1.30.0 was released on 2022-03-20, it contains contributions from 29 authors, and resolves 36 issues. Among others, it is worth highlighting the following: Babel parser support MySQL NULL-safe equal operator <=>; support SQL hints for temporal table join; fluent test fixtures so that dependent projects can write parser, validator and rules tests; and fix for vulnerability issue CVE-2021-27568. Apache Calcite Avatica Go 5.1.0 was released on 2022-03-27, it is a maintenance release of Avatica Go with dependency updates and some minor bug fixes. ## Community Health: The overall activity in the community has increased significantly on the dev email list, which had a 137% increase in traffic in the past quarter (841 emails compared to 354). Many of these threads were new or recently joined community members asking technical questions or requesting code reviews for their first contributions, which suggests that Apache Calcite is being used more broadly by increasingly more projects. On the contrary, the activity on Jira and Github has decreased (-36% / -34% issues opened / closed in the former; -24% / -23% PRs opened / closed in the latter). This could be explained in part by the development pause during winter vacation and/or a particularly long code freeze period that was required in order to produce several RCs before Calcite 1.30.0 was released. Apart from that, there was a small virtual key signing party; and it is being discussed to organize these events on a more regular basis to expand the web of trust within the project. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2022 | 1 | 16 | | 2022 | 2 | 10 | | 2022 | 3 | 4 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2022 | 1 | 7 | | 2022 | 2 | 5 | | 2022 | 3 | 3 | +---------------------+---------------------+---------------------+ Top reviewers in the last 3 months: +--------------------------------------------------------------+---------+ | committer | reviews | +--------------------------------------------------------------+---------+ | Julian Hyde <jhyde@apache.org> | 8 | | Stamatis Zampetakis <zabetak@gmail.com> | 8 | | NobiGo <nobigogle@gmail.com> | 6 | | Alessandro Solimando <alessandro.solimando@gmail.com> | 2 | | rubenada <rubenql@gmail.com> | 1 | | Feng Zhu <wellfengzhu@gmail.com> | 1 | | XuQianJin-Stars <forwardxu@apache.com> | 1 | | yuzhao.cyz <yuzhao.cyz@gmail.com> | 1 | | Andrei Sereda <25229979+asereda-gs@users.noreply.github.com> | 1 | | Jacques Nadeau <jacques@apache.org> | 1 | +--------------------------------------------------------------+---------+
WHEREAS, the Board of Directors heretofore appointed Haisheng Yuan (hyuan) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Haisheng Yuan from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Ruben Q L (rubenql) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Haisheng Yuan is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Ruben Q L be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7C, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-21 (6 years ago) There are currently 56 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. We are rotating the PMC chair, continuing our annual rotation tradition. Community changes, past quarter: - No new PMC members. Last addition was Ruben Q L on 2020-08-09. - Alessandro Solimando was added as committer on 2021-12-17. - Xiong Duan was added as committer on 2021-10-18. ## Project Activity: Calcite 1.28.0 was released on 2021-10-19, with new features including the UNIQUE sub-query predicate, the MODE aggregate function, PERCENTILE_CONT and PERCENTILE_DISC inverse distribution functions, an Exasol dialect for the JDBC adapter, and improvements to materialized view recognition. Calcite 1.29.0 was released on 2021-12-26, which upgrades log4j2 to 2.17.0 to fix security vulnerabilities. Calcite Avatica 1.19.0 was released on 2021-10-11, which adds support for BIT and NULL data types, fixes issues with values of type ARRAY. Calcite Avatica 1.20.0 was released on 2021-12-13, which upgrades Log4j2 to version 2.15.0 (to address CVE-2021-44228), and makes the SPNEGO protocol much more efficient. ## Community Health: The overall activity in the community has increased slightly in the past few months, specifically 20% more commits, 8% more closed PRs on GitHub. There are some discussions about the proposal of changing workflow, e.g. github issues vs JIRAs, merging Avatica with Calcite, people argued with different opinions, some of the discussions reached consensus, others merely reached a conclusion. We are still trying to learn from the situation. The number of non-committer (contributor) commits per month: +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2021 | 10 | 14 | | 2021 | 11 | 2 | | 2021 | 12 | 8 | +---------------------+---------------------+---------------------+ The number of active reviewers per month: +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2021 | 10 | 7 | | 2021 | 11 | 2 | | 2021 | 12 | 5 | +---------------------+---------------------+---------------------+ Top reviewers in the last 3 months: +-----------+---------------------+ | committer | reviews | +-----------+---------------------+ | Julian Hyde <jhyde@apache.org> | 7 | | Stamatis Zampetakis <zabetak@gmail.com> | 4 | | NobiGo <nobigogle@gmail.com> | 3 | | Jesus Camacho Rodriguez <jesusca@microsoft.com> | 3 | | rubenada <rubenql@gmail.com> | 2 | | chunwei <37774589+chunweilei@users.noreply.github.com> | 1 | | Haisheng Yuan <h.yuan@alibaba-inc.com> | 1 | | chunwei.lcw <chunwei.lcw@alibaba-inc.com> | 1 | | Wang Yanlin <1989yanlinwang@163.com> | 1 | | Jacques Nadeau <jacques@apache.org> | 1 | +-----------+---------------------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-21 (6 years ago) There are currently 53 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. Community changes, past quarter: - No new PMC members. Last addition was Ruben Q L on 2020-08-09. - No new committers. Last addition was Vladimir Ozerov on 2021-06-23. ## Project Activity: Calcite Avatica 1.19.0 was released on Oct 11, 2021. At BOSS 2021, Copenhagen, Denmark, August 16, 2021, Julian Hyde & Stamatis Zampetakis gave a tutorial about Calcite. At ApacheCon 2021, September 22, 2021, Vladimir Ozerov gave a talk on building modern SQL query optimizers with Apache Calcite. At Strange Loop 2021, September 30, 2021, Julian Hyde gave a talk on Morel, a functional query language. ## Community Health: The overall activity in the community has increased slightly in the past few months, specifically 47% more opened PRs, 25% more closed PRs on GitHub. But the number of active reviewers still remains small. Number of active reviewers per month +---------------------+---------------------+---------------------+ | year | month | active_reviewers | +---------------------+---------------------+---------------------+ | 2021 | 7 | 6 | | 2021 | 8 | 2 | | 2021 | 9 | 8 | +---------------------+---------------------+---------------------+ Top reviewers in Q3 2021 +-----------+---------------------+ | committer | reviews | +-----------+---------------------+ | Julian Hyde <jhyde@apache.org> | 14 | | Stamatis Zampetakis <zabetak@gmail.com> | 7 | | Wang Yanlin <1989yanlinwang@163.com> | 4 | | Haisheng Yuan <h.yuan@alibaba-inc.com> | 3 | | Feng Zhu <wellfengzhu@gmail.com> | 3 | | Jesus Camacho Rodriguez <jesusca@microsoft.com> | 2 | | liyafan82 <liya.fan03@gmail.com> | 2 | | Vladimir Sitnikov <sitnikov.vladimir@gmail.com> | 1 | | yuzhao.cyz <yuzhao.cyz@gmail.com> | 1 | | Haisheng Yuan <15352793+hsyuan@users.noreply.github.com> | 1 | +-----------+---------------------+
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-21 (6 years ago) There are currently 53 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. Community changes, past quarter: - No new PMC members. Last addition was Ruben Q L on 2020-08-09. - Vladimir Ozerov was added as committer on 2021-06-23. ## Project Activity: Calcite Avatica 1.18.0 was released on 2021-05-18. Calcite 1.27.0 was released on 2021-06-03, with important features such as InnoDB adapter, Three-valued logic for SEARCH operator and MergeUnion operator in Enumerable convention. On Apr 26th, we had online meeting to discuss the proposal of extending Calcite to an incremental query optimizer. ## Community Health: The overall activity in the community has slightly decreased in the past few months without this being worrisome. Specifically we have less active reviewers in the past 3 months. We need more committers to spend some time to review open pull requests. the number of non-committer (contributor) commits per month +---------------------+---------------------+---------------------+ | year | month | contributor_commits | +---------------------+---------------------+---------------------+ | 2021 | 4 | 14 | | 2021 | 5 | 4 | | 2021 | 6 | 5 | +---------------------+---------------------+---------------------+ top reviewers in the last 3 months +-----------+---------------------+ | committer | reviews | +-----------+---------------------+ | Julian Hyde <jhyde@apache.org> | 13 | | Stamatis Zampetakis <zabetak@gmail.com> | 5 | | rubenada <rubenql@gmail.com> | 1 | | amaliujia <amaliujia@163.com> | 1 | | ForwardXu <forwardxu315@gmail.com> | 1 | | yuzhao.cyz <yuzhao.cyz@gmail.com> | 1 | | liyafan82 <liya.fan03@gmail.com> | 1 | +-----------+---------------------+
## Description: The mission of Calcite is the creation and maintenance of software related to Dynamic data management framework ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-21 (5 years ago) There are currently 52 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. Community changes, past quarter: - No new PMC members. Last addition was Ruben Q L on 2020-08-09. - Liya Fan was added as committer on 2021-02-09. ## Project Activity: Avatica 1.18 is being released. Calcite 1.27.0 will be released after Avatica 1.18. On Jan 20th, we had an online meetup for Calcite community with presentations covering Calcite concepts, recent work on streams, spatial query implementation. ## Community Health: The overall activity in the community has slightly decreased in the past few months without this being worrisome. 117 JIRA tickets created and 55 JIRA tickets closed/resolved in the last 3 months, and 80 commits in the past quarter, slight decrease comparing with last quarter.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: There are currently 51 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. No new committers or PMC members were added in the last 3 months. Calcite community has the tradition of annual rotation for PMC chair, Haisheng Yuan is selected as the new PMC chair. ## Project Activity: Calcite 1.26.0 was released on 2020-10-06, with important features such as supporting SEARCH operator and Sarg literal, adding PIVOT operator in SQL, adding support for JDK 15 and Guava version 29.0-jre. On Jan 20th, there will be online meetup for Calcite community with presentations covering Calcite concepts, recent work on streams, spatial query implementation. ## Community Health: The overall activity in the community has slightly decreased in the past few months without this being worrisome. 121 issues opened in JIRA and 79 issues closed in the past quarter (40% decrease). The fewer number of design discussions and JIRA activities can be explained by the holiday season and low number of active committers. commits by non-committers +--------------+------------+----------------+---------------------+ | quarter_date | committers | non_committers | total | +--------------+------------+----------------+---------------------+ | 2020-10-01 | 118 | 36 | 154 | top-5 reviewers +---------------------+-----------+ | reviews | committer | +---------------------+-----------+ | 7 | Julian Hyde | | 7 | Stamatis Zampetakis | | 6 | Chunwei Lei | | 6 | Ruben Quesada Lopez | | 4 | Danny Chan | | 4 | Wang Yanlin |
WHEREAS, the Board of Directors heretofore appointed Stamatis Zampetakis (zabetak) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Stamatis Zampetakis from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Haisheng Yuan (hyuan) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Stamatis Zampetakis is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Haisheng Yuan be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7E, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: There are currently 51 committers and 23 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. Community changes, past quarter: - Ruben Quesada Lopez was added to the PMC on 2020-08-10 - Rui Wang was added as committer on 2020-09-07 ## Project Activity: Avatica Go 5.0.0 was released on 2020-07-16. It is a major release of Avatica Go with a number of improvements and a breaking change affecting connection metadata. Worth mentioning the support for batching query string parameters in the DSN allowing updates to the server to be executed once Close() is called on the prepared statement. Calcite 1.24.0 was released on 2020-07-24, including more than 80 resolved issues. Among those it’s worth highlighting some new features of the optimizer for more efficient search space pruning as well as the support of a new SQL dialect for Presto. Calcite 1.25.0 was released on 2020-08-22, with fewer but important features improving the parameterization of optimizer rules, adding support for new spatial functions, and interval expressions. The release also introduced a few breaking changes but so far the users seem to have embraced the changes. Members of the community gave talks at ApacheCon 2020, bringing to the surface Calcite through discussions about other projects. Although we didn’t have talks dedicated to Calcite, it is nice to receive mentions and witness the adoption of Calcite by other open source projects and people in Academia. ## Community Health: The overall activity in the community has slightly decreased in the past few months without this being worrisome. Releases occur often, the community is growing, and most of the time users' questions do not remain unanswered. The design discussions were fewer in the past quarter and people leading these efforts had quickly led them to consensus. As a result, we didn't have lengthy debates thus it's normal to see the activity of the dev@ and issues@ lists slightly decreased (5% and 9% accordingly). The number of closed issues and pull requests decreased by 19% which can be explained by the low number of active committers (~10 during this period) out of which the majority pushed mostly individual contributions. The large backlog of pull requests is an issue that we are aware of but we haven’t found an effective solution yet.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (4 years ago) There are currently 50 committers and 22 PMC members in this project. The Committer-to-PMC ratio is roughly 7:3. Community changes, past quarter: - No new PMC members. Last addition was Haisheng Yuan on 2019-11-11. - Forward Xu was added as committer on 2020-04-28 - Xing Jin was added as committer on 2020-04-28 - Vineet Garg was added as committer on 2020-04-24 - Yanlin Wang was added as committer on 2020-04-28 ## Project Activity: Avatica 1.17.0 was released on 2020-06-22. It is a small routine release that includes a few dependency updates and bug fixes. Calcite 1.23.0 was released on 2020-05-23, including more than 100 resolved issues. It includes many new futures such as an SQL dialect for ClickHouse and SESSION/HOP table functions (particularly useful for queries on streams), along with significant improvements to the optimizer reducing optimization latency up to a factor of 50x for some complex queries. ## Community Health: The overall activity on the mailing lists has increased (-7% dev@, +27% issues@) with many interesting topics some very important for the future of the project such as the redesign of the optimizer, modelling indexes, and a big refactoring of the ruleset. Regarding opened/resolved issues the things are rather balanced. We had a slight decrease in new issues (-6% JIRA, -13% GitHub) counterbalanced by a small increase in closed issues (+14% JIRA, +4% GitHub). Since we have a large backlog of PRs, the increased ratio of closed PRs/issues is a good sign. Although the number of commits has slightly decreased in the past quarter (-16%) we had more code contributors (+17%) among them some new faces which is very promising for the future of the project.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (4 years ago) There are currently 46 committers and 22 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - No new PMC members. Last addition was Haisheng Yuan on 2019-11-11. - Feng Zhu was added as committer on 2020-02-29 ## Project Activity: Avatica 1.16.0 was released in the middle of December, including numerous bug fixes and security improvements while the build system has been migrated from Maven to gradle. Calcite 1.22.0 was released at the beginning of March, including more than 250 resolved issues including long-awaited features such as support of SQL hints, important bug fixes in the core of the query planner, and many changes in build and test infrastructure. This release was the biggest in the history of the project and one of the most complicated to pull out due to the big number of contributions. Stamatis gave a talk about query planning and Calcite at the university of Cergy-Pontoise, Paris, France, in March. The audience was not aware of the existence of the project which shows that we should organize such events more often, at least in Europe, if we want to expand our community. Finally, we were informed that the SuperSQL project by Tencent uses Calcite in order to provide a unified entrance to various data platforms such as RDBMS, ElasticSearch, Hive, Flink, Spark, Presto, ClickHouse, etc. ## Community Health: Activity levels on mailing lists (-8%), git (-24%) and JIRA (opened -20%, closed -30%) have decreased in the first quarter of 2020. Most of the big changes that started during the last quarter of 2019 (and initiated a lot of activity) have been finalized and incorporated in the release of Calcite 1.22.0, making things calmer in the community. The big decrease of closed issues in JIRA may be explained by the frequency of releases that have slightly dropped. The number of active committers has also decreased the past few months, with work and family constraints getting in the middle. To the above it is worth adding the period of holidays in December and January that in general slows things down. Following the decreased activity in the lists, git, and JIRA it is normal to see the activity rates on pull requests drop (-20% opened, -31% closed) more or less for the same reasons. Although our backlog keeps increasing (~174 open pull requests), the community is very reactive commenting and reviewing almost every contribution. On the bright side, we continue to see promising contributors who are on the right track for committership.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (4 years ago). There are currently 45 committers and 22 PMC members in this project. The Committer-to-PMC ratio is roughly 2:1. Community changes, past quarter: - Danny Chen was added to the PMC on 2019-10-30. - Haisheng Yuan was added to the PMC on 2019-11-11. - Stamatis Zampetakis was appointed as PMC chair on 2019-12-18, continuing the tradition of the project of rotating the chair every year. - No new committers. Last addition was Mohamed Mohsen on 2019-09-17. ## Project Activity: Calcite 1.21.0 was released in the middle of September, including more than 100 resolved issues and maintaining a release cadence of roughly one release per quarter. Calcite 1.22.0 is under preparation and is expected to be released inside January while at the moment contains more than 230 commits and 150 resolved issues. Avatica 1.16.0 was released in the middle of December, including numerous bug fixes and security improvements while the build system has been migrated from maven to gradle. The build and test infrastructure has been modernized for both Calcite and Avatica, with the migration from maven to gradle, JUnit4 to JUnit5, and the introduction of GitHub actions as part of the CI. The changes shall improve developers experience, code quality, and protect better against regressions. Members of the project participated in ApacheCon EU on October and Flink Forward Asia on November, representing the community, and presenting talks about Calcite. Finally, the Hazelcast system has decided to adopt Calcite for query planning. ## Community Health: Activity levels on mailing lists (37%), git (40%) and JIRA (opened 15%, closed 19%) have increased significantly in the last quarter. One reason is the modernization of the build and test infrastructure for both Calcite and Avatica, which triggered many discussions and follow-up tasks. Another reason, is the changes in the roster of the PMC and open discussions about the future of the project. Last but not least, is the involvement of new people in the community bringing up new challenges and ideas for improvements. The rates of pull requests being closed and merged on Github has increased by 16%, as we work to clear our backlog. Nevertheless, the number of open pull requests is still big since the number of committers who get involved in reviews is rather small. Furthermore, there are pull requests which are stale, work in progress, or proposals that make the numbers look even bigger. On the positive side every pull request receives comments within a couple of days after being submitted and there are many which get merged without too much effort showing that the project attracts skilled developers who may turn into committers quite soon.
WHEREAS, the Board of Directors heretofore appointed Francis Chuang (francischuang) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Francis Chuang from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Stamatis Zampetakis (zabetak) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Francis Chuang is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Stamatis Zampetakis be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7A, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. ## Issues: There are no issues requiring board attention. ## Membership Data: Apache Calcite was founded 2015-10-22 (4 years ago) There are currently 45 committers and 20 PMC members in this project. The Committer-to-PMC ratio is 9:4. Community changes, past quarter: - No new PMC members. Last addition was Stamatis Zampetakis on 2019-04-13. - Julian Feinauer was added as committer on 2019-09-10 - Mohamed Mohsen was added as committer on 2019-09-18 ## Project Activity: Development and mailing list activity is steady for both Calcite and its Avatica sub-project. Calcite 1.21.0 was released in the middle of September, including more than 100 resolved issues and maintaining a release cadence of roughly one release per quarter. We are also seeing new faces on the mailing list and opening pull requests on Github. In terms of pull requests, our committers and contributors have made a lot of progress to provide feedback to open pull requests and filed issues in a timely manner. This is evidenced by the open pull requests on Github receiving comments within a couple of days after being opened. Members of the project also participated in ApacheCon NA last month, presenting 5 talks about Calcite. Finally, the Apache Ignite project has decided to adopt Calcite as its SQL execution engine, replacing H2. This is an exciting development and is a testament to the sound foundation and community the Calcite project has developed. ## Community Health: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica with a slight decrease in code contributors and commits (7% and 1% respectively). The rates of pull requests being closed and merged on Github has increased by 16%, as we work to clear our backlog and we are also seeing a 7% increase in opened pull requests. Since the last report, we have added 2 new committers, Julian Feinauer and Mohamed Mohsen. We expect further growth in these numbers as Apache Ignite works to integrate Calcite into their project, resulting in cross-pollination between the 2 projects.
## Description:
Apache Calcite is a highly customizable framework for parsing and planning
queries on data in a wide variety of formats. It allows database-like access,
and in particular a SQL interface and advanced query optimization, for data
not residing in a traditional database.
Avatica is a sub-project within Calcite and provides a framework for building
local and remote JDBC and ODBC database drivers. Avatica has an independent
release schedule and its own repository.
## Issues:
There are no issues requiring board attention at this time
## Activity:
Development and mailing list activity is steady for both Calcite and its
Avatica sub-project.
Since the last report, we have added 4 new committers and 1 new PMC member. In
terms of pull requests and mailing list participation, we are also seeing a
lot new contributors. In our last report, we also noted an improvement in the
review of pull requests by new committers as well as contributors without
committer status. We are seeing a continual improvement in this area with most
PRs receiving an initial ping from a committer or a contributor within the
first couple of days after it's been opened.
A paper illustrating the use of Calcite for streaming-SQL applications was
presented by members of the Apache Calcite team in conjunction with members of
Apache Flink and Apache Beam at SIGMOD 2019.
In terms of releases, Calcite 1.20.0 was released in late June, containing
more than 130 fixes and enhancements. This makes it one of our largest
releases ever. We also released Avatica 1.14.0 in late April, which was then
followed by 1.15.0 in mid-May, due to a regression that broke existing
behavior expected by Avatica clients. A release of Avatica-Go, 4.0.0, was also
released in the middle of May.
We are seeing continual momentum in the project and are very happy to see new
faces, both on the mailing list as well as contributing code via pull
requests. We believe this is a testament to our welcoming community as well as
the commercial applicability of the project.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both Calcite and
Avatica.
## PMC changes:
- Currently 20 PMC members.
- Stamatis Zampetakis was added to the PMC on Sat Apr 13 2019
## Committer base changes:
- Currently 43 committers.
- New commmitters:
- Chunwei Lei was added as a committer on Sat Apr 27 2019
- Danny Chen was added as a committer on Tue May 14 2019
- Ruben Q L was added as a committer on Sat Apr 27 2019
- Zhiwei Peng was added as a committer on Sat Apr 27 2019
## Releases:
- 1.20.0 was released on Mon Jun 24 2019
- avatica-1.14.0 was released on Mon Apr 29 2019
- avatica-1.15.0 was released on Mon May 13 2019
- calcite-avatica-go-4.0.0 was released on Thu May 16 2019
## JIRA activity:
- 195 JIRA tickets created in the last 3 months
- 161 JIRA tickets closed/resolved in the last 3 months
## Description:
Apache Calcite is a highly customizable framework for parsing and planning
queries on data in a wide variety of formats. It allows database-like access,
and in particular a SQL interface and advanced query optimization, for data
not residing in a traditional database.
Avatica is a sub-project within Calcite and provides a framework for building
local and remote JDBC and ODBC database drivers. Avatica has an independent
release schedule and its own repository.
## Issues:
There are no issues requiring board attention at this time
## Activity:
Development and mailing list activity is steady for both Calcite and its
Avatica sub-project.
We have been seeing a lot of new contributors open pull requests and
participating in our mailing lists to answer questions and partake in
discussions. This is most likely due to Calcite being increasingly adopted as
part of commercial offerings offered by cloud service providers as well as
being used to build internal tools. The increased participation by new
contributors is reflected in the 3 new committers we have added to the project
in the last 3 months.
In the last report, we mentioned that there were some issues with pull
requests not being reviewed in a timely manner. Over the last few months, we
have observed new contributors and non-committers reviewing open pull requests
in our repositories in conjunction with our existing committers. This is a
great improvement and we hope this will put us on the path to stop PRs from
getting too stale.
In terms of releases, Calcite 1.19.0 was released at the end of March and
includes numerous bug-fixes as well as extensive improvements in JSON query
support.
Finally, the Calcite website repository was moved to git. As a result of this
move, all of our source repositories are now using GitBox, enabling new
contributors to easily submit pull requests via Github.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both Calcite and
Avatica.
## PMC changes:
- Currently 19 PMC members.
- No new PMC members added in the last 3 months
- Last PMC addition was Kevin Risden on Mon Jul 09 2018
## Committer base changes:
- Currently 39 committers.
- New commmitters:
- Hongze Zhang was added as a committer on Tue Feb 19 2019
- Haisheng Yuan was added as a committer on Tue Mar 26 2019
- Zoltan Haindrich was added as a committer on Thu Jan 10 2019
- Stamatis Zampetakis was added as a committer on Thu Jan 31 2019
## Releases:
- 1.19.0 was released on Tue Mar 26 2019
## JIRA activity:
- 208 JIRA tickets created in the last 3 months
- 153 JIRA tickets closed/resolved in the last 3 months
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule and its own repository. ## Issues: - There are no issues requiring board attention at this time. ## Activity: Development and mailing list activity is steady for both Calcite and its Avatica sub-project. Calcite 1.18 was released towards the end of December with significant enhancements to the SQL dialect: JSON functions, linear regression functions and the WITHIN GROUP clause for aggregate functions. Avatica 1.13 was released in early December and included numerous bug fixes, upgraded dependencies and docker images for the HSQLDB flavor of Avatica. The PMC Chair was switched from Michael Mior to Francis Chuang on Dec 21 2018, following the project's tradition of rotating the PMC chair each year. We continue to have a steady amount of contributions from new and existing community members. All of our git repositories (calcite, calcite-avatica and calcite-avatica-go) were migrated to gitbox. Finally, the project received a lot of excellent contributions, but a number of them were not able to be merged into the Calcite 1.18 release due to pull requests not being reviewed in a timely manner. ## Health report: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica. ## PMC changes: - Currently 19 PMC members. - No new PMC members added in the last 3 months - Last PMC addition was Kevin Risden on Mon Jul 09 2018 ## Committer base changes: - Currently 35 committers. - No new committers added in the last 3 months - Last committer addition was Andrei Sereda at Fri Sep 14 2018 ## Releases: - 1.18.0 was released on Fri Dec 21 2018 - avatica-1.13.0 was released on Tue Dec 04 2018 - avatica-go-3.2.0 was released on Mon Sep 17 2018 ## JIRA activity: - 154 JIRA tickets created in the last 3 months - 105 JIRA tickets closed/resolved in the last 3 months
WHEREAS, the Board of Directors heretofore appointed Michael Mior (mmior) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Michael Mior from the office of Vice President, Apache Calcite, and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Francis Chuang (francischuang) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Michael Mior is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Francis Chuang be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7D, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description:
Apache Calcite is a highly customizable framework for parsing and planning
queries on data in a wide variety of formats. It allows database-like access,
and in particular, a SQL interface and advanced query optimization, for data
not residing in a traditional database.
Avatica is a sub-project within Calcite and provides a framework for building
local and remote JDBC and ODBC database drivers. Avatica has an independent
release schedule and its own repository.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
Development and mailing list activity is steady for both Calcite and its
Avatica sub-project.
Calcite 1.17.0 was released mid-July with a new multi-dialect SQL parser as
well as the use of JDK 8 features in the core. Avatica Go 3.1.0 was released
early September followed by a bugfix release shortly after.
We have continued to have a steady string of new committers with solid
contributions.
Julian Hyde attended ApacheCon on Montreal and gave two talks about Calcite.
One of these talks was part of the day-long Geospatial track sponsored by the
Open Geospatial Consortium (OGC), and triggered some good interactions with
other Apache projects that are doing Geospatial work; there seems to be
growing momentum for these projects to increase involvement with the OGC.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both Calcite and
Avatica.
## PMC changes:
- Currently 19 PMC members.
- New PMC members:
- Kevin Risden was added to the PMC on Sun Jul 08 2018
- Vova Vysotskyi was added to the PMC on Fri Jul 06 2018
## Committer base changes:
- Currently 35 committers.
- New commmitters:
- Andrei Sereda was added as a committer on Thu Sep 13 2018
- Sergey Nuyanzin was added as a committer on Mon Jul 23 2018
## Releases:
- 1.17.0 was released on Thu Jul 19 2018
- avatica-go-3.1.0 was released on Sat Sep 08 2018
- avatica-go-3.2.0 was released on Mon Sep 17 2018
- avatica-1.12.0 was released on Sun Jun 24 2018
## JIRA activity:
- 212 JIRA tickets created in the last 3 months
- 153 JIRA tickets closed/resolved in the last 3 months
## Description:
Apache Calcite is a highly customizable framework for parsing and planning
queries on data in a wide variety of formats. It allows database-like access,
and in particular a SQL interface and advanced query optimization, for data
not residing in a traditional database.
Avatica is a sub-project within Calcite and provides a framework for building
local and remote JDBC and ODBC database drivers. Avatica has an independent
release schedule and its own repository.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
Development and mailing list activity is steady for both Calcite and its
Avatica sub-project.
Avatica Go 3.0.0 was released late April with support for Avatica HSQLDB. This
is the first release of Avatica Go by the Apache Calcite project since the
code was donated. Avatica 1.12.0 was released late June. The next release of
Calcite is well underway and is expected to be completed in July.
We have continued to have a steady string of new committers and PMC members
with solid contributions. Alan Gates, an early mentor of the Calcite project
has resigned from the Calcite PMC, and is now an Emeritus PMC member. A paper
providing an overview of the Calcite project was presented by project members
at the SIGMOD 2018 conference. The talk was very well received and we hope to
continue publishing in the future.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both Calcite and
Avatica.
## PMC changes:
- Currently 19 PMC members.
- New PMC members:
- Francis Chuang was added to the PMC on Sat Apr 21 2018
- Laurent Goujon was added to the PMC on Sun Apr 22 2018
- Vova Vysotskyi was added to the PMC on Fri Jul 06 2018
- Kevin Risden was added to the PMC on Mon Jul 09 2018
## Committer base changes:
- Currently 33 committers.
- New commmitters:
- Kevin Risden was added as a committer on Wed Apr 25 2018
- Shuyi Chen was added as a committer on Tue Apr 03 2018
## Releases:
- avatica-1.12.0 was released on Sat Jun 23 2018
- avatica-go-3.0.0 was released on Thu Apr 26 2018
- 1.16.0 was released on Sun Mar 18 2018
## JIRA activity:
- 157 JIRA tickets created in the last 3 months
- 89 JIRA tickets closed/resolved in the last 3 months
## Description:
Apache Calcite is a highly customizable framework for parsing and planning
queries on data in a wide variety of formats. It allows database-like access,
and in particular a SQL interface and advanced query optimization, for data
not residing in a traditional database.
Avatica is a sub-project within Calcite and provides a framework for building
local and remote JDBC and ODBC database drivers. Avatica has an independent
release schedule and its own repository.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
Development and mailing list activity is steady for both Calcite and its
Avatica sub-project.
Avatica 1.11.0 was released early March, quickly followed by Calcite 1.16.0.
Both of these releases dropped support for JDK 7 and Avatica added support for
JDK 10. Calcite depends on this newest release of Avatica and also adds an
adapter to support Apache Geode along with improvements to the Druid and JDBC
adapters.
A paper, "Apache Calcite: A Foundational Framework for Optimized Query
Processing Over Heterogeneous Data Sources" has been accepted for publication
in SIGMOD 2018. This paper is a result of collaboration between several PMC
members and academic researchers.
We have continued to have a steady string of new committers with solid
contributions.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both Calcite and
Avatica.
## PMC changes:
- Currently 16 PMC members.
- No new PMC members added in the last 3 months
- Last PMC addition was Michael Mior on Mon Apr 03 2017
## Committer base changes:
- Currently 31 committers.
- New commmitters:
- Edmon Begoli was added as a committer on Fri Feb 09 2018
- Nishant Bangarwa was added as a committer on Wed Jan 24 2018
- Zhen Wang was added as a committer on Thu Mar 08 2018
## Releases:
- 1.16.0 was released on Sun Mar 18 2018
- avatica-1.11.0 was released on Thu Mar 08 2018
## JIRA activity:
- 117 JIRA tickets created in the last 3 months
- 96 JIRA tickets closed/resolved in the last 3 months
## Description:
Apache Calcite is a highly customizable framework for parsing and planning
queries on data in a wide variety of formats. It allows database-like access,
and in particular a SQL interface and advanced query optimization, for data
not residing in a traditional database.
Avatica is a sub-project within Calcite, and provides a framework for building
local and remote JDBC and ODBC database drivers. Avatica has an independent
release schedule, and since April 2017, it has its own independent repository.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
Development and mailing list activity is steady for both Calcite and its
Avatica sub-project.
Calcite 1.15.0, was released in December with 50 issues are fixed by 22
contributors. Some features of note are a "server" module with DDL support;
dynamic parameters in the LIMIT and OFFSET and clauses; refactoring the JDBC
adapter to make it easier to plug in a new SQL dialect; and a data profiling
algorithm, that efficiently analyzes large data sets with many columns,
estimating the number of distinct values in columns and groups of columns.
Our community continued growing this quarter, as two new committers
(Christian Beikov and Vova Vysotskyi) were added to the project.
Finally, members of the Calcite PMC along with external collaborators
submitted a paper to the industrial track of SIGMOD 2018.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both Calcite and
Avatica.
## PMC changes:
- Currently 16 PMC members.
- No new PMC members added in the last 3 months
- Last PMC addition was Michael Mior on Mon Apr 03 2017
## Committer base changes:
- Currently 28 committers.
- New commmitters:
- Christian Beikov was added as a committer on Thu Oct 12 2017
- Vova Vysotskyi was added as a committer on Thu Dec 21 2017
## Releases:
- 1.14.0 was released on Sun Oct 01 2017
- 1.15.0 was released on Sun Dec 10 2017
- Avatica 1.10.0 was released on Tue May 30 2017
## JIRA activity:
- 121 JIRA tickets created in the last 3 months
- 89 JIRA tickets closed/resolved in the last 3 months
WHEREAS, the Board of Directors heretofore appointed Jesús Camacho Rodríguez (jcamacho) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Jesús Camacho Rodríguez from the office of Vice President, Apache Calcite and WHEREAS, the Project Management Committee of the Apache Calcite project has chosen by vote to recommend Michael Mior (mmior) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Jesús Camacho Rodríguez is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Michael Mior be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7H, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite, and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule, and since April 2017, it has its own independent repository. ## Issues: - There are no issues requiring board attention at this time. ## Activity: Development and mailing list activity is steady for both Calcite and its Avatica sub-project. Since the last board meeting, there has been one Calcite release. Calcite 1.14.0 was released at the beginning of October. The release included more than 60 new features, improvements and bug fixes. Among others, the GEOMETRY data type was added along with 35 associated functions part of the OpenGIS set. Thus, projects integrating with Calcite can benefit from this initial spatial support. In addition, a new adapter for Elasticsearch5 was added. The adapter was an unexpected contribution by a new member in the community, which is representative of the benefits of open-source software development. On top of that, a cool new feature was added: the "sqlsh" command, which allows you to run SQL queries against your OS from your shell! Our community continued growing this quarter, as two new committers (Chris Baynes and Christian Beikov) were added to the project. Finally, there was an important presence of the Apache Calcite project in talks at multiple events, such as FlinkForward 2017 (Berlin, Germany) and DataWorks Summit APAC 2017 (Sydney, Australia). In addition, Calcite (as well as other Apache projects such as Flink or Kudu) was mentioned multiple times in the media in relation with the release of Uber's AthenaX project[1]. [1] https://news.ycombinator.com/item?id=15435553 ## Health report: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica. ## PMC changes: - Currently 16 PMC members. - No new PMC members added in the last 3 months - Last PMC addition was Michael Mior on Mon Apr 03 2017 ## Committer base changes: - Currently 27 committers. - Chris Baynes and Christian Beikov were added last quarter ## Releases: - 1.14.0 was released on Sun Oct 01 2017 ## JIRA activity: - 122 JIRA tickets created in the last 3 months - 70 JIRA tickets closed/resolved in the last 3 months
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite, and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule, and since April 2017, it has its own independent repository. ## Issues: - There are no issues requiring board attention at this time. ## Activity: Development and mailing list activity is steady for both Calcite and its Avatica sub-project. Since the last board meeting, there has been one Calcite release and one Avatica release. Avatica 1.10.0 was released at the end of May. As the Calcite and Avatica projects become more separate, this was the first release since Avatica’s git repository separated from Calcite’s repository during the previous quarter. The release added support for JDBC Array data, Docker, and JDK 9 (it continues to run on JDK 7 and 8). In total, there were over 20 new features and bug fixes. In turn, Calcite 1.13.0 was released at the end of June. The release included more than 75 resolved issues, comprising a large number of new features as well as general improvements and bug-fixes. Among others, Calcite was upgraded to use the recently released version of Avatica. Our community continued growing this quarter: three new committers (Slim Bouguerra, Kevin Liew, and Zhiqiang He) were added to the project. In addition, we seem to be attracting a more diverse set of contributors than usual. While typically each 100 commits has around 20 distinct contributors, the last 100 commits had 29 distinct contributors. Finally, there was an important presence of the Apache Calcite project in talks at multiple events, such as Apache: Big Data North America 2017 (Miami, FL), PhoenixCon (San Francisco, CA), and DataWorks Summit USA 2017 (San Jose, CA). ## Health report: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica. ## PMC changes: - Currently 16 PMC members. - No new PMC members added in the last 3 months - Last PMC addition was Michael Mior on Tue Apr 04 2017 ## Committer base changes: - Currently 25 committers. - New commmitters: - Slim Bouguerra was added as a committer on Sun Jun 18 2017 - Kevin Liew was added as a committer on Sun Jun 18 2017 - Zhiqiang He was added as a committer on Fri Jun 09 2017 ## Releases: - 1.13.0 was released on Mon Jun 26 2017 - avatica-1.10.0 was released on Tue May 30 2017 ## JIRA activity: - 135 JIRA tickets created in the last 3 months - 112 JIRA tickets closed/resolved in the last 3 months
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-project within Calcite, and provides a framework for building local and remote JDBC and ODBC database drivers. Avatica has an independent release schedule, and since April 2017, it has its own independent repository. ## Issues: - There are no issues requiring board attention at this time. ## Activity: Development and mailing list activity is steady for both Calcite and its Avatica sub-project. Since the last board report, there has been one Calcite release. Calcite 1.12.0 came over two months after 1.11.0 and included 95 issues solved by 29 different contributors! In addition to general bug fixes and improvements in the Calcite core, major highlights in the release include support for JDK 9 and Guava 21.0, two new adapters to allow Calcite to read data from other systems (a file adapter and an Apache Pig adapter), and extensions and improvements in the supported SQL syntax and functions. While there has not been a release of Avatica since the last board report, development is ramping down to release Avatica 1.10.0. We reached another milestone this quarter with the creation of an Avatica dedicated repository. Avatica has been slowly growing inside of Calcite for many years, and led by PMC member Josh Elser, the community took the next step to hoist the Avatica code out of the Calcite repository into its own. The community felt like this was the next logical step given the maturity of the project. As a part of this separation, the PMC is also taking this time to re-evaluate the branding of Avatica. Our community continued growing this quarter: a new PMC member (Michael Mior) and three new committers (Gian Merlino, Jess Balint, and Laurent Goujon) were added to the project. Finally, there was an important presence of the Apache Calcite project in multiple talks at events around the world, such as Apex Big Data World 2017 (Mountain View, CA) and DataWorks Summit EU 2017 (Munich, Germany). ## Health report: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica. ## PMC changes: - Currently 16 PMC members. - Michael Mior was added to the PMC on Tue Apr 04 2017 ## Committer base changes: - Currently 22 committers. - New commmitters: - Gian Merlino was added as a committer on Sat Feb 18 2017 - Jess Balint was added as a committer on Wed Feb 15 2017 - Laurent Goujon was added as a committer on Wed Feb 15 2017 ## Releases: - 1.12.0 was released on Fri Mar 24 2017 ## JIRA activity: - 178 JIRA tickets created in the last 3 months - 132 JIRA tickets closed/resolved in the last 3 months
## Description:
Apache Calcite is a highly customizable framework for parsing and
planning queries on data in a wide variety of formats. It allows
database-like access, and in particular a SQL interface and advanced
query optimization, for data not residing in a traditional database.
Avatica is a sub-module within Calcite, and provides a framework for
building local and remote JDBC and ODBC database drivers. Since March
2016, Avatica has an independent release schedule, but resides in the
same git repository.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
Development and mailing list activity is steady for both Calcite and
its Avatica sub-project. Since the last report there have been two
Calcite releases (1.10.0 and 1.11.0) and an Avatica release (1.9.0).
Interest in Calcite by other projects and developers continues to
grow, and we have recently added a new PMC member.
There was an important presence of the Apache Calcite project in
Apache: Big Data Europe 2016 (Seville, Spain). In particular, there
were six talks revolving around Apache Calcite. Topics included
streaming SQL and integration with Druid, Apache Geode and Apache
Hive.
In addition, existing adapters that allow Calcite to read data from
other systems (JDBC, Druid, Apache Cassandra) continue gaining wide
adoption and multiple parties continue contributing to their
development.
Finally, work to extend Calcite SQL capabilities and improve Calcite
core has been ongoing for the last few months, consolidating existing
code as well as adding new features.
## Health report:
Activity levels on mailing lists, git and JIRA are normal for both
Calcite and Avatica.
## PMC changes:
- Currently 15 PMC members.
- Maryann Xue was added to the PMC on Mon Jan 09 2017
## Committer base changes:
- Currently 19 committers.
- No new committers added in the last 3 months
- Last committer addition was Francis Chuang at Tue Sep 27 2016
## Releases:
- 1.10.0 was released on Wed Oct 12 2016
- 1.11.0 was released on Mon Jan 09 2017
- avatica-1.9.0 was released on Tue Nov 01 2016
## JIRA activity:
- 142 JIRA tickets created in the last 3 months
- 114 JIRA tickets closed/resolved in the last 3 months
WHEREAS, the Board of Directors heretofore appointed Julian Hyde (jhyde) to the office of Vice President, Apache Calcite, and WHEREAS, the Board of Directors is in receipt of the resignation of Julian Hyde from the office of Vice President, Apache Calcite, and WHEREAS, the Community of the Apache Calcite project has chosen to recommend Jesús Camacho Rodríguez (jcamacho) as the successor to the post; NOW, THEREFORE, BE IT RESOLVED, that Julian Hyde is relieved and discharged from the duties and responsibilities of the office of Vice President, Apache Calcite, and BE IT FURTHER RESOLVED, that Jesús Camacho Rodríguez be and hereby is appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors. and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed. Special Order 7B, Change the Apache Calcite Project Chair, was approved by Unanimous Vote of the directors present.
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-module within Calcite, and provides a framework for building local and remote JDBC and ODBC database drivers. Since March 2016, Avatica has an independent release schedule, but resides in the same git repository. ## Issues: - I (Julian Hyde) have decided to step down as PMC chair, because I believe that a rotating chair fosters a strong community. The PMC has voted on a replacement, and is recommending Jesús Camacho Rodríguez as new PMC chair. (See Special Orders 7B). - This is my last Board report for the project; I'd like to thank the Board for their support and trust. ## Activity: Calcite became a top-level project exactly one year ago. On graduation, the community decided not to adopt bylaws, but to have a "state of the project" discussion each year, and to rotate the PMC chair yearly if possible. We have been having this discussion, achieved consensus on Jesús Camacho Rodríguez as a candidate for PMC chair, confirmed in a private PMC vote. Some of the other feedback during the discussion included: - Satisfaction with the pace of the project, and its ablity to "fan out" to cover diverse areas of interest (some of practical use to production systems, some of them more experimental); - A sense that Avatica is still doing OK as a sub-project (that is, it is not yet time to consider TLP status), but needs to be factored into its own git repo; - A thirst for documentation to make it easier for casual users to use Calcite. Development and mailing list activity is steady for both Calcite and its Avatica sub-project. There has been one release of Calcite, with another currently under vote, and no releases of Avatica. Julian Hyde gave a talk at FlinkForward (Berlin); three community members (including the proposed new PMC chair) will be giving talks about Calcite or mentioning Calcite at Apache: Big Data in Seville in November. ## Health report: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica. ## PMC changes: - Currently 14 PMC members. - No new PMC members added in the last 3 months - Last PMC addition was Josh Elser on Wed Feb 17 2016 ## Committer base changes: - Currently 19 committers. - New commmitters: - Francis Chuang was added as a committer on Tue Sep 27 2016 - Milinda Pathirage was added as a committer on Tue Jul 12 2016 - MinJi Kim was added as a committer on Sun Sep 04 2016 ## Releases: - 1.9.0 was released on Wed Sep 21 2016
## Description: Apache Calcite is a highly customizable framework for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Avatica is a sub-module within Calcite, and provides a framework for building local and remote JDBC and ODBC database drivers. Since March 2016, Avatica has an independent release schedule. ## Issues: - There are no issues requiring board attention at this time. ## Activity: Development and mailing list activity is steady for both Calcite and its Avatica sub-project, and since the last report there has been one release of each. Our strategy, in Avatica, of creating a language-agnostic wire protocol is paying off: 3 new Avatica clients have been added in ASL-but-not-ASF projects (in Go, .NET and Python). They are intended for Apache Phoenix Query Server but can be re-used for other back-ends. Interest in streaming SQL continues to grow. We are starting to work with Apache Beam (incubating) and Apache Apex, and continue to work with Apache Flink, Apache Samza and Apache Storm. Adapters for Druid and Elasticsearch have been contributed. Talks at ApacheCon BigData (Vancouver), Hadoop Summit (Dublin and San Jose), Kafka Summit (San Francisco), XLDB (Palo Alto), Hortonworks User Group (Herndon, Virginia); and a combined talk with Apache Phoenix at Hadoop Summit (San Jose). Topics include streaming SQL, Avatica, and integration with Apache Phoenix. ## Health report: Activity levels on mailing lists, git and JIRA are normal for both Calcite and Avatica. Our change, last quarter, to notify the dev list each time a JIRA was created seems to be an improvement. ## PMC changes: - Currently 14 PMC members (no additions since last report) - Last PMC addition was Josh Elser on Wed Feb 17 2016 ## Committer base changes: - Currently 16 committers (one addition since last report) - Michael Mior was added on Sun Apr 03 2016 ## Releases: - 1.8.0 was released on Mon Jun 13 2016 - avatica-1.8.0 was released on Fri Jun 03 2016
## Description Apache Calcite is a highly customizable engine for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Calcite graduated from the Apache Incubator on October 21, 2015. Avatica is a sub-module within Calcite, and provides a framework for building local and remote JDBC and ODBC database drivers. Since March 2016, Avatica has an independent release schedule. ## Issues: - There are no issues requiring board attention at this time. ## Activity: - Avatica split Avatica became an independently released module. Previously the 4 Avatica artifacts were released as part of Calcite, but now releases and release numbers are decoupled from Calcite releases. Avatica has its own section of the web site, http://calcite.apache.org/avatica/. Our motivation is that other projects (e.g. Apache Phoenix's Query Server) depend only on Avatica, and are likely to require maintenance releases. Also, Avatica does not depend on Calcite, and the perception that it has few dependencies will improve adoption. Avatica is still governed by the Calcite PMC, and developed using the same git repo and dev list. Communities are diverging slightly, but there is still significant overlap. - A new adapter for Apache Cassandra - Talks * Julian Hyde spoke about Streaming SQL & Calcite at an Apache Samza meetup (Mountain View) on Feb 17. * Julian Hyde and James Taylor presented a Developer Showcase at Strata conference (San Jose) on Mar 30. * Upcoming talks at ApacheCon BigData (Vancouver), Hadoop Summit (Dublin), Kafka Summit (San Francisco), XLDB (Palo Alto), Hortonworks User Group (Herndon, VA). ## Health report: - Mailing lists are a little above typical levels (585 emails on dev) - JIRA at typical levels (141 created, 116 closed) - The community wants to try to keep the volume on the dev list at reasonable levels. During this quarter, we decided to post each created JIRA case to the dev list in the hope that this would drive discussions from dev onto JIRA cases, and thereby reduce dev volume. ## PMC changes: - Currently 14 PMC members. - Josh Elser was added to the PMC on Wed Feb 17 2016 ## Committer base changes: - Currently 15 committers. - Wei (Maryann) Xue was added as a committer on Sun Nov 08 2015 ## Releases: - 1.6.0 was released on Fri Jan 22 2016 - 1.7.0 was released on Tue Mar 22 2016 - avatica-1.7.0 was released on Sun Mar 13 2016 - avatica-1.7.1 was released on Wed Mar 16 2016
## Description
Apache Calcite is a highly customizable engine for parsing and
planning queries on data in a wide variety of formats. It allows
database-like access, and in particular a SQL interface and advanced
query optimization, for data not residing in a traditional database.
As a framework, Calcite’s audience is fairly small, consisting
mainly of developers building data engines (Drill, Phoenix, Hive for
example) but also streaming engines such as Samza, and some
commercial engines using Calcite for query planning and its Avatica
JDBC layer.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
- New alliances with streaming projects:
- Storm committed initial SQL support based on Calcite;
- Flink announced plans to use Calcite develop a SQL interface for
both streaming and traditional queries.
- Release schedule a bit slow due to the holidays, but 1.6 will
probably happen mid-January.
- List, JIRA, and commit activity are about above average.
## PMC changes:
- Currently 13 PMC members.
- No new PMC members added in the last 3 months
## Committer base changes:
- Currently 11 committers.
- New commmitters:
- Josh Elser was added as a committer on Sun Nov 08 2015
- Wei Xue was added as a committer on Sun Nov 08 2015
## Releases:
- 1.5.0 was released on Mon Nov 09 2015
## Mailing list activity:
- dev@calcite.apache.org:
- 145 subscribers (up 18 in the last 3 months):
- 493 emails sent to list (373 in previous quarter)
- issues@calcite.apache.org:
- 12 subscribers (up 1 in the last 3 months):
- 1170 emails sent to list (926 in previous quarter)
## JIRA activity:
- 131 JIRA tickets created in the last 3 months
- 107 JIRA tickets closed/resolved in the last 3 months
## Description
Apache Calcite is a highly customizable engine for parsing and
planning queries on data in a wide variety of formats. It allows
database-like access, and in particular a SQL interface and advanced
query optimization, for data not residing in a traditional database.
As a framework, Calcite’s audience is fairly small, consisting
mainly of developers building data engines (Drill, Phoenix, Hive for
example).
Calcite graduated from the Apache Incubator on October 21, 2015.
Since graduation, we have completed the transition incubating to
top-level infrastructure, appointed two new committers, and made one
release.
## Issues:
- There are no issues requiring board attention at this time.
## Activity:
- 1 release since the last report in November.
- We fixed the branding issues mentioned in the last report; the web
site now complies with the branding guidelines.
- List, JIRA, and commit activity are at or above average.
- Release 1.5 took a bit longer than average; we expect release 1.6
will be on the shorter side. This release has no grand goals, but
contributors are contributing improvements in their own particular
areas of interest: improved constant reduction, streaming, support
for sequences are examples.
## PMC changes:
- Currently 13 PMC members.
- No new PMC members added since graduation
## Committer base changes:
- Currently 11 committers.
- New committers:
- Josh Elser was added as a committer on Sun Nov 08 2015
- Wei (Maryann) Xue was added as a committer on Sun Nov 08 2015
## Releases:
- 1.5.0 was released on Mon Nov 09 2015
## Mailing list activity:
- dev@calcite.apache.org:
- 139 subscribers (up 21 in the last 3 months):
- 487 emails sent to list (390 in previous quarter)
- issues@calcite.apache.org:
- 11 subscribers (up 1 in the last 3 months):
- 1142 emails sent to list (853 in previous quarter)
## JIRA activity:
- 131 JIRA tickets created in the last 3 months
- 106 JIRA tickets closed/resolved in the last 3 months
Calcite is a highly customizable engine for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. As a framework, Calcite’s audience is fairly small, consisting mainly of developers building data engines (Drill, Phoenix, Hive for example). Calcite graduated from the Apache Incubator on October 21, 2015. We have completed the transition incubating to top-level infrastructure. We aim to release on about a monthly schedule, although it often slips to bi-monthly. The last release was 1.4 (incubating) in September and we will release 1.5 this month, with about 100 JIRAs fixed. No committers or PMC members appointed since graduation. Mailing list, JIRA and git commit activity are at an all-time high (in October there were 46 commits from 12 contributors, 42 issues created, 49 issues resolved, 168 mails on the dev list (which does not include commits or jira traffic)). There is a steady flow of patches, and there seems to be an up-tick in inquiries into novel uses of the project since graduation. We are investigating whether we are compliant with Apache branding guidelines.
WHEREAS, the Board of Directors deems it to be in the best interests of the Foundation and consistent with the Foundation's purpose to establish a Project Management Committee charged with the creation and maintenance of open-source software, for distribution at no charge to the public, related to parsing and planning queries on data in a wide variety of formats. NOW, THEREFORE, BE IT RESOLVED, that a Project Management Committee (PMC), to be known as the "Apache Calcite Project", be and hereby is established pursuant to Bylaws of the Foundation; and be it further RESOLVED, that the Apache Calcite Project be and hereby is responsible for the creation and maintenance of software related to parsing and planning queries on data in a wide variety of formats; and be it further RESOLVED, that the office of "Vice President, Apache Calcite" be and hereby is created, the person holding such office to serve at the direction of the Board of Directors as the chair of the Apache Calcite Project, and to have primary responsibility for management of the projects within the scope of responsibility of the Apache Calcite Project; and be it further RESOLVED, that the persons listed immediately below be and hereby are appointed to serve as the initial members of the Apache Calcite Project: * Alan Gates <gates at apache dot org> * Aman Sinha <amansinha at apache dot org> * Ashutosh Chauhan <hashutosh at apache dot org> * James R. Taylor <jamestaylor at apache dot org> * Jacques Nadeau <jacques at apache dot org> * Jesús Camacho Rodríguez <jcamacho at apache dot org> * Jinfeng Ni <jni at apache dot org> * John Pullokkaran <jpullokk at apache dot org> * Julian Hyde <jhyde at apache dot org> * Nick Dimiduk <ndimiduk at apache dot org> * Steven Noels <stevenn at apache dot org> * Ted Dunning <tdunning at apache dot org> * Vladimir Sitnikov <vladimirsitnikov at apache dot org> NOW, THEREFORE, BE IT FURTHER RESOLVED, that Julian Hyde be appointed to the office of Vice President, Apache Calcite, to serve in accordance with and subject to the direction of the Board of Directors and the Bylaws of the Foundation until death, resignation, retirement, removal or disqualification, or until a successor is appointed; and be it further RESOLVED, that the Apache Calcite Project be and hereby is tasked with the migration and rationalization of the Apache Incubator Calcite podling; and be it further RESOLVED, that all responsibilities pertaining to the Apache Incubator Calcite podling encumbered upon the Apache Incubator Project are hereafter discharged. Special Order 7E, Establish the Apache Calcite Project, was approved by Unanimous Vote of the directors present.
Calcite is a highly customizable engine for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. (Renamed from Optiq on 2014-09-30.) Calcite has been incubating since 2014-05-19. Three most important issues to address in the move towards graduation: 1. Hold a graduation vote 2. 3. Any issues that the Incubator PMC (IPMC) or ASF Board wish/need to be aware of? None How has the community developed since the last report? In August, there were 122 messages on dev@, 28 commits, 46 issues created, 22 issues resolved by 8 contributors. We released 1.4, the first release for which Julian Hyde was not release manager. Collaborations with Apache projects (Phoenix, Samza, Kylin, Hive, Drill) continue. We are discussing graduation, and will move to a vote shortly. How has the project developed since the last report? Released 1.4. Date of last release: 2015-09-02 apache-calcite-1.4.0-incubating When were the last committers or PMC members elected? 2015-04-24 5 new committers 2014-12-31 1 new PPMC member Signed-off-by: [ ](calcite) Ted Dunning [X](calcite) Alan Gates [ ](calcite) Steven Noels
Calcite is a highly customizable engine for parsing and planning queries on
data in a wide variety of formats. It allows database-like access, and in
particular a SQL interface and advanced query optimization, for data not
residing in a traditional database. (Renamed from Optiq on 2014-09-30.)
Calcite has been incubating since 2014-05-19.
Three most important issues to address in the move towards graduation:
1. Add more PPMC members.
2. Demonstrate community robustness by rotating project tasks among
multiple project members.
3. There is no third thing. We are almost ready to graduate.
Any issues that the Incubator PMC (IPMC) or ASF Board wish/need to be aware
of?
None.
How has the community developed since the last report?
The last report was in April. (We are reporting a month late, because
we missed the July report.)
In July, there were 148 messages on dev@, 37 commits, 44 issues
created, 39 issues resolved by 10 contributors.
Diversity is improving. The 1.4 release will be the first release for
which Julian Hyde was not release manager.
Julian Hyde won best lightning talk at XLDB 2015 in May with the talk
"Apache Calcite: One planner fits all".
Tom Barber spoke about Calcite at ApacheCon NA in April.
Collaborations with other Apache projects continue:
* Phoenix has built a remote JDBC driver using Calcite’s Avatica
component.
* Phoenix is replacing their SQL parser & planner with Calcite.
* Samza is developing support for streaming SQL queries using
Calcite for parsing and planning.
* Kylin upgraded from 0.9.2 to 1.3.
* Collaboration with Hive and Drill continues.
How has the project developed since the last report?
We completed releases 1.2 and 1.3, and are preparing 1.4.
Date of last release:
2015-05-30 apache-calcite-1.3.0-incubating
When were the last committers or PMC members elected?
2015-04-24 5 new committers
2014-12-31 1 new PPMC member
Signed-off-by:
[X](calcite) Ted Dunning
[X](calcite) Alan Gates
[X](calcite) Steven Noels
Shepherd/Mentor notes:
Ted Dunning:
This is turning into a serious community. They should consider
graduation.
johndament:
Podling seems to be in good shape. They may want to consider
beginning the graduation process.
Calcite is a highly customizable engine for parsing and planning queries on
data in a wide variety of formats. It allows database-like access, and in
particular a SQL interface and advanced query optimization, for data not
residing in a traditional database. (Renamed from Optiq on 2014-09-30.)
Calcite has been incubating since 2014-05-19.
Three most important issues to address in the move towards graduation:
1. Continue to build community
2. Add more committers and PPMC members
3. Demonstrate community robustness by rotating project tasks among
multiple project members
Any issues that the Incubator PMC (IPMC) or ASF Board wish/need to be
aware of?
None.
How has the community developed since the last report?
In March, there were 159 messages on dev@, 41 commits, 52 issues
created, 37 issues resolved by 8 contributors.
Julian Hyde gave a talk “Why you care about relational algebra (even
though you didn’t know it)" about Calcite at Enterprise Data World in
March. He also spoke at a Phoenix meet-up in San Francisco about
Phoenix-Calcite integration.
Collaborations are under way with other Apache projects:
* Phoenix is going to use Calcite for SQL parsing and planning; and a
separate project is using Calcite’s Avatica component to build a remote
JDBC driver.
* Added support for parsing/validating streaming SQL and collaborating
with the Samza project on adding streaming SQL to Samza.
* Collaboration with Hive and Drill continues.
How has the project developed since the last report?
We completed our milestone 1.0 release, continued our monthly release
tempo with release 1.1, and are preparing 1.2.
Date of last release:
2015-03-23
When were the last committers or PMC members elected?
December 2014.
Signed-off-by:
[x](calcite) Ted Dunning
[X](calcite) Alan Gates
[X](calcite) Steven Noels
[X](IPMC) Chris Mattmann
Shepherd/Mentor notes:
Chris Mattmann:
* Calcite being discussed by Tom Barber at ApacheCon NA 2015.
Calcite is a highly customizable engine for parsing and planning queries on
data in a wide variety of formats. It allows database-like access, and in
particular a SQL interface and advanced query optimization, for data not
residing in a traditional database. (Renamed from Optiq on 2014-09-30.)
Calcite has been incubating since 2014-05-19.
Three most important issues to address in the move towards graduation:
1. Continue to build community
2. Add more committers and PPMC members
3. Demonstrate community robustness by rotating project tasks among
multiple project members
Any issues that the Incubator PMC (IPMC) or ASF Board wish/need to be
aware of?
None.
How has the community developed since the last report?
In December, there were 84 messages on dev@, 45 commits, 50 issues
created, 27 issues resolved by 7 contributors.
Julian Hyde gave a talk "SQL on everything, in memory" about Calcite
at the Strata + Hadoop World conference in October, and held an
"office hour" with interested community members. He also spoke at
a Hive meet-up in New York and a Kylin meet-up in San Jose about
how those projects integrate with Calcite.
Collaborations are under way with other Apache projects: with Drill
to make implementation convention more neutral; with Hive for join
algorithm selection, and leveraging sorted data; and with Phoenix
to create a Calcite adapter for Phoenix.
How has the project developed since the last report?
We have completed the rename from Optiq to Calcite. We have also
re-organized the code into the org.apache.calcite namespace. We are
planning to make a 1.0 release in January with the re-organized
code.
Date of last release:
2014-11-05 (0.9.2)
When were the last committers or PMC members elected?
PPMC member elected in December (but has not yet accepted).
Signed-off-by:
[X](calcite) Ted Dunning
[X](calcite) Alan Gates
[X](calcite) Steven Noels
Optiq/Calcite is a highly customizable engine for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Optiq/Calcite has been incubating since 2014-05-19. Three most important issues to address in the move towards graduation: 1. Complete renaming to Calcite. 2. Re-organize code into org.apache.calcite namespace 3. Create a product worthy of a "1.0" label. 4. Improve web site 5. Build an ASF community Any issues that the Incubator PMC (IPMC) or ASF Board wish/need to be aware of? None. How has the community developed since the last report? We held our first meetup, a hackathon hosted by MapR. It was well-attended, and we attracted a number of new contributors at various skill levels, who produced a number of contributions that have since been committed. Julian Hyde spoke to over 200 attendees at the Seattle Scalability meetup on how Apache Hive uses Apache Optiq to do its cost-based optimization. In September, there were 72 messages on dev@, 38 commits, 36 issues created, 30 issues resolved. How has the project developed since the last report? We completed https://issues.apache.org/jira/browse/PODLINGNAMESEARCH-51 and concluded that Optiq was not a viable name. We agreed (via PPMC vote and consensus on dev) that Calcite was suitable new name, and logged https://issues.apache.org/jira/browse/PODLINGNAMESEARCH-56, which has been approved by legal. Now we are part way through renaming; see https://issues.apache.org/jira/browse/INFRA-8413 We expect to have a release candidate for apache-calcite-0.9.1-incubating to go to a PPMC vote this week. Date of last release: 2014-08-25 When were the last committers or PMC members elected? 2014-07-15 Signed-off-by: [ ](optiq) Ted Dunning [X](optiq) Alan Gates [X](optiq) Steven Noels
Optiq is a highly customizable engine for parsing and planning queries on data in a wide variety of formats. It allows database-like access, and in particular a SQL interface and advanced query optimization, for data not residing in a traditional database. Optiq has been incubating since 2014-05-19. Three most important issues to address in the move towards graduation: 1. Migrate fully to Apache infrastructure (next: nightly builds). 2. Re-organize code into org.apache.optiq namespace. 3. Improve web site. 4. Build an ASF community. Any issues that the Incubator PMC (IPMC) or ASF Board wish/need to be aware of? None. How has the community developed since the last report? We are planning our first hackathon. There have been community discussions about the goals for a future 1.0 release, in particular whether the project should be reorganized to allow projects to use the optimizer core without using SQL parser and code-generation facilities. How has the project developed since the last report? Adopting Apache infrastructure: * First release approved by PPMC and Incubator PMC * Web site We will push our and announce the release shortly. Apache infrastructure is extremely frustrating. The release has taken a lot longer than it should have because it frequently makes this newbie feel like an idiot. Questions are answered promptly but it is difficult to know what questions to ask. Date of last release: 2014-08-25 When were the last committers or PMC members elected? 2014-07-15 Signed-off-by: [X](optiq) Ted Dunning [X](optiq) Alan Gates [X](optiq) Steven Noels
Optiq is a highly customizable engine for parsing and planning queries on
data in a wide variety of formats. It allows database-like access, and in
particular a SQL interface and advanced query optimization, for data not
residing in a traditional database.
Optiq has been incubating since 2014-05-19.
Three most important issues to address in the move towards graduation:
1. Migrate fully to Apache infrastructure (next: web site and
nightly builds).
2. Re-organize code into org.apache.optiq namespace.
3. Regular releases.
4. Build an ASF community.
Any issues that the Incubator PMC (IPMC) or ASF Board wish/need
to be aware of?
None.
How has the community developed since the last report?
We have added our first post-incubation committer, Vladimir
Sitnikov.
We are planning our first hackathon.
There have been community discussions about the goals for a future
1.0 release, in particular whether the project should be reorganized
to allow projects to use the optimizer core without using SQL parser
and code-generation facilities.
How has the project developed since the last report?
Adopting Apache infrastructure:
* Gained access to Nexus and started publishing (on-demand, not
nightly) snapshot builds.
* Web site in progress.
Working on first release under the Apache incubator,
apache-optiq-0.9.0-incubating.
Date of last release:
No releases yet under the Incubator.
Last unofficial release was optiq-0.8, on 2014-06-27.
First official release is imminent.
When were the last committers or PMC members elected?
Vladimir Sitnikov, elected committer on 2014-07-15.
Signed-off-by:
[x](optiq) Ted Dunning
[X](optiq) Alan Gates
[x](optiq) Steven Noels
Optiq is a highly customizable engine for parsing and planning
queries on data in a wide variety of formats. It allows
database-like access, and in particular a SQL interface and
advanced query optimization, for data not residing in a
traditional database.
Optiq has been incubating since 2014-05-19.
Three most important issues to address in the move towards graduation:
1. Migrate fully to Apache infrastructure (next: web site and
nightly builds).
2. Re-organize code into org.apache.optiq namespace.
3. Regular releases.
4. Build an ASF community.
Any issues that the Incubator PMC (IPMC) or ASF Board wish/need
to be aware of?
With the mentors' permission, we released an unofficial
release, optiq-0.8. Optiq has been making regular releases,
approximately monthly, and this has built momentum in the
community. Continuing this practice helps hold the community
together. We intend to that the next release (0.9, end of July)
is an official Apache Incubator release.
How has the community developed since the last report?
This is our first report. The community remains very similar to
the point where we joined the Incubator.
We are doing outreach.
* Julian Hyde gave two talks related to Optiq at Hadoop Summit.
* Julian Hyde attended the ACM SIGMOD conference and discussed
Optiq with several researchers. Optiq was mentioned in
several talks there.
* An online meeting (via Google hangouts) for the community is
scheduled for July 1st.
How has the project developed since the last report?
This is our first report.
Adopting Apache infrastructure:
* We have completed necessary SGAs, and transferred code from
github to Apache git, and begun committing to Apache
git. (Original github site still online, but marked
"retired" with redirection page.)
* We have transferred github issues to Apache JIRA, and are
using Apache JIRA for issue management.
* Some members have complained that the traffic on dev@ is too
great - requesting an issues@ mailing list for jira update
traffic.
We made an unofficial release (optiq-0.8) on 2014-06-27.
Date of last release:
No releases yet under the Incubator. (But see unofficial
release 0.8, above.)
When were the last committers or PMC members elected?
No new committers since we joined the Incubator.
Signed-off-by:
[ ](optiq) Ted Dunning
[ ](optiq) Alan Gates
[ ](optiq) Steven Noels