15.10 - Setting Up Join Index Examples - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

Create and populate table(s) to use in subsequent example(s).

CREATE TABLE json_table(id INTEGER, j JSON(100));

INSERT INTO json_table(1, NEW JSON('{"name":"Cameron", "age":25}')); 
INSERT INTO json_table(2, NEW JSON('{"name":"Melissa", "age":24}'));