JSON Data Type without Primary Index Example - Teradata Listener

Teradata® Listener™ User Guide

Product
Teradata Listener
Release Number
2.06
Published
August 2019
Language
English (United States)
Last Update
2019-08-30
dita:mapPath
yng1555531055816.ditamap
dita:ditavalPath
boe1555608925945.ditaval
dita:id
B035-2910
Product Category
Analytical Ecosystem
CREATE MULTISET TABLE listener.json_testing ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      uuid VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
      source_id VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
      time_stamp TIMESTAMP(6) WITH TIME ZONE,
      data JSON(16776192) CHARACTER SET LATIN)
PRIMARY INDEX ( uuid );