| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
fieldnamesStatistics provides detailed information on the column for the input table.
...
A table containing the column names and their statistics, for example, non null count, distinct count, min, max, mean, and stdev.
Example
Input
name | ID | floatVal | IP | longVal |
|---|---|---|---|---|
test | 1 | 12.32 | 12.32.43.41 | 1341235253 |
lhub | 2 | 10.5 | 10.32.43.41 | 1341230253 |
SQL
| Code Block |
|---|
fieldnamesStatistics(table) |
Output
fieldname | dataType | count | distinctCount | min | max | mean | stdev | values |
|---|---|---|---|---|---|---|---|---|
name | string | 2 | 2 | NaN | NaN | NaN | NaN | [{"value":"test","count":1},{"value":"lhub","count":1}] |
ID | integer | 2 | 2 | 1.0 | 2.0 | 1.5 | 0.7071067811865476 | [{"value":"1","count":1}] |
floatVal | float | 2 | 2 | 10.5 | 12.319999694824219 | 11.40999984741211 | 1.286934125967652 | [{"value":"12.32","count":1}] |
IP | string | 2 | 2 | NaN | NaN | NaN | NaN | [{"value":"12.32.43.41","count":1},{"value":"10.32.43.41","count":1}] |
longVal | bigint | 2 | 2 | 1.341230253E9 | 1.341235253E9 | 1.341232753E9 |