horaedb icon indicating copy to clipboard operation
horaedb copied to clipboard

feat: support INSERT INTO SELECT

Open dracoooooo opened this issue 1 year ago • 2 comments

Close #557

Rationale

INSERT INTO SELECT is useful to migrate table, benchmark(to quickly generate lots of data).

Detailed Changes

When generating the insert logical plan, alse generate the select logical plan and store it in the insert plan. Then execute the select logical plan in the insert interpreter, convert the result records into RowGroup and then insert it.

Test Plan

integration test

dracoooooo avatar May 29 '24 15:05 dracoooooo

@dracoooooo Hi, it seems there are some CI errors, would you mind take a look?

jiacai2050 avatar May 30 '24 02:05 jiacai2050

@dracoooooo Hi, it seems there are some CI errors, would you mind take a look?

Due to #1538, the newly added integration test seems unable to consistently pass in the cluster environment.

dracoooooo avatar Jun 02 '24 11:06 dracoooooo