StarRocks

This documentation is a guide for using Paimon in StarRocks.

Version

Paimon currently supports StarRocks 3.1 and above. Recommended version is StarRocks 3.2.6 or above.

Create Paimon Catalog

Paimon catalogs are registered by executing a CREATE EXTERNAL CATALOG SQL in StarRocks. For example, you can use the following SQL to create a Paimon catalog named paimon_catalog.

CREATE EXTERNAL CATALOG paimon_catalog
PROPERTIES
(
"type" = "paimon",
"paimon.catalog.type" = "filesystem",
"paimon.catalog.warehouse" = "oss://<your_bucket>/user/warehouse/"
);

More catalog types and configures can be seen in Paimon catalog.

Query

Suppose there already exists a database named test_db and a table named test_tbl in paimon_catalog, you can query this table using the following SQL:

SELECT * FROM paimon_catalog.test_db.test_tbl;

Query System Tables

You can access all kinds of Paimon system tables by StarRocks. For example, you can read the ro (read-optimized) system table to improve reading performance of primary-key tables.

SELECT * FROM paimon_catalog.test_db.test_tbl$ro;

For another example, you can query partition files of the table using the following SQL:

SELECT * FROM paimon_catalog.test_db.partition_tbl$partitions;
/*
+-----------+--------------+--------------------+------------+----------------------------+
| partition | record_count | file_size_in_bytes | file_count | last_update_time           |
+-----------+--------------+--------------------+------------+----------------------------+
| [1]       |            1 |                645 |          1 | 2024-01-01 00:00:00.000000 |
+-----------+--------------+--------------------+------------+----------------------------+
*/

StarRocks to Paimon type mapping

This section lists all supported type conversion between StarRocks and Paimon. All StarRocks’s data types can be found in this doc StarRocks Data type overview.