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

• Introduction
• Quick Start
  • Concepts
  • Architecture
  • Deploy
  • Data Flow and Control Flow
  • Import and Query
  • Test FAQs
• Table Design
  • Understand StarRocks table design
  • Data models
  • Data distribution
  • Sort keys and prefix indexes
  • Materialized View
  • Bitmap Indexing
  • Bloomfilter Indexing
• Data Loading
  • Overview of data loading
  • Load data from a local file system or a streaming data source using HTTP push
  • Load data from HDFS or cloud storage
  • Routine Load
  • Spark Load
  • Insert Into
  • Change data through loading
  • Transform data at loading
  • Json Loading
  • Synchronize data from MySQL
  • Load data by using flink-connector-starrocks
  • DataX Writer
• Data Export
  • Export
  • Spark Connector
  • Flink Connector
• Using StarRocks
  • Precise De-duplication with Bitmap
  • Approximate De-duplication with HLL
  • Materialized View
  • Colocate Join
  • External Table
  • Array
  • Cost Based Optimizer
  • Lateral Join
• Reference
  • SQL Reference
    • User Account Management
      • ALTER USER
      • CREATE ROLE
      • CREATE USER
      • DROP ROLE
      • DROP USER
      • GRANT
      • REVOKE
      • SET PASSWORD
      • SET PROPERTY
      • SHOW GRANTS
    • Cluster Management
      • ADMIN CANCEL REPAIR
      • ADMIN CHECK TABLET
      • ADMIN REPAIR
      • ADMIN SET CONFIG
      • ADMIN SET REPLICA STATUS
      • ADMIN SHOW CONFIG
      • ADMIN SHOW REPLICA DISTRIBUTION
      • ADMIN SHOW REPLICA STATUS
      • ALTER SYSTEM
      • CANCEL DECOMMISSION
      • CREATE FILE
      • DROP FILE
      • INSTALL PLUGIN
      • SHOW BACKENDS
      • SHOW BROKER
      • SHOW FILE
      • SHOW FRONTENDS
      • SHOW FULL COLUMNS
      • SHOW INDEX
      • SHOW PLUGINS
      • SHOW TABLE STATUS
      • UNINSTALL PLUGIN
    • DDL
      • ALTER DATABASE
      • ALTER TABLE
      • ALTER VIEW
      • BACKUP
      • CANCEL BACKUP
      • CANCEL RESTORE
      • CREATE DATABASE
      • CREATE INDEX
      • CREATE MATERIALIZED VIEW
      • CREATE REPOSITORY
      • CREATE RESOURCE
      • CREATE TABLE AS SELECT
      • CREATE TABLE LIKE
      • CREATE TABLE
      • CREATE VIEW
      • CREATE FUNCTION
      • DROP DATABASE
      • DROP INDEX
      • DROP MATERIALIZED VIEW
      • DROP REPOSITORY
      • DROP RESOURCE
      • DROP TABLE
      • DROP VIEW
      • DROP FUNCTION
      • HLL
      • RECOVER
      • RESTORE
      • SHOW RESOURCES
      • SHOW FUNCTION
      • TRUNCATE TABLE
    • DML
      • ALTER ROUTINE LOAD
      • BROKER LOAD
      • CANCEL LOAD
      • DELETE
      • EXPORT
      • GROUP BY
      • INSERT
      • PAUSE ROUTINE LOAD
      • RESUME ROUTINE LOAD
      • ROUTINE LOAD
      • SELECT
      • SHOW ALTER
      • SHOW BACKUP
      • SHOW DATA
      • SHOW DATABASES
      • SHOW DELETE
      • SHOW DYNAMIC PARTITION TABLES
      • SHOW EXPORT
      • SHOW LOAD
      • SHOW PARTITIONS
      • SHOW PROPERTY
      • SHOW REPOSITORIES
      • SHOW RESTORE
      • SHOW ROUTINE LOAD
      • SHOW ROUTINE LOAD TASK
      • SHOW SNAPSHOT
      • SHOW TABLES
      • SHOW TABLET
      • SHOW TRANSACTION
      • SPARK LOAD
      • STOP ROUTINE LOAD
      • STREAM LOAD
    • Data Types
      • Numeric
        • BIGINT
        • LARGEINT
        • SMALLINT
        • TINYINT
        • BOOLEAN
        • DECIMAL
        • DOUBLE
        • FLOAT
        • INT
      • String
        • CHAR
        • VARCHAR
        • STRING
      • Date
        • DATE
        • DATETIME
      • Others
        • HLL
        • BITMAP
        • JSON
    • Auxiliary Commands
      • DESCRIBE
  • Function Reference
    • Java UDFs
    • Window Function
    • Date Functions
      • convert_tz
      • curdate
      • current_timestamp
      • curtime
      • datediff
      • date_add
      • date_format
      • date_sub
      • date_trunc
      • day
      • dayname
      • dayofmonth
      • dayofweek
      • dayofyear
      • from_days
      • from_unixtime
      • hour
      • minute
      • month
      • monthname
      • now
      • quarter
      • second
      • str_to_date
      • timediff
      • timestampadd
      • timestampdiff
      • to_date
      • to_days
      • unix_timestamp
      • utc_timestamp
      • weekofyear
      • year
      • hours_diff
      • minutes_diff
      • months_diff
      • seconds_diff
      • weeks_diff
      • years_diff
    • Aggregate Functions
      • any_value
      • approx_count_distinct
      • avg
      • bitmap
      • count
      • hll_union_agg
      • max
      • min
      • percentile_approx
      • percentile_cont
      • retention
      • stddev
      • stddev_samp
      • sum
      • variance
      • var_samp
      • window_funnel
    • Geographic Functions
      • st_astext
      • st_circle
      • st_contains
      • st_distance_sphere
      • st_geometryfromtext
      • st_linefromtext
      • st_point
      • st_polygon
      • st_x
      • st_y
    • String Functions
      • append_trailing_char_if_absent
      • ascii
      • char_length
      • concat
      • concat_ws
      • ends_with
      • find_in_set
      • get_json_double
      • get_json_int
      • get_json_string
      • group_concat
      • instr
      • lcase
      • left
      • length
      • locate
      • lower
      • lpad
      • ltrim
      • money_format
      • null_or_empty
      • regexp_extract
      • regexp_replace
      • repeat
      • reverse
      • right
      • rpad
      • split
      • split_part
      • starts_with
      • strleft
      • strright
    • JSON Functions
      • Overview of JSON functions and operators
      • JSON constructor functions
        • json_array
        • json_object
        • parse_json
      • JSON query and processing functions
        • Arrow function
        • json_query
        • json_exists
        • json_each
        • cast
      • JSON operators
    • Aggregate Functions
      • any_value
      • approx_count_distinct
      • avg
      • bitmap
      • count
      • hll_union_agg
      • max
      • min
      • percentile_approx
      • retention
      • stddev
      • stddev_samp
      • sum
      • variance
      • square
      • var_samp
    • Bitmap Functions
      • bitmap_and
      • bitmap_andnot
      • bitmap_contains
      • bitmap_empty
      • bitmap_from_string
      • bitmap_has_any
      • bitmap_hash
      • bitmap_intersect
      • bitmap_max
      • bitmap_min
      • bitmap_or
      • bitmap_remove
      • bitmap_to_string
      • bitmap_union
      • bitmap_xor
      • to_bitmap
    • Array Functions
      • array_agg
      • array_append
      • array_avg
      • array_concat
      • array_contains
      • array_difference
      • array_distinct
      • array_intersect
      • array_join
      • array_length
      • array_max
      • array_min
      • array_position
      • array_remove
      • array_slice
      • array_sort
      • array_sum
      • arrays_overlap
      • reverse
    • cast function
    • hash function
    • Cryptographic Functions
      • md5
      • sha2
    • Math Functions
      • RAND
      • square
    • Utility Functions
      • current_version
      • version
      • last_query_id
      • sleep
      • uuid
      • uuid_numeric
  • System variables
  • Error code
  • System limits
• Administration
  • Build in Docker
  • Manage a cluster
  • Configuration
  • Scale In and Out
  • Backup and Restore
  • Configure a time zone
  • Data Recovery
    • Data Recovery
    • Restore FEs
  • Replica
  • Query Planning
  • Profiling
  • Monitor and Alert
  • User Privilege
  • Authentication
  • Resource Management
    • Resource Group
    • Query Management
    • Blacklist
    • Memory Management
    • Load Balance
    • File manager
• FAQ
  • Deploy
  • Data Migration
    • Data Ingestion
      • Data Ingestion
      • Stream Load
      • Routine Load
      • Broker Load
      • Insert Into
      • Flink connector
      • DataX
    • Data Export
  • SQL
  • 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
    • IDE Setup
    • IDEA
    • Build_StarRocks_on_Ubuntu
    • Build_Handbook
  • Trace Tools
    • Trace
• Integration
  • Integrate with StarRocks
  • Authenticate to AWS resources

2.2English(US)

---