Re: Draft: board report for 2022 Q3
+1 Ruben, great summary! On Sun, 2 Oct 2022 at 17:36, Julian Hyde 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 wrote: > > > > +1, thanks Ruben for preparing the report! > > > > Francis Chuang 于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 |
Re: Draft: board report for 2022 Q3
+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 wrote: > > +1, thanks Ruben for preparing the report! > > Francis Chuang 于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
Re: Draft: board report for 2022 Q3
+1, thanks Ruben for preparing the report! Francis Chuang 于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 | 9 | > > | Benchao Li |
Re: Draft: board report for 2022 Q3
+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 | 9 | | Benchao Li | 7 | | Stamatis Zampetakis | 2 | | rubenada | 1 | | chunwei.lcw | 1 | +-+-+
Draft: board report for 2022 Q3
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 | 9 | | Benchao Li | 7 | | Stamatis Zampetakis | 2 | | rubenada | 1 | | chunwei.lcw | 1 | +-+-+