+1 You’ve painted a good picture of what’s going on. I think the Board will appreciate.
My personal update: I’m sitting on the runway heading to New Orleans for ApacheCon. Planning to present, but also represent Calcite! If any of you are there, please get in touch. Julian > On Oct 2, 2022, at 07:22, Benchao Li <[email protected]> wrote: > > +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
