Parallel partition-wise insert sub-select

A computer-implemented method, comprising:

• receiving a first query statement to insert rows of a source table into a target table;
• generating a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table;
• instructing a second database server node storing the first partition of the source table and a first partition of the target table to execute the second query statement to insert the rows of the first partition of the source table into the first partition of the target table;
• and
• instructing a third database server node storing the second partition of the source table and a second partition of the target table to execute the third query statement to insert the rows of the second partition of the source table into the second partition of the target table.

A computer-readable medium storing program code executable by a computing system to cause the computing system to:

• receive a database query, the query comprising a first query statement to insert rows of a source table into a target table;
• generate a second query statement and a third query statement based on the first query statement, the second query statement to insert rows of a first partition of the source table into the target table and the third query statement to insert rows of a second partition of the source table into the target table;
• generate a first query operator executable to perform the second query statement;
• generate a second query operator executable to perform the third query statement;
• transmit the first executable query operator to a second database server node storing the first partition of the source table;
• and
• transmit the second executable query operator to a third database server node storing the second partition of the source table.