OK great. I happen to have recently read that bit of SQL 2016 so that puts
it in context for me very nicely.
Kenn
On Fri, Dec 14, 2018 at 3:58 AM Gleb Kanterov wrote:
> Kenn, I don't have a copy of a recent SQL standard to confirm what I'm
> saying. To my knowledge, initially, there was a conce
Kenn, I don't have a copy of a recent SQL standard to confirm what I'm
saying. To my knowledge, initially, there was a concept of a table
function. Table functions should have a static type that doesn't depend on
supplied arguments. In ANSI SQL 2016, there is a concept of polymorphic
table function
Sorry for the slow reply & review. Having UDTF support in Beam SQL is
extremely useful. Are both table functions and table macros part of
"standard" SQL or is this a distinction between different Calcite concepts?
Kenn
On Wed, Nov 28, 2018 at 10:36 AM Gleb Kanterov wrote:
> At the moment we sup
At the moment we support only ScalarFunction UDF, it's functions that
operate on row fields. In Calcite, there are 3 kinds of UDFs: aggregate
functions (that we already support), table macro and table functions. The
difference between table functions and macros is that macros expand to
relations, a