Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can not load data to duckdb #18

Closed
ChampionNan opened this issue Mar 10, 2024 · 2 comments
Closed

Can not load data to duckdb #18

ChampionNan opened this issue Mar 10, 2024 · 2 comments

Comments

@ChampionNan
Copy link

Hi,

Using the files from the link, I found several tables, there were some errors in the data. And I can't load them to DuckDB. What should I do?
Eg. Error: Invalid Input Error: CSV Error on Line: 610 Value with unterminated quote found.

Thanks!
@ChampionNan
Copy link
Author

Several tables could be fixed by using the method in #10 (comment). But there is still one table could not be fixed, so I just use the ignore_errors flag. Is there any better method to solve such problems?

@ChampionNan
Copy link
Author

https://github.com/duckdb/duckdb/blob/main/benchmark/imdb/init/load.sql
Use this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ChampionNan