...
Please note that table and column aliases are not supported in the analyze statement.
To view column stats :
describe formatted [table_name] [column_name];
Metastore Schema
To persist column level statistics, we propose to add the following new tables,
...
LOW_VALUE RAW,
HIGH_VALUE RAW,
NUM_NULLS BIGINT,
NUM_DISTINCTS BIGINT,
BIT_VECTOR, VARCHAR(16400)BLOB, /* introduced in HIVE-16997 in Hive 3.0.0 */
AVG_COL_LEN DOUBLE,
MAX_COL_LEN BIGINT,
NUM_TRUES BIGINT,
NUM_FALSES BIGINT,
LAST_ANALYZED BIGINT NOT NULL)
...
LOW_VALUE RAW,
HIGH_VALUE RAW,
NUM_NULLS BIGINT,
NUM_DISTINCTS BIGINT,
BIT_VECTOR, VARCHAR(16400)BLOB, /* introduced in HIVE-16997 in Hive 3.0.0 */
AVG_COL_LEN DOUBLE,
MAX_COL_LEN BIGINT,
NUM_TRUES BIGINT,
NUM_FALSES BIGINT,
LAST_ANALYZED BIGINT NOT NULL)
...