Contents

Database functions are a collection of lower level utilities to assist data scientists and others in using MADlib.

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.
dropcols()	Create a new table with a subset of the columns dropped from a source table.

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.