Repository navigation
'Not supported error' on TIMESTAMP_NTZ #32
Description
For tables defined with timestamp_ntz data types, the current version of uc_catalog fails with the below on 'show all tables':
Not implemented Error:
Tried to fallback to unknown type for 'timestamp_ntz'
You can select data from tables without that data type.
The fix I used that works is in uc_utils.cpp and adding timestamp_ntz to the timestamp check:
else if (type_text == "timestamp" || type_text == "timestamp_ntz") {
return LogicalType::TIMESTAMP_TZ;
This is unlikely to be the best solution, obviously, but wasn't sure if that needed to reach further back into duckdb itself.
A data set to use when reproducing or checking is the NYC taxi data as it has this data type in its schema.
Activity
ravindra1985 commentedon May 13, 2026
Hi, this issue still exists, whats the recommended solution please/
rramillien commentedon Aug 27, 2026
Hello all,
First, thank you for your good work on duckDB and unity catalog connector.
We are facing the same issue.
Do you know when the PR will be merged please ?
Can we help on something to accelerate ?
Fix: unknown type timestamp_ntz (#82)
AbdealiLoKo commentedon Sep 14, 2026
Hi, @rramillien were you able to find any alternatives while we wait for a release ?
I'm stuck due to the same issue
benfleis commentedon Sep 14, 2026
I'm working on both the backport to v1.5, and getting the nightly distribution fixed, please hang in there :)
AbdealiLoKo commentedon Sep 14, 2026
Ah, thanks a lot @benfleis ! Eagerly awaiting it :)
benfleis commentedon Sep 18, 2026
@AbdealiLoKo @rramillien
The fix landed, and has been backported, and will ship with the upcoming v1.5.6 release. If you need immediate relief you can try the nightlies. You'll need the nightly duckdb core, which will download the most recent nightly extensions. If you're on python, there are similar instruction higher up in that page.
rramillien commentedon Oct 2, 2026
Great ! Thank you @benfleis ! We will test it !