目錄

一、背景

二、實操

三、查看導入進度

---

一、背景

將hive庫數據表導入starrocks.

二、實操

LOAD LABEL user_behavior
(DATA INFILE("hdfs://<hdfs_ip>:<hdfs_port>/user/amber/user_behavior_ten_million_rows.parquet")INTO TABLE user_behaviorFORMAT AS "parquet")WITH BROKER
("hadoop.security.authentication" = "simple","username" = "<hdfs_username>","password" = "<hdfs_password>"
)
PROPERTIES
("timeout" = "72000"
);

三、查看導入進度

SELECT * FROM information_schema.loads where label='user_behavior';