DB Administrator Utilities

Contents

• Utility Functions
• Related Topics

Warning

This MADlib method is still in early stage development. There may be some issues that will be addressed in a future version. Interface and implementation is subject to change.

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.
relative_error()	Compute the relative error of an approximate value.
relative_error()	Compute the relative error (w.r.t. the 2-norm) of an approximate vector.
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.
bytea8in()
bytea8out()
bytea8recv()
bytea8send()

Related Topics

File utilities.sql_in documenting the SQL functions.