【已解决】doris 2.0.9 OUTFILE 开启并发,未生效

Viewed 67

mysql> set global enable_parallel_outfile = true;
Query OK, 0 rows affected (0.01 sec)

mysql> set parallel_fragment_exec_instance_num = 3;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM test1
-> INTO OUTFILE "hdfs://192.168.31.129:9820/doris/"
-> FORMAT AS CSV
-> PROPERTIES
-> (
-> "fs.defaultFS" = "hdfs://192.168.31.129:9820",
-> "hadoop.username" = "wyz",
-> "column_separator" = ",",
-> "line_delimiter" = "\n"
-> );
+------------+-----------+----------+---------------------------------------------------------------------+
| FileNumber | TotalRows | FileSize | URL |
+------------+-----------+----------+---------------------------------------------------------------------+
| 1 | 7 | 357 | hdfs://192.168.31.129:9820/doris/8fb60c3d31c74359-ac5c1263abd9dc36_ |
+------------+-----------+----------+---------------------------------------------------------------------+
1 row in set (1.05 sec)

2 Answers

小表失败的原因是 bucket 设置的为1