DataSize Function Examples | Teradata Vantage - DataSize Examples - Analytics Database - Teradata Vantage

Geospatial Data Types

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-08-30
dita:mapPath
qgk1628112272483.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ghz1472251264557
lifecycle
latest
Product Category
Teradata Vantageā„¢

The following examples use JSON data types.

SELECT TD_SYSFNLIB.DataSize (NEW JSON ('{"name" : "Mitzy", "age" : 3}'));

Output:

datasize( NEW JSON('{"name" : "Mitzy", "age" : 3}', LATIN))
-----------------------------------------------------------
                                                         29
CREATE TABLE JSON_table (id INTEGER, jsn JSON INLINE LENGTH 1000);

INSERT INTO JSON_table VALUES (100, '{"name" : "Mitzy", "age" : 3}');
INSERT INTO JSON_table VALUES (200, '{"name" : "Rover", "age" : 5}');
INSERT INTO JSON_table VALUES (300, '{"name" : "Princess", "age" : 4.5}');

SELECT * FROM JSON_table ORDER BY id;

Output:

         id jsn
----------- ------------------------------------------
        100 {"name" : "Mitzy", "age" : 3}
        200 {"name" : "Rover", "age" : 5}
        300 {"name" : "Princess", "age" : 4.5}
SELECT id, TD_SYSFNLIB.DataSize (jsn) FROM JSON_table ORDER BY id;

Output:

         id         datasize(jsn)
-----------  --------------------
        100                    29
        200                    29
        300                    34