27.13. pga_file_column_statistics Metadata Table #

This metadata table contains statistics of analytical table columns in the context of Parquet files.

Column Name

Column Type

Constraint

Description

data_file_id

BIGINT

Primary key, foreign key

The ID of the Parquet file from the pga_data_file metadata table.

column_id

BIGINT

Primary key, foreign key

The ID of the column from the pga_column metadata table.

column_size

BIGINT

NOT NULL

The column size, in bytes.

value_count

BIGINT

NOT NULL

The number of column elements in the Parquet file.

This is not the same as the number of Parquet file entries since there can be nested entries, 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.

You can use it for estimating the upper bound of the minimum column value.

max_value

VARCHAR

-

The maximum column value in the Parquet file.

You can use it for estimating the lower bound of the maximum column value.