+1 Looks great, Ruben!
On 2/10/2022 8:59 pm, Ruben Q L wrote:
Hello,
Below these lines you can find a draft of this quarter's board report. I
plan to submit it
before Friday next week.
Please let me know if you have any additions or corrections.
Best regards,
Ruben
---------------------------------------------------------
## 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 <[email protected]> | 9 |
| Benchao Li <[email protected]> | 7 |
| Stamatis Zampetakis <[email protected]> | 2 |
| rubenada <[email protected]> | 1 |
| chunwei.lcw <[email protected]> | 1 |
+-----------------------------------------+---------+
