get_imdc_meta_info - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

The get_imdc_meta_info function returns metadata for a specified IMDC.

Syntax

SELECT * FROM get_imdc_meta_info (
  input
  imdc (imdc_name)
);

Input

Ignored. Use the empty table NC_SYSTEM.NC_DUMMY (or any other table).

Arguments

imdc
Specifies the name of the IMDC whose metadata is to be returned.

Schema of Output

Column Name Description
NodeIp IP address of the node that hosts the data.
TaskIdx Task index of the partition that hosts the data.
Name Name of the IMDC.
RowCount Number of IMDC rows in the partition.
BlockCount Number of blocks used by the IMDC in the partition.
TotalMemBytes Total memory used by the IMDC in the partition.
MaxInMemBytes Maximum number of bytes that the IMDC can use in memory. (Additional content overflows to the disk.)
ColName IMDC column name.
ColType IMDC column type.
ColMem Memory allocated to IMDC column.