17.3. ANALYZE

Synopsis

ANALYZE table_name [ WITH ( property_name = expression [, ...] ) ]

Description

Collects table and column statistics for a given table.

The optional WITH clause can be used to provide connector-specific properties. To list all available properties, run the following query:

SELECT * FROM system.metadata.analyze_properties

Currently, this statement is only supported by the Hive connector.

Examples

Analyze table web to collect table and column statistics:

ANALYZE web;

Analyze table stores in catalog hive and schema default:

ANALYZE hive.default.stores;

Analyze partitions '1992-01-01', '1992-01-02' from a Hive partitioned table sales:

ANALYZE hive.default.sales WITH (partitions = ARRAY[ARRAY['1992-01-01'], ARRAY['1992-01-02']]);

Analyze partitions with complex partition key (state and city columns) from a Hive partitioned table customers:

ANALYZE hive.default.customers WITH (partitions = ARRAY[ARRAY['CA', 'San Francisco'], ARRAY['NY', 'NY']]);

Analyze only columns department and product_id for partitions '1992-01-01', '1992-01-02' from a Hive partitioned table sales:

ANALYZE hive.default.sales WITH (
    partitions = ARRAY[ARRAY['1992-01-01'], ARRAY['1992-01-02']],
    columns = ARRAY['department', 'product_id']);