CSV_TO_JSON Syntax - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
amv1590702100517.ditamap
dita:ditavalPath
amv1590702100517.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢
CSV_TO_JSON ( ON
  ( SELECT CSV_expression select_stmt_options )
  [ USING { SCHEMA ( schema ) | AGGREGATE ( {'Y'|'N'} ) } ]
)

Syntax Elements

CSV_expression
Any expression that evaluates to character data in the CSV format or a DATASET STORAGE FORMAT CSV value.
select_stmt_options
The select_stmt_options are the allowable or necessary options in Vantage for a SQL SELECT statement.
USING
Variables used as input to the SQL statement specified by select_stmt_options.
schema
The CSV schema.
AGGREGATE
Specify AGGREGATE for the output instances to be composed of one row of input data.