StartRocks 连接 Paimon外部表_starrocks访问paimon数据-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_15138049/article/details/134716970

本文介绍了如何在StartRocks数据库环境中设置Paimon3.2.00.5的外部catalog，包括创建、切换和操作Paimon_hdfscatalog下的databases和tables的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

版本

StartRocks	Paimon
3.2.0	0.5

sr 环境准备

在这里插入图片描述

CREATE external CATALOG `paimon_hdfs` PROPERTIES (
    "type" = "paimon",
    'paimon.catalog.type' = 'filesystem',
    "paimon.catalog.warehouse" = "hdfs://hadoop03:9000/paimon/test"
);

mysql> show catalogs;
+-----------------+----------+------------------------------------------------------------------+
| Catalog         | Type     | Comment                                                          |
+-----------------+----------+------------------------------------------------------------------+
| default_catalog | Internal | An internal catalog contains this cluster's self-managed tables. |
| paimon_hdfs     | Paimon   | NULL                                                             |
+-----------------+----------+------------------------------------------------------------------+
2 rows in set (0.01 sec)

### 切换catalog
mysql> set catalog paimon_hdfs;
Query OK, 0 rows affected (0.01 sec)

### 查询某个catalog 下的databases
mysql> show databases from paimon_hdfs;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| tpchdb             |
+--------------------+
2 rows in set (1.01 sec)

mysql> use paimon_hdfs.tpchdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------+
| Tables_in_tpchdb |
+------------------+
| abc              |
| def              |
+------------------+
2 rows in set (0.29 sec)

mysql> select * from abc;
+------+------+
| id   | name |
+------+------+
| 1    | b    |
| a    | k    |
| a1   | k    |
| b1   | b    |
+------+------+
4 rows in set (1.66 sec)