Example: Changing the Key Names in the Avro Record - Advanced SQL Engine - Teradata Database

DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
des1556232910526.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1198
lifecycle
previous
Product Category
Teradata Vantageā„¢

To change the key names in the resulting JSON documents, use the SCHEMA custom clause.

SELECT * FROM CSV_TO_JSON
(
	ON (SELECT csvFile FROM myCSVTable09 WHERE id=2) 
	USING SCHEMA('{"record_delimiter":"#", "field_names":["a1","a2","a3","a4","a5","a6","a7"]}')
) AS csvJSON ORDER BY data."a1";

> {"a1":"55", "a2":"bicycle", "a3":"red", "a4":"boys", "a5":"1", "a6":"100.00", "a7":"100.00"}
> {"a1":"88", "a2":"toy boat", "a3":"pink", "a4":null, "a5":"1", "a6":"15.10", "a7":"15.10"}
> {"a1":"105", "a2":"soap", "a3":null, "a4":null, "a5":"1", "a6":"0.99", "a7":"0.99"}