Skip to main content
Version: 2.5

Create a table

This QuickStart tutorial will walk you through the necessary steps to create a table in StarRocks, and introduce some basic features of StarRocks.

After the StarRocks instance is deployed (see Deploy StarRocks for details), you need to create a database and a table to load and query data. Creating databases and tables requires corresponding user privilege. In this QuickStart tutorial, you can perform the following steps with the default root user, which has the highest privileges on the StarRocks instance.


You can complete this tutorial by using an existing StarRocks instance, database, table, and user privilege. However, for simplicity, we recommend that you use the schema and data the tutorial provides.

Step 1: Log in to StarRocks

Log in to StarRocks via your MySQL client. You can log in with the default user root, and the password is empty by default.

mysql -h <fe_ip> -P<fe_query_port> -uroot


  • Change the -P value accordingly if you have assigned a different FE MySQL server port (query_port, Default: 9030).
  • Change the -h value accordingly if you have specified the configuration item priority_networks in the FE configuration file.

Step 2: Create a database

Create a database named sr_hub by referring to CREATE DATABASE.


You can view all databases in this StarRocks instance by executing SHOW DATABASES SQL.

Step 3: Create a table

Run USE sr_hub to switch to the sr_hub database and create a table named sr_member by referring to CREATE TABLE.

USE sr_hub;
sr_id INT,
name STRING,
city_code INT,
reg_date DATE,
verified BOOLEAN
PARTITION p1 VALUES [('2022-03-13'), ('2022-03-14')),
PARTITION p2 VALUES [('2022-03-14'), ('2022-03-15')),
PARTITION p3 VALUES [('2022-03-15'), ('2022-03-16')),
PARTITION p4 VALUES [('2022-03-16'), ('2022-03-17')),
PARTITION p5 VALUES [('2022-03-17'), ('2022-03-18'))


  • To create a table in StarRocks, you MUST specify a bucket key in the DISTRIBUTED BY HASH clause to strategize the data distribution plan of the table. By default, the data is distributed to 10 tablets. See Data Distribution for more information.
  • You need to specify the table property replication_num, which represents the number of data replicas, as 1 because the StarRocks instance you deployed has only one BE node.
  • If no table type is specified, a Duplicate Key table is created by default. See Duplicate Key table
  • The columns of the table exactly correspond to the fields of data that you will be loading into StarRocks in the tutorial on loading and querying data.
  • To guarantee the high performance in the production environment, we strongly recommend that you strategize the data partitioning plan for the table by using the PARTITION BY clause. See Design partitioning and bucketing rules for more instructions.

After the table is created, you can check the details of the table using the DESC statement, and view all the tables in the database by executing SHOW TABLES. Tables in StarRocks support schema changes. You can see ALTER TABLE for more information.

What to do next

To learn more about conceptual details of StarRocks tables, see StarRocks Table Design.

In addition to the features this tutorial has demonstrated, StarRocks also supports: