SELECT * FROM read_vortex('lmp.vortex')
WHERE node_id = 'TH_NP15_GEN_ONPEAK-APND'
AND hour_beginning >= '2025-12-01T00:00:00-08:00'
ORDER BY hour_beginning;
Invalid Input Error:
Cannot compare different DTypes ext(vortex.timestamp, i64, ExtMetadata([3, 0, 0]))? and ext(vortex.timestamp, i64, ExtMetadata([1, 3, 0, 85, 84, 67]))?
Backtrace:
disabled backtrace
Using the DuckDB 1.4.3 and latest vortex extension.
This query fails
it works if the
hour_beginningclause is not there.The error I get is:
Using the DuckDB 1.4.3 and latest vortex extension.
Thanks,
Tony