JSONExtractValueの例の設定 - Teradata Database - Teradata Vantage NewSQL Engine - JSONオブジェクトとINTEGERデータを含むテーブルを作成し入力します。以降のセクションの例では、このテーブルとデータを参照します。

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

CREATE TABLE my_table (eno INTEGER, edata JSON(1000));

INSERT INTO my_table (1, NEW JSON('[{"firstName" : "Cameron", "lastName" : "Lewis", "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('[{"firstName" : "Melissa", "lastName" : "Lewis", "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('[{"firstName" : "Alex", "lastName" : "Smoley", "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('[{"firstName" : "David", "lastName" : "Perpich", "age" : 25, "schools" : [ {"name" : "Lake", "type" : "elementary"}, {"name" : "Madison", "type" : "middle"}, {"name" : "Rancho", "type" : "high"} ], "job" : "small business owner"}]'));