duckdb / duckdb/unity_catalog

'Not supported error' on TIMESTAMP_NTZ

Open
#32 5 comments 3 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
110
Forks
44
Avg merge
2d 13h
Merged PRs (30d)
4

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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.