Contents

The utility module consists of useful utility functions to assist data scientists in using the product. Several of these functions can be used while implementing new algorithms.

Utility Functions

version()	Return MADlib build information.
assert()	Raise an exception if the given condition is not satisfied.
check_if_raises_error()	Check if a SQL statement raises an error.
check_if_col_exists()	Check if a column exists in a table.
isnan()	Check if a floating-point number is NaN (not a number)
create_schema_pg_temp()	Create the temporary schema if it does not exist yet.
noop()	Create volatile noop function.
cleanup_madlib_temp_tables()	Drop all tables matching pattern 'madlib_temp' in a given schema.

Note: If the function cleanup_madlib_temp_tables() gives an Out-of-memory error, then the number of tables to be dropped is too high to execute in one transaction. In such a case, please follow the instructions provided with the error to execute the command in multiple transactions.

Related Topics

File utilities.sql_in documenting the SQL functions.