15.10 - JSONMETADATA Output - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

JSONMETADATA output is a JSON object with the following format.

The following fields are the same as the METADATA fields, except these are aggregated values.

{
    "doc_count":
    “size”: 
    {
		       “min”:
		       “max”:
		       “avg”:
    }
    “depth”:
    {
		        “min”:
		        “max”:
		        “avg”:
    } 
    “keycnt”:
    {
		        “min”:
		        “max”:
		        “avg”:
    }
    “objcnt”:
    {
		        “min”:
		        “max”:
		        “avg”:
    }
    “arycnt”:
    {
		        “min”:
		        “max”:
		        “avg”:
    }
    “strcnt”:
    {
		        “min”:
		        “max”:
		        “avg”:
    }
    “nbrcnt”:
    {
		         “min”:
		         “max”:
		         “avg”:
    }
    “boolcnt”:
    {
		         “min”:
		         “max”:
		         “avg”:
    }
    “nullcnt”:
    {
		         “min”:
		         “max”:
		         “avg”:
    }
   "keylen":
   {
        "min":
        "max":
        "avg":
   }
   "strvallen":
   {
        "min":
        "max":
        "avg":
   }
}

For each field, a minimum, maximum, and average is calculated across the entire input set of JSON documents. doc_count is the total number of rows which were counted by the aggregation.