ANALYZE

Updated on 2022-11-18 GMT+08:00

View PDF

Syntax

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

Description

This statement is used to collects statistics on tables and columns in a specified table.

The WITH clause is optional and can be used to specify connector properties. Run the SELECT * FROM system.metadata.analyze_properties command to list all available properties. Currently, only the Hive connector supports this property.

Example

Collect the statistics of table fruit:
```
ANALYZE fruit;
```
To collect statistics on table storage in catalog hive and schema default:
```
ANALYZE hive.default.orders;
```

Collect information about the 2020-07-17 and 2020-07-18 partitions from the Hive partition table:

ANALYZE hive.web.page_views WITH (partitions = ARRAY[ARRAY['2020-07-17','US'], ARRAY['2020-07-18','US']]);

Parent topic: Auxiliary Command Syntax

Previous topic: REFRESH TABLE

Next topic: CALL

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel