TD_​MINFO

The TD_MINFO, 'Matrix Information', function is an AF Utility function used to return metadata describing the logical matrix identified by the MATRIX_SPEC specification passed into the function. For each matrix this function returns:. Matrix Row/Column Index Data type - TIMESTAMP, TIMESTAMP WITH TIME ZONE, DATE, INTEGER, or FLOAT. Starting Row/Column Index value associated with the matrix . Ending Row/Column Index value associated with the matrix . Count of total number of entries for Row/Column Index. Flag indicating whether the matrix is regular or irregular along Row/Column Index. Row/Column Index Sample interval - row/column index sample interval associated with a discrete row/column index; or, alternatively, average of all row/column index sample intervals encountered, if it has an irregular row/column index.. Content Type of payload “fields” - REAL, COMPLEX, AMPL_PHASE_RADIANS, AMPL_PHASE_DEGREES, MULTIVAR_REAL, MULTIVAR_COMPLEX, MULTIVAR_AMPL_PHASE_RADIANS, or MULTIVAR_AMPL_PHASE_DEGREES. For each payload “fields” entry: Minimum sample magnitude encountered in matrix; Maximum sample magnitude encountered in matrix; Average of all magnitudes encountered in matrix. Count of total number of null value in all the result payload fields.. Flag indicating whether the matrix is malformed or well input matrix.

Options

Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
This AF function is passed a collection of logical matrices described by a matrix specification, MATRIX_SPEC. These logical matrices can be of either the regular or irregular variety. Their indexing mechanisms can be based on time or space

Output Ports

Icon
output of TD_MINFO

Nodes

Extensions

Links