Trafodion Code Examples

Use this page to share code that you have developed for Trafodion and that could be useful for others. This could include, but is not restricted to:

• UDFs
• Stored Procedures
• Scripts to manage a Trafodion instance
• SQL queries to query Trafodion metadata

If the code is just a few lines, you could list it here. If it's multiple files, you could publish it in github and put a short description and a link here.

Also, please consider adding a license to your code in github, for example you can add an Apache license, so it is clear how your code can be used.

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