logo
  • 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