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 | +-----------------------------------------+---------+
