Delta table read error

[bali1285]

What happens?

I'm getting the following error:

SQL Error: java.sql.SQLException: IO Error: Hit DeltaKernel FFI error (from: While trying to read from delta table: 'C:***\my_delta_table/'): Hit error: 15 (MissingVersionError) with message (No table version found.)

Code to reproduce is provided.

I can read the delta table if I'm running this code instead

DeltaTable("my_delta_table/").to_pandas()

To Reproduce

import duckdb
from deltalake import DeltaTable, writedeltalake
import sys

print(f'duckdb version: {duckdb._version}')
print(f'Python version: {sys.version}')

con = duckdb.connect("DuckDb3-1-1-1")
con.execute("INSTALL delta;")
con.execute("LOAD  delta;")
df1 = con.query("SELECT i AS id, i % 2 AS part, 'value-'  i AS value FROM range(0, 5) tbl(i)").df()
df2 = con.query("SELECT i AS id, i % 2 AS part, 'value-'  i AS value FROM range(5, 10) tbl(i)").df()
write_deltalake(f"./my_delta_table", df1,  partition_by=["part"])
write_deltalake(f"./my_delta_table", df2,  partition_by=["part"], mode='append')

df = con.query("""
SELECT *
FROM delta_scan('./my_delta_table/')
ORDER BY id;
                  """).df()

OS:

Windows 11 64

DuckDB Version:

1.1.1

DuckDB Client:

Python

Hardware:

No response

Full Name:

Maha Kepakisan

Affiliation:

Personal

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?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have