16.20 - 例: 非標準データを指定したSCHEMAカスタム句の使用 - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ DATASETデータ型

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
2019年3月
Content Type
プログラミング リファレンス
Publication ID
B035-1198-162K-JPN
Language
日本語 (日本)

非標準のCSVデータがある場合、SCHEMAカスタム句を使用して非標準データを指定します。

SELECT data.toJSON() FROM CSV_TO_AVRO
(
	ON (SELECT csvFile FROM myCSVTable09 WHERE id=2)
	USING SCHEMA('{"record_delimiter":"#"}')
) AS csvAvro ORDER BY data."Item_ID";

{"Item_ID":"105","Item_Name":"soap","Item_Color":null,"Item_Style":null,"Quantity_Purchased":"1","Item_Price":"0.99","Total_Price":"0.99"}
{"Item_ID":"55","Item_Name":"bicycle","Item_Color":"red","Item_Style":"boys","Quantity_Purchased":"1","Item_Price":"100.00","Total_Price":"100.00"}
{"Item_ID":"88","Item_Name":"toy boat","Item_Color":"pink","Item_Style":null,"Quantity_Purchased":"1","Item_Price":"15.10","Total_Price":"15.10"}