+1, thanks Ruben for preparing the report! Francis Chuang <[email protected]> 于2022年10月2日周日 18:06写道：
> +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 | > > +-----------------------------------------+---------+ > > > -- Best, Benchao Li
