Release Notes
- v3.1
- v3.0
- v2.5
- v2.4
- v2.3
- v2.2
- v2.1
- v2.0
- v1.19

StarRocks
Introduction to StarRocks
Quick Start
Table Design
- Understand StarRocks table design
- Table types
- Data distribution
- Sort keys and prefix indexes
Data Loading
Data Unloading
Query Data Sources
- Catalog
- External tables
Query Acceleration
- Gather CBO statistics
- Materialized view
- Colocate Join
- Lateral Join
- Index
  - Bitmap indexing
  - Bloom filter indexing
- Computing the Number of Distinct Values
  - Use Bitmap for exact count distinct
  - Use HLL for approximate count distinct
Administration
- Deployment
  - Deploy StarRocks with StarGo
  - Deploy StarRocks on Kubernetes
    - Deploy StarRocks with Operator
    - Deploy StarRocks with Helm
  - Deploy CN
  - Deploy Broker
  - Deploy FE cluster with high availability
- Management
- Data Recovery
  - Data recovery
  - Restore FEs
- User Privilege and Authentication
  - User privilege
  - Authentication
- Performance Tuning
Reference
- SQL Reference
- Function Reference
  - Java UDFs
  - Window functions
  - Aggregate Functions
  - Array Functions
  - Bit Functions
  - Bitmap Functions
  - Conditional Functions
  - Cryptographic Functions
  - Date Functions
  - Geographic Functions
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sqrt
    - square
    - tan
    - truncate
  - String Functions
  - Pattern Matching Functions
  - Percentile Functions
  - Scalar Functions
    - hll_cardinality
  - Utility Functions
  - cast function
  - hash function
- System variables
- Error code
- System limits
FAQ
- Deploy
- Data Migration
  - Data Loading
  - Data Unloading
- SQL
- query_dump
- Other FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark

Developers
- Contribute to StarRocks
- Code Style Guides
  - protobuf style guides
  - thrift style guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
  - Trace

Edit

SHOW ANALYZE STATUS

Description

Views the status of collection tasks.

This statement cannot be used to view the status of custom collection tasks. To view the status of custom collection tasks, use SHOW ANALYZE JOB.

This statement is supported from v2.4.

Syntax

SHOW ANALYZE STATUS [WHERE]

You can use LILE or WHERE to filter the information to return.

This statement returns the following columns.

List name	Description
Id	The ID of the collection task.
Database	The database name.
Table	The table name.
Columns	The column names.
Type	The type of statistics, including FULL, SAMPLE, and HISTOGRAM.
Schedule	The type of scheduling. `ONCE` means manual and `SCHEDULE` means automatic.
Status	The status of the task.
StartTime	The time when the task starts executing.
EndTime	The time when the task execution ends.
Properties	Custom parameters.
Reason	The reason why the task failed. NULL is returned if the execution was successful.

References

ANALYZE TABLE: create a manual collection task.

KILL ANALYZE: cancel a custom collection task that is running.

For more information about collecting statistics for CBO, see Gather statistics for CBO.

Edit

In this article

SHOW ANALYZE STATUS