+1 Ruben, great summary! On Sun, 2 Oct 2022 at 17:36, Julian Hyde <jhyde.apa...@gmail.com> wrote:
> +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 <libenc...@apache.org> wrote: > > > > +1, thanks Ruben for preparing the report! > > > > Francis Chuang <francischu...@apache.org> 于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 <jh...@apache.org> | 9 | > >>> | Benchao Li <libenc...@gmail.com> | 7 | > >>> | Stamatis Zampetakis <zabe...@gmail.com> | 2 | > >>> | rubenada <rube...@gmail.com> | 1 | > >>> | chunwei.lcw <chunwei.l...@gmail.com> | 1 | > >>> +-----------------------------------------+---------+ > >>> > >> > > > > > > -- > > > > Best, > > Benchao Li >