Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementANALYZE TABLES
ANALYZE TABLES
Last updated: 2024-08-07 17:19:54
Description
Supported engines: Presto and SparkSQL
Purpose: Perform statistics on a database table.
Statement
ANALYZE TABLES [ { FROM | IN } database_name ] COMPUTE STATISTICS [ NOSCAN ]ANALYZE TABLE table_identifier[ PARTITION ( partition_col_name [ = partition_col_val ] [ , ... ] ) ]COMPUTE STATISTICS [ NOSCAN | FOR COLUMNS col [ , ... ] | FOR ALL COLUMNS ]
Parameter
database_name: Name of the database on which table statistics are performed.table_identifier: Name of the table on which statistics are performed.partition_col_name: Name of the column in the partitioned table on which statistics are performed.partition_col_value: Values in the column of the partitioned table on which statistics are performed.Example
ANALYZE TABLE students COMPUTE STATISTICSANALYZE TABLE students COMPUTE STATISTICS FOR COLUMNS nameANALYZE TABLE db.students COMPUTE STATISTICS FOR COLUMNS nameANALYZE TABLE students COMPUTE STATISTICS NOSCANANALYZE TABLE students COMPUTE STATISTICS FOR all COLUMNSANALYZE TABLE db.students COMPUTE STATISTICS FOR all COLUMNSANALYZE TABLE students PARTITION (student_id) COMPUTE STATISTICSANALYZE TABLE students PARTITION (student_id = 111111) COMPUTE STATISTICSANALYZE TABLE db.students PARTITION (student_id = 111111, name = 'test') COMPUTE STATISTICS FOR all COLUMNSANALYZE TABLES COMPUTE STATISTICSANALYZE TABLES COMPUTE STATISTICS NOSCANANALYZE TABLES from school_db COMPUTE STATISTICS NOSCANANALYZE TABLES IN school_db COMPUTE STATISTICS NOSCAN
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No