JSON_TABLEの例の設定 - Teradata Database - Teradata Vantage NewSQL Engine - この例では、後続の例で使用するテーブルを作成して、入力を行ないます。

後の例で使用するテーブルを作成して、データを取り込みます。

CREATE TABLE my_table (id INTEGER, jsonCol JSON(1000));
INSERT INTO my_table (1, NEW JSON('{"name" : "Cameron", "age" : 24, 
"schools" : [ {"name" : "Lake", "type" : "elementary"}, 
{"name" : "Madison", "type" : "middle"}, {"name" : "Rancho", "type" : "high"}, 
{"name" : "UCI", "type" : "college"} ], "job" : "programmer" }')); 

INSERT INTO my_table (2, NEW JSON('{"name" : "Melissa", "age" : 23, 
"schools" : [ {"name" : "Lake", "type" : "elementary"}, 
{"name" : "Madison", "type" : "middle"}, 
{"name" : "Rancho", "type" : "high"}, 
{"name" : "Mira Costa", "type" : "college"} ] }'));

INSERT INTO my_table (3, NEW JSON('{"name" : "Alex", "age" : 25, 
"schools" : [ {"name" : "Lake", "type" : "elementary"}, 
{"name" : "Madison", "type" : "middle"}, 
{"name" : "Rancho", "type" : "high"}, 
{"name" : "CSUSM", "type" : "college"} ], "job" : "CPA" }')); 

INSERT INTO my_table (4, NEW JSON('{"name" : "David", "age" : 25, 
"schools" : [ {"name" : "Lake", "type" : "elementary"}, 
{"name" : "Madison", "type" : "middle"}, 
{"name" : "Rancho", "type" : "high"} ], 
"job" : "small business owner"}'));