CHECKPOINT has encountered an error

[Ahidada]

What happens?

duckdb error: Binder Error: Failed to perform CHECKPOINT; in DuckLake: Failed to get files scheduled for deletion from DuckLake: Cannot compare values of type VARCHAR and type TIMESTAMP WITH TIME ZONE - an explicit cast is required

LINE 4: WHERE schedule_start < NOW() - INTERVAL '2 days'

To Reproduce

SET memory_limit='8GB';
ATTACH 'ducklake:sqlite:/share/ducklake/le_hdfs/le_fsspec_hdfs.sqlite' AS le_fsspec_hdfs (DATA_PATH 'hdfs:///tmp/ducklake/le_pa_hdfs/files', METADATA_PARAMETERS MAP {'journal_mode': 'WAL'});use le_fsspec_hdfs;


CHECKPOINT;

OS:

linux

DuckDB Version:

1.4.3

DuckLake Version:

0.3

DuckDB Client:

python(the 'sql lab' in superset)

Hardware:

No response

Full Name:

Ahikaka

Affiliation:

MJ

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

I have not tested with any build

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

No - Other reason (please specify in the issue body)

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

[Alex-Monahan]

Hello!
Could you check the data type of the schedule_start column? If it is a varchar, then you need to cast to a varchar to compare against it.
https://duckdb.org/docs/stable/sql/functions/dateformat#strftime-examples

WHERE schedule_start < strftime(  NOW() - INTERVAL '2 days', 'your varchar date format')

[pdet]

Hi @Ahidada, this should be fixed in the later versions!

See #654