38.13. pga_file_column_statistics #

This metadata table contains column-level statistics for each Parquet file of an analytical table.

Column Name

Column Type

Constraint

Description

data_file_id

BIGINT

Primary key, foreign key

The ID of the Parquet file that contains the column, from the pga_data_file metadata table.

column_id

BIGINT

Primary key, foreign key

The ID of the column for which statistics are collected, from the pga_column metadata table.

column_size

BIGINT

NOT NULL

The column size, in bytes.

value_count

BIGINT

NOT NULL

The number of values for the column in the Parquet file.

This is not the same as the number of rows since the column can contain nested types, such as structures and lists.

null_count

BIGINT

NOT NULL

The number of NULL values in the column.

min_value

VARCHAR

-

The minimum column value in the Parquet file.

It can serve as an upper bound estimate for the minimum column value.

max_value

VARCHAR

-

The maximum column value in the Parquet file.

It can serve as a lower bound estimate for the maximum column value.