Example: Changing the Key Names in the Avro Record

Teradata Vantageā„¢ DATASET Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1198-162K

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