Reference

🗃️ Data Types

5 items

📄️ Keywords

This topic describes non-reserved keywords and reserved keywords. It provides a list of reserved keywords in StarRocks.

🗃️ SQL Statements

12 items

🗃️ SQL Functions

25 items

🗃️ Information Schema

32 items

🗃️ HTTP API

1 items

📄️ AUTO_INCREMENT

Since version 3.0, StarRocks supports the AUTOINCREMENT column attribute, which can simplify data management. This topic introduces the application scenarios, usage and features of the AUTOINCREMENT column attribute.

📄️ Generated columns

Since v3.1, StarRocks supports generated columns. Generated columns can be used to accelerate queries with complex expressions. This feature supports precomputing and storing the results of expressions and query rewrites, which significantly accelerates queries with the same complex expressions.

📄️ Prepared statements

From v3.2 onwards, StarRocks provides prepared statements for executing SQL statements multiple times with the same structure but different variables. This feature significantly improves execution efficiency and prevents SQL injection.

📄️ System variables

StarRocks provides many system variables that can be set and modified to suit your requirements. This section describes the variables supported by StarRocks. You can view the settings of these variables by running the SHOW VARIABLES command on your MySQL client. You can also use the SET command to dynamically set or modify variables. You can make these variables take effect globally on the entire system, only in the current session, or only in a single query statement.

📄️ User-defined variables

This topic describes how to declare and use user-defined variables.

📄️ System limits

This topic describes the rules and limits that apply when you use StarRocks.

📄️ AWS IAM policies

A policy in AWS IAM declares a set of permissions on a specific AWS resource. After creating a policy, you need to attach it to an IAM role or user. As such, the IAM role or user is assigned the permissions declared in the policy to access the specified AWS resource.

📄️ Error Codes

This section describes the common error codes for query requests.