TD_IMAGE2MATRIX Syntax Elements | Teradata Vantage - TD_IMAGE2MATRIX Syntax Elements - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
image_expr
The identifier column and the image, such as ID, my_image.
image_table
The name of the image table.
string_literal
A query expression that returns at least two columns. The first column is an identifier for the row and a way to correlate the rows in the returned table to the data in a particular BLOB. It is also the primary index for the returned table, and can be any non-LOB data type. Best practice is to have it be a unique value for each input row, which corresponds to each individual JSON document to be processed by the function. The last column contains the BLOB image.
column
OUTPUT
Options are gray and rgb. The default option is gray.

If the OUTPUT option is gray, then the output columns are Y, X, and GRAY, where GRAY is the gray image value. If the OUTPUT option is rgb, then the output columns are Y, X, RED, GREEN, and BLUE.