I’m trying to transfer all data from a source table to a target table (which is empty).
When I execute an SQL similar to “insert into X select * from Y” I constantly get the following error message:
ERROR: command is too large: 69082049 bytes (max: 67108864)
My source table has ~130 million rows, total file size as exported as CSV uncompressed is ~40GBs.
I did use the SQL statement “IMPORT TABLE…” to initially import all values into a (temporary for me) table, and that worked fine.
How can I copy all that data internally within CRDB from table “A” (all data) to table “B” (empty) without running into the above mentioned error?
(the source & trgt tables would not be identical → I have to perform some transformations on some columns)