Table, bucket, partition, and index
ALTER TABLE
ALTER TABLE Modifies an existing table, including:
CANCEL ALTER TABLE
CANCEL ALTER TABLE cancels the execution of the ongoing ALTER TABLE operation, including:
CREATE INDEX
CREATE INDEX is used to create only Bitmap indexes. For usage notes and scenarios of Bitmap indexes, see Bitmap index.
CREATE TABLE
Create a new table in StarRocks.
CREATE TABLE AS SELECT
Use the CREATE TABLE AS SELECT (CTAS) statement to synchronously or asynchronously query a table and create a new table based on the query result, and then insert the query result into the new table.
CREATE TABLE LIKE
CREATE TABLE LIKE creates an identical empty table based on the definition of another table. The definition includes column definition, partitions, and table properties. You can copy an external table such as MySQL.
DELETE
Deletes data rows from a table based on the specified conditions. The table can be a partitioned or non-partitioned table.
DESC
DESC is used to view table schemas:
DROP INDEX
DROP INDEX is used to drop a specified index on a table. Currently, only bitmap index is supported in this version.
DROP TABLE
DROP TABLE is used to delete a table.
REFRESH EXTERNAL TABLE
REFRESH EXTERNAL TABLE metadata cached in StarRocks. The metadata is from tables in data lakes. This statement is used in the following scenarios:
SELECT
SELECT queries data from one or more tables, views, or materialized views. The SELECT statement generally consists of the following clauses:
SHOW ALTER TABLE
SHOW ALTER TABLE shows the execution of the ongoing ALTER TABLE operations, including:
SHOW CREATE TABLE
Returns the CREATE TABLE statement that was used to create a given table.
SHOW DELETE
SHOW DELETE queries historical DELETE operations that were successfully performed on Duplicate Key, Unique Key, and Aggregate tables in a specified database. For more information about data deletion, see DELETE.
SHOW DYNAMIC PARTITION TABLES
SHOW DYNAMIC PARTITION TABLES is used to display the status of all the partitioned tables for which dynamic partitioning properties are configured in a database.
SHOW FULL COLUMNS
SHOW FULL COLUMNS is used to show content in columns from specified tables.
SHOW INDEX
SHOW INDEX is used to show information related to index in a table. It currently only supports bitmap index.
SHOW PARTITIONS
SHOW PARTITIONS displays partition information, including common partitions and temporary partitions.
SHOW TABLES
SHOW TABLES displays all tables in a StarRocks database or a database in an external data source, for example, Hive, Iceberg, Hudi, or Delta Lake.
SHOW TABLET
SHOW TABLET displays tablet related information.
TRUNCATE TABLE
TRUNCATE TABLE is used to truncate the specified table and partition data.
UPDATE
Updates rows in a Primary Key table.
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.