out of memory when do a insert as select query

What happens?

I attached a mysql database with large dataset, and want to transfer into duckdb. So I ran a create table as select statement. but got out of memory error. What can I do?

To Reproduce

create table dasale as select change_date,sum(qty),sum(amt),sum(amtlist) from mysqldb.da_sale group by change_date;

OS:

Windows

MySQL Version:

doris

DuckDB Version:

0.9.2

DuckDB Client:

cli

Full Name:

kaala

Affiliation:

kaala

Have you tried this on the latest `main` branch?

[X] I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

[X] I agree

duckdb / duckdb_mysql

out of memory when do a insert as select query #34

What happens?

To Reproduce

OS:

MySQL Version:

DuckDB Version:

DuckDB Client:

Full Name:

Affiliation:

Have you tried this on the latest `main` branch?

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

duckdb / duckdb_mysql

out of memory when do a insert as select query #34

What happens?

To Reproduce

OS:

MySQL Version:

DuckDB Version:

DuckDB Client:

Full Name:

Affiliation:

Have you tried this on the latest main branch?

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

Have you tried this on the latest `main` branch?