Performence of use insert ...select statement to copy a table

when I use insert into …select statement to copy a table, found this statement execute very slowly and raise a error finally.

The DDL of test table is:
show create table zy;
table_name | create_statement
±-----------±-----------------------------------+
zy | CREATE TABLE zy (
| a INT8 NULL,
| b VARCHAR(50) NULL,
| FAMILY “primary” (a, b, rowid)
| )
(1 row)

The procedure of test:
root@192.168.29.23:26257/defaultdb> create table zy(a int,b varchar(50));
CREATE TABLE

Time: 449.516237ms

root@192.168.29.23:26257/defaultdb> insert into zy values(1,‘asdfaf’);
INSERT 1

Time: 308.685522ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 1

Time: 29.773838ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 2

Time: 60.600229ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 4

Time: 39.453024ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 8

Time: 241.59724ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 16

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 32

Time: 63.791129ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 64

Time: 68.946548ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 128

Time: 31.124649ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 256

Time: 131.906187ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 512

Time: 35.199813ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 1024

Time: 45.385228ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 2048

Time: 132.150774ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 4096

Time: 187.157625ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 8192

Time: 263.270649ms

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;
INSERT 16384

Time: 1.056612888s

root@192.168.29.23:26257/defaultdb> insert into zy select * from zy;

and then the statement block here… until raise a error

Hi @YongZhu,

We are aware of this limitation.

You can follow our discussion here.

Thanks,
Matt

Thanks, Matt!

I will pay attention to this issue continuly.

No problem, let me know if you have any other questions.