说明
支持内核:Presto、SparkSQL。
用途:支持对数据库表进行统计。
语法
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 ]
参数
database_name
:需要计算统计信息的表所在的数据库。table_identifier
:需要计算统计信息的表名。partition_col_name
:需要计算统计信息的分区列名。partition_col_value
:需要计算统计信息的分区列的值。示例
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