We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
👋
This issue is regarding https://duckdb.org/docs/data/json/overview
Running
CREATE TABLE todos (userId UBIGINT, id UBIGINT, title VARCHAR, completed BOOLEAN); COPY todos FROM 'todos.json';
on https://duckdb.org/data/json/todos.json raises
Invalid Input Error: Malformed JSON in file "todos.json", at byte 2 in line 2: unexpected end of data. Try auto-detecting the JSON format
Using read_json outside of COPY works.
read_json
COPY
Repro:
$ curl https://duckdb.org/data/json/todos.json -O $ head todos.json [ { "userId": 1, "id": 1, "title": "delectus aut autem", "completed": false }, { "userId": 1, "id": 2, $ duckdb --version v1.1.3 19864453f7 $ duckdb
CREATE TABLE todos (userId UBIGINT, id UBIGINT, title VARCHAR, completed BOOLEAN); COPY todos FROM 'todos.json'; -- Invalid Input Error: Malformed JSON in file "todos.json", at byte 2 in line 2: unexpected end of data. Try auto-detecting the JSON format -- but select count(*) from 'todos.json'; -- ┌──────────────┐ -- │ count_star() │ -- │ int64 │ -- ├──────────────┤ -- │ 200 │ -- └──────────────┘
The text was updated successfully, but these errors were encountered:
No branches or pull requests
👋
This issue is regarding https://duckdb.org/docs/data/json/overview
Running
on https://duckdb.org/data/json/todos.json raises
Using
read_json
outside ofCOPY
works.Repro:
The text was updated successfully, but these errors were encountered: