StarRocks
StarRocks is a high-performance analytical data warehouse that uses vectorization, MPP architecture, and a real-time updateable columnar storage engine to achieve multi-dimensional, real-time, and highly concurrent data analysis. StarRocks supports efficient data import from various real-time and offline data sources, and also supports direct analysis of data in various formats on the data lake. StarRocks is compatible with the MySQL protocol and can be connected to common BI tools using the MySQL client. At the same time, StarRocks has the characteristics of horizontal expansion, high availability, high reliability, and easy operation and maintenance. It is widely used in real-time data warehouses, OLAP reports, data lake analysis, and other scenarios.
StarRocks data source property configuration:
| Property | English | Description |
|---|---|---|
| Name | Name | Data source name, keep it unique |
| Use local agent | Use Local Agent | Whether to use local agent to connect to data source, otherwise use server to connect to data source |
| Host | Host | Host address domain name or IP |
| Port number | Port | Service port number |
| Interface host | Api Host | Interface service host address domain name or IP |
| Interface port number | Api Port | Interface service port number |
| User | User Name | User account used to connect to data source |
| Password | Password | User password used to connect to data source |
| Use SSL | Use SSL | Whether to use encrypted connection |
| Client certificate | CA certificate | Client certificate |