duckdb / duckdb/duckdb-python

`read_json` accepts a list of paths at runtime but the type stub only allows a single path.

Open
#576 1 comment 0 reactions 0 assignees View on GitHub
needs triage
Dominant language
Python
Stars
187
Forks
112
Avg merge
13h 29m
Merged PRs (30d)
17

Description

### What happens?

Hi duckdb team, big fan of the product!

I'm experiencing a small typing issue:

```python
import duckdb

con = duckdb.connect()
rel = con.read_json(
["a.jsonl", "b.jsonl"],
format="newline_delimited",
)
print(rel.count("*").fetchone())
```

This runs fine and returns the union of both files.

However, pyright throws:
`Argument of type "list[str]" cannot be assigned to parameter "path_or_buffer" of type "str | bytes | PathLike[str] | PathLike[bytes] | IO[bytes] | IO[str]"`

mypy throws a similar error.

Adding `list[str]` (and probably `list[PathLike]`) to `path_or_buffer` in the Python stub would fix this

### To Reproduce

```python
import duckdb

con = duckdb.connect()
rel = con.read_json(
["a.jsonl", "b.jsonl"],
format="newline_delimited",
)
print(rel.count("*").fetchone())
```

### OS:

macOS arm64

### DuckDB Package Version:

1.5.3

### Python Version:

3.10

### Full Name:

Amir Refaee

### Affiliation:

Railtracks

### What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

### Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

### Did you include all code required to reproduce the issue?

- [x] Yes, I have

### Did you include all relevant configuration to reproduce the issue?

- [x] Yes, I have

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.