From the ACT command prompt (SQL prompt), you can use the \dF commands to find out what functions and files are installed in your cluster:
- \dE - Lists all the SQL-MapReduce functions that you have permission to run, based on your SQL user account. For an explanation of permissions, see SQL-MapReduce Security.
- \dF - Lists all installed files and SQL-MapReduce functions in your current schema.
- \dF *.* - Lists all installed files and SQL-MapReduce functions in the database.
- \dF+ - Prints the list of SQL-MapReduce functions installed. For each function, the output shows the name, schema, owner, upload time, and fingerprint of the function. Type \dF+ to show functions in your current schema, or \dF+ *.* to show them for all schemas in the database. The fingerprint indicates the revision number of the function. When you are reporting suspected errors in SQL-MapReduce functions, provide the function's fingerprint to Teradata Global Technical Support (GTS).