Are User defined Window Aggregates and User Defined Table Functions supported in TD 12.0?

Extensibility

Are User defined Window Aggregates and User Defined Table Functions supported in TD 12.0?

Hi,

We are developing some user defined functions (aggregates, window aggregates) and table functions  in TD 12.0.  

We tried to use the example from the "SQL External Routine Programming" book.  Unfortunately, the releasea listed on this book is 13.10.

We were able to compile and register the window aggregate without any problem.  However, we cannot invoke the function (see below).  We wonder whether window aggregates are supported in 12.0.  Can someone please clarify?

--Registration

CREATE FUNCTION syslib.dense_rank(x INTEGER)

    returns INTEGER

CLASS AGGREGATE

language C

NO SQL

SPECIFIC dense_rank

EXTERNAL NAME 'SP!//home/mbondre/DBLytix/UDX/BIN/12.00.03.14/libDenseRank.so'

parameter style SQL;

--Invocation

SELECT v, syslib.dense_rank(v) OVER (PARTITION BY id ORDER BY v

ROWS UNBOUNDED PRECEDING) as dr

FROM t ORDER BY dr;

--Error 

*** Failure 3706 Syntax error: expected something between ')' and the 'OVER' keyword.

                Statement# 2, Info =46

Tags (2)
2 REPLIES

Re: Are User defined Window Aggregates and User Defined Table Functions supported in TD 12.0?

Should have clarified that we are doing this in C++.

Enthusiast

Re: Are User defined Window Aggregates and User Defined Table Functions supported in TD 12.0?

User-defined table functions and (non-windowed) aggregate functions are supported in 12.0.  Window aggregates require 13.10.