mysql - 如何对MySQL分区表的每个分区并行执行sql

Question

有一个分区表A，有4个分区，我想加载数据到表B。

insert into B select * from A partion (p0) where type = 0;
insert into B select * from A partion (p1) where type = 0;
insert into B select * from A partion (p2) where type = 0;
insert into B select * from A partion (p3) where type = 0;

如何并行加载每个分区的数据。仅在一个连接中。

Answer 1

尝试 Apache Spark。

Great Documentation at this link

These options must all be specified if any of them is specified. They describe how to partition the table when reading in parallel from multiple workers. partitionColumn must be a numeric column from the table in question. Notice that lowerBound and upperBound are just used to decide the partition stride, not for filtering the rows in table. So all rows in the table will be partitioned and returned. This option applies only to reading.