16.20 - Example: Changing the Key Names in the Avro Record - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ DATASET Data Type

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
pgs1512082344257.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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"}