7.00.02 - ACT Commands for Managing Files - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

You can use Aster Database Cluster Terminal (ACT) commands to install and manage individual files, including:

  • Aster Analytics functions
  • SQL-MapReduce functions (compiled Java and C executables that can be invoked by name in the FROM clause of a SELECT statement)
  • Script files for stream()
  • Files that provide settings to SQL-MapReduce functions or stream() script files

If a function is not a standalone function—that is, if it is composed of multiple functions—then you must install all of its components. You can tell if a function is composed of multiple functions by checking its syntax in this guide.

The following table describes the ACT commands for installing, downloading, and removing files and functions. A file or function is local if it resides on your local file system and remote if it resides in Aster Database.

You can put the \install and \remove commands in BEGIN / COMMIT blocks, like transactional SQL commands.

ACT Commands for Managing Files and Functions
Command Meaning
\dF Lists all installed files and functions.
\install file [ installed_filename ] Installs the file or function file, which is the path name of the file relative to the directory where you are running ACT.

By default, the installed local file or function has the same name as the corresponding remote file.

The optional installed_filename is an alias. Aliases are useful for renaming helper files, but are not recommended for SQL-MapReduce functions, because they can cause confusion.

\download installed_filename [ newfilename ] Downloads the file or function installed_filename to the directory where you are running ACT.

By default, the downloaded local file or function has the same name as the corresponding remote file. To give the local file or function a new name, specify the optional newfilename. If newfilename is a path, the destination directory must exist on the file system where you are running ACT.

\remove installed_filename Removes the file or function installed_filename.