duckdb / duckdb/duckdb-httpfs

Parser Error while using query_table with https

Open
#208 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
60
Forks
100
Avg merge
1h 50m
Merged PRs (30d)
25

Description

Using `query_table()` in conjunction with an https data source throws a parser error : `Parser Error: Expected catalog.entry, schema.entry or entry: too many entries found (input: https://blobs.duckdb.org/data/Star_Trek-Season_1.csv)`.

I'm not sure if this is an issue with the https extension or with DuckDb itself, sorry.

Repro:

```
from 's3://us-prd-motherduck-open-datasets/netflix/netflix_daily_top_10.parquet'; -- Works
from query_table('s3://us-prd-motherduck-open-datasets/netflix/netflix_daily_top_10.parquet'); -- Works

from 'hf://datasets/datasets-examples/doc-formats-csv-1/data.csv'; -- Works
from query_table('hf://datasets/datasets-examples/doc-formats-csv-1/data.csv'); -- Works

from 'https://blobs.duckdb.org/data/Star_Trek-Season_1.csv'; -- Works
from query_table('https://blobs.duckdb.org/data/Star_Trek-Season_1.csv'); -- Parser Error: Expected catalog.entry, schema.entry or entry: too many entries found (input: https://blobs.duckdb.org/data/Star_Trek-Season_1.csv)

from 'https://www.timestored.com/data/sample/userdata.parquet'; -- Works
from query_table('https://www.timestored.com/data/sample/userdata.parquet'); -- Parser Error: Expected catalog.entry, schema.entry or entry: too many entries found (input: https://www.timestored.com/data/sample/userdata.parquet)
```

Repro'd on: macOS CLI, duckdb.net, WASM, Motherduck v 1.4.2

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the listed query_table() cases in the macOS CLI with the HTTPS extension, comparing the working s3:// and hf:// inputs with the failing https:// URLs. Trace the query_table() parsing entry point and the HTTPS extension boundary; done means both HTTPS examples work like the direct FROM forms without a parser error, with regression coverage.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp
Domain
networking
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
52/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.