向 Stage 写文件,再从外表读回¶
在单机测试环境的 MatrixOne 服务端先运行 mkdir -p /tmp/mo-cookbook-stage,确认服务进程可写;或把下方 file:// Stage 换成已配置的 S3/MinIO Stage。写入采用新文件名,因此示例使用独立 Stage 目录。
CREATE DATABASE cookbook_files;
CREATE STAGE cookbook_stage URL='file:///tmp/mo-cookbook-stage/';
CREATE TABLE cookbook_files.src(id INT, label VARCHAR(20));
INSERT INTO cookbook_files.src VALUES (1,'one'),(2,'two');
CREATE EXTERNAL TABLE cookbook_files.exported(id INT, label VARCHAR(20))
INFILE{'filepath'='stage://cookbook_stage/rows_*.csv',
'format'='csv',
'write_file_pattern'='stage://cookbook_stage/rows_%U.csv'}
FIELDS TERMINATED BY ',';
INSERT INTO cookbook_files.exported SELECT * FROM cookbook_files.src;
SELECT COUNT(*) AS rows_written FROM cookbook_files.exported;
DROP DATABASE cookbook_files;
DROP STAGE cookbook_stage;
rows_written 应为 2。文件仍在 Stage 底层存储中;确认目录仅含本实验文件后再手动删除。完整的第二次写入、CSV 转义和 JSONLine 情形见源码 往返测试。