JSONMETADATA Output

Teradata Vantage™ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

JSONMETADATA output is a JSON object with the following format.

The following fields are the same as the METADATA Output, 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.