150 - 168 of 68 tags for udf

Pages

How will you be able to use the new user defined functions with persistent memory feature to speed up your operations? We will examine three use cases and performance information regarding User Defined Functions with Persistent Memory. Specifically a persistent regular expression UDF is presented and the use of Role based persistent information is discussed. An overview is of the feature, its administration, and the basic architecture is also covered.

This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results.

Map-reduce, or its open source version Hadoop, is a parallel programming framework for running scripts, Java, C, and other external programming languages on hundreds of nodes. It is popular with Dot.Com companies who have large server farms and need to produce reports on website activity or produce search indexes. In general, Map-reduce applications overlap BI applications and data warehouses. However, Map-reduce applications can coexist with a data warehouse: one parallel processing, the other parallel database. Coexistence allows each subsystem’s best capabilities to be used to complement the other. With Teradata’s in-database processing technology, Map-reduce can become MPP ETL subsystem, or we can run Map-Reduce functions inside the EDW, or using table functions we can directly integrate with the Map-reduce nodes. This article illustrates a commonly used Map-reduce function running inside the Teradata EDW.

From time to time I’m asked how one might go about writing an UDF or an INMod or some other procedural extension to the database. The question isn’t a “where do I learn C or C++” question; rather it is a how do I go about debugging and testing my extension without the overheads and constraints of running within the database (or utility).


My response is you can use “my Teradata” for which I have the source code (attached). This will allow you to run, test and debug your function outside of Teradata. In short with “my Teradata” all of the features of your IDE will be available to you, including your debugger.

A collection of UDFs that emulate the most-commonly used Oracle built-in SQL functions.

These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference.

This UDF implements the Secure Hash Algorithm, SHA-1, for computing a condensed representation of a message. When a message of any length < 264 bits is input, the SHA-1 produces a 160-bit output called a message digest (FIPS 180-1 / RFC 3174). This distribution contains full source code, a test suite, scripts, and documentation.

This UDF implements the MD5 message-digest algorithm. The algorithm takes as input a message of arbitrary length and produces as output a 128-bit "fingerprint" or "message digest" of the input (RFC1321). This distribution contains full source code, a test suite, scripts, and documentation.

This UDF implements the great circle distance algorithm to determine the distance in miles between two points expressed in longitude and latitude. This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation.

The self extractable file includes the lobload application to load UDF's, SP's etc. into Teradata as part of installation.

Eight UDFs that search VARCHAR and CLOB string sources to see if they contain VARCHAR or CLOB string sets. Four of the UDFs are overloaded (named the same) to return the result in the form of VARCHAR or CLOB string while the other four UDFs are overloaded to return an INTEGER index into the string source if a match is found.

Is_numeric() UDF checks a field to see if it converts to a Teradata numeric value. one use would be for the ETL process to use the UDF to check incoming data that's destined for DECIMAL and INTEGER columns.

This package contains two string-related UDFs. The Edit Distance function returns the minimum number of edit operations required to transform string1 into string2. The N-Gram matching function returns the number of n-gram matches between two strings.

SQL Scalar UDF that writes varbyte or varchar arg to MQ.

Teradata UDFs for popular IBM DB2 functions.

In-place compression UDF. Compress column value for VARCHARs and BLOBS. Similar to zipping the column before inserting. Can also be used for encrypting data in the database. After compression data is unreadable until uncompressed.

UDFs for Byte operations, such as bitwise AND, OR, XOR, NOT, SHIFT, and conversion of a byte value to character.

This user guide describes the Teradata Warehouse 7.1 User Defined Function (UDF) feature. This guide is primarily targeted towards developers of UDFs and database administrators.