Page History

...

Stored Procedures

Scalar UDFs

...

Using Regular Expression in SQL （在SQL中使用正则表达式）

This demo UDF aims to provide an example about how to write a scalar UDF, instead of providing a production-level UDF. But one can start with it to enhance it to be more useful.

Standard SQL cannot do some complex query against a string. Like to filter out a valid phone number, a valid IP address or an email address. Regular Expression is a powerful tool to do this. This demo shows you how to write a UDF to enhance/extend Trafodion to support RegExp to do some more complex queries.

The source code can be downloaded from : https://github.com/traflm/trafodion-repos/tree/master/scalar-udf

Table-Mapping UDFs

Reading Kafka Events

We are working on sample code to read from Kafka and plan to publish the code here.

Manageability

Tools

SQL Scripts and Queries

Miscellaneous