CrateDB backup table From one table to another table

Hi Team,

Hope everyone is doing great.

I want to some help regrading restore Cratedb. I want to restore one table into another table.

We have table which is around 200 GB. and want to restore or make copy that table but table structure is little different. while we inserting into copy table from main table below error occurs.

CircuitBreakingException[[parent] Data too large, data for [collect: 0] would be [3064355594/2.8gb], which is larger than the limit of [3060164198/2.8gb], usages [request=0/0b, in_flight_requests=0/0b, query=1272381900/1.1gb, jobs_log=14022688/13.3mb, operations_log=4558672/4.3mb, accounting=121276142/115.6mb]]

Can we restore One table into another ?

1 Like

One option for this could be to use insert-from-sql