All Forums Extensibility
munir.bondre 2 posts Joined 03/12
27 Apr 2012
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

 

 

munir.bondre 2 posts Joined 03/12
27 Apr 2012

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

Jim Chapman 449 posts Joined 09/04
11 May 2012

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

You must sign in to leave a comment.