2.05.2.05 - 2.05 - JSON Data Type with Autoshredding Example - Teradata Listener

Teradata® Listener™ User Guide

prodname
Teradata Listener
vrm_release
2.05
category
User Guide
featnum
B035-2910-039K
CREATE MULTISET TABLE listener.state_information ,FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, DATABLOCKSIZE=1048064 BYTES, CHECKSUM = DEFAULT (
    uuid VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    source_id VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    time_stamp VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    data VARCHAR(512) CHARACTER SET LATIN NOT CASESPECIFIC,
    county VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    state VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC)NO PRIMARY INDEX;
curl \
        -H "Content-Type: application/json" \
        -H "Authorization: token c0c7606e-5273-424d-ba7a-4e8ca24a1aed" \
        -X POST -d '{"county" : "Travis"}' \
        -i \https://CLUSTER.DOMAIN/listener/ingestservices/message

curl \
        -H "Content-Type: application/json" \
        -H "Authorization: token c0c7606e-5273-424d-ba7a-4e8ca24a1aed" \
        -X POST -d '{"county" : "Travis", "state" : "Texas"}' \
        -i \https://CLUSTER.DOMAIN/listener/ingestservices/message