- StarRocks
- Introduction to StarRocks
- Quick Start
- Table Design
- Data Loading
- Overview of data loading
- Load data from a local file system or a streaming data source using HTTP PUT
- Load data from HDFS or cloud storage
- Continuously load data from Apache Kafka®
- Bulk load using Apache Sparkâ„¢
- Load data using INSERT
- Load data using Stream Load transaction interface
- Realtime synchronization from MySQL
- Continuously load data from Apache Flink®
- Change data through loading
- Transform data at loading
- Data Unloading
- Using StarRocks
- Administration
- Deployment
- Management
- Data Recovery
- User Privilege and Authentication
- Performance Tuning
- Reference
- SQL Reference
- Keywords
- User Account Management
- 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 COMPUTE NODES
- SHOW FRONTENDS
- SHOW FULL COLUMNS
- SHOW INDEX
- SHOW PLUGINS
- SHOW PROCESSLIST
- SHOW TABLE STATUS
- SHOW FILE
- UNINSTALL PLUGIN
- DDL
- ALTER DATABASE
- ALTER MATERIALIZED VIEW
- ALTER TABLE
- ALTER VIEW
- ALTER RESOURCE
- ANALYZE TABLE
- BACKUP
- CANCEL BACKUP
- CANCEL RESTORE
- CREATE ANALYZE
- CREATE EXTERNAL CATALOG
- 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 ANALYZE
- DROP STATS
- DROP CATALOG
- DROP DATABASE
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP REPOSITORY
- DROP RESOURCE
- DROP TABLE
- DROP VIEW
- DROP FUNCTION
- HLL
- KILL ANALYZE
- RECOVER
- REFRESH EXTERNAL TABLE
- RESTORE
- SHOW ANALYZE JOB
- SHOW ANALYZE STATUS
- SHOW META
- SHOW RESOURCES
- SHOW FUNCTION
- TRUNCATE TABLE
- DML
- ALTER ROUTINE LOAD
- BROKER LOAD
- CANCEL LOAD
- CANCEL EXPORT
- CANCEL REFRESH MATERIALIZED VIEW
- DELETE
- EXPORT
- GROUP BY
- INSERT
- PAUSE ROUTINE LOAD
- REFRESH MATERIALIZED VIEW
- RESUME ROUTINE LOAD
- ROUTINE LOAD
- SELECT
- SHOW ALTER
- SHOW ALTER MATERIALIZED VIEW
- SHOW BACKUP
- SHOW CATALOGS
- SHOW CREATE MATERIALIZED VIEW
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW DATA
- SHOW DATABASES
- SHOW DELETE
- SHOW DYNAMIC PARTITION TABLES
- SHOW EXPORT
- SHOW LOAD
- SHOW MATERIALIZED VIEW
- 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
- Auxiliary Commands
- Function Reference
- 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
- time_slice
- timestampadd
- timestampdiff
- to_date
- to_days
- unix_timestamp
- utc_timestamp
- week
- weekofyear
- year
- hours_diff
- minutes_diff
- months_diff
- seconds_diff
- weeks_diff
- years_diff
- Aggregate Functions
- Geographic Functions
- String Functions
- JSON Functions
- Overview of JSON functions and operators
- JSON operators
- JSON constructor functions
- JSON query and processing functions
- Bitmap Functions
- Array Functions
- cast function
- hash function
- Cryptographic Functions
- Math Functions
- Utility Functions
- Date Functions
- System variables
- Error code
- System limits
- SQL Reference
- FAQ
- Deploy
- Data Migration
- SQL
- Other FAQs
- Benchmark
Edit
StarRocks version 1.19
1.19.0
Release date: Octorber 22, 2021
New Feature
- Implement Global Runtime Filter, which can enable runtime filter for shuffle join.
- CBO Planner is enabled by default, improved colocated join, bucket shuffle, statistical information estimation, etc.
- [Experimental Function] Primary Key model release: To better support real-time/frequent update feature, StarRocks has added a new table type: primary key model. The model supports Stream Load, Broker Load, Routine Load and also provides a second-level synchronization tool for MySQL data based on Flink-cdc.
- [Experimental Function] Support write function for external tables. Support writing data to another StarRocks cluster table by external tables to solve the read/write separation requirement and provide better resource isolation.
Improvement
StarRocks
- Performance optimization.
- count distinct int statement
- group by int statement
- or statement
- Optimize disk balance algorithm. Data can be automatically balanced after adding disks to a single machine.
- Support partial column export.
- Optimize show processlist to show specific SQL.
- Support multiple variable settings in SET_VAR .
- Improve the error reporting information, including table_sink, routine load, creation of materialized view, etc.
StarRocks-DataX Connector
- Support setting interval flush StarRocks-DataX Writer.
Bug Fixes
- Fix the issue that the dynamic partition table cannot be created automatically after the data recovery operation is completed. # 337
- Fix the problem of error reported by row_number function after CBO is opened.
- Fix the problem of FE stuck due to statistical information collection
- Fix the problem that set_var takes effect for session but not for statements.
- Fix the problem that select count(*) returns abnormality on the Hive partition external table.
1.19.1
Release date: November 2, 2021
Improvement
- Optimize the performance of
show frontends. # 507 # 984 - Add monitoring of slow queries. # 502 # 891
- Optimize the fetching of Hive external metadata to achieve parallel fetching.# 425 # 451
Bug Fixes
- Fix the problem of Thrift protocol compatibility, so that the Hive external table can be connected with Kerberos. # 184 # 947 # 995 # 999
- Fix several bugs in view creation. # 972 # 987# 1001
- Fix the problem that FE cannot be upgraded in grayscale. # 485 # 890
1.19.2
Release date: November 20, 2021
Improvement
Bug Fixes
- Fix the problem that repeat node cannot do predicate push-down# 1410 # 1417
- Repair the problem that routine load may lost data when the cluster alter leader node during import.# 1074 # 1272
- Fix the problem that creation view cannot support union # 1083
- Fix some stability issues of Hive external table# 1408
- Fix an issue with group by view# 1231
1.19.3
Release date: November 30, 2021
Improvement
- Upgrade jprotobuf version to improve security # 1506
Bug Fixes
- Fix some problems with group by result correctness
- Fix some problems with grouping sets# 1395 # 1119
- Fix the problem of some indicators of date_format
- Fix a boundary condition issue with aggregated streamming# 1584
- For details, please refer tolink
1.19.4
Release date: December 9, 2021
Improvement
Bug Fixes
- Fix the bug of wrong query result with predicate Cross Join # 1918
- Fix the bug of decimal type and time type conversion # 1709 # 1738
- Fix the bug of colocate join/replicate join selection error # 1727
- Fix several plan cost calculation problems
1.19.5
Release date: December 20, 2021
Improvement
Bug Fixes
- Upgrade Log4j2 to 2.17.0, fix security vulnerabilities# 2284# 2290
- Fix the problem of empty partition in Hive external table# 707# 2082
1.19.7
Release date: March 18, 2022
Bug Fixes
The following bugs are fixed: