17.10 - 例 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - DATASETデータ型

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1198-171K-JPN
Language
日本語 (日本)

例: DATASETデータ型のAvroインスタンスのスキーマの取得

SELECT avroFile.getSchema() FROM myAVROTable06;
> {
	"type":"record",
	"name":"rec_0",
	"fields":[
		{
			"name":"Sale",
			"type":{
				"type":"record",
				"name":"rec_1",
				"fields":[
					{"name":"Item_ID","type":"int"},
					{"name":"Item_Name","type":"string"},
					{"name":"Item_Color","type":"string"},
					{"name":"Item_Style","type":"string"},
					{"name":"Quantity_Purchased","type":"int"},
					{"name":"Item_Price","type":"double"},
					{"name":"Total_Price","type":"double"}
				]
				}
			}
		]
	  }

例: DATASETデータ型のCSVインスタンスのスキーマの取得

SELECT csvFile.getSchema() FROM myCSVTable06;

> {
   "field_delimiter" : "&",
   "record_delimiter" : "#",
   "field_names" :
    [
     "Item_ID",
     "Item_Name",
     "Price"
    ]
  }