virtual-schema-common-lua 2.2.0, released 2022-09-28

September 28, 2022 ยท View on GitHub

Code name: Aggregate functions

Summary

Release 2.2.0 of virtual-schema-common-lua adds SQL rendering for aggregate functions. We also removed the standard dependency check, since it only targets Java dependencies and this project is a pure Lua project.

Known limitation:

The core database does not push the OVER clause that make the main difference between an analytical function and a regular aggregate function to the Virtual Schema adapter. This means VS push-down supports basic aggregate functions, but no analytical functions.

Also LISTAGG (#19) is not yet supported.

Features

  • #17: Added rendering for aggregate functions GROUPING and APPROXIMATE COUNT DISTINCT
  • #18: Added rendering aggregate functions that can have an OVER clause. VS does not support pushing OVER though.
  • #47: Removed dependency check CI build
  • #50: Added rendering for GROUP_CONCAT
  • #53: Added test for aggregate function in WHERE clause
  • #54: Enabled all COUNT variants and added more predicates