SQL-MapReduce Utility Functions for IMDCs - 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
SQL-MapReduce Utility Function Description
load_into_imdc Creates an IMDC and loads it with data. Reports the number of rows loaded into each partition.
imdc_adapter Outputs data from an IMDC. Creates and loads the IMDC if it does not exist. Output can be input to another SQL-MapReduce, using an input iterator, even if the receiving function was not coded to use IMDCs.
project_from_imdc Outputs data from an existing IMDC, and (optionally) the IP addresses and partition indexes of the partitions that host the data.
remove_imdc Removes an IMDC.
get_imdc_meta_info Returns IMDC metadata.
list_imdc Returns a list of IMDCs, by name, in every partition.
gc_jvm Prompts the JVMs on each node to start garbage collection.
available_memory_on_jvm Returns the memory statistics of the JVM on each node.

You can perform some of the same IMDC operations with the IMDC Operations API.