3 ms·

I'm enjoying experimenting with Duckdb from python, it's a promising product and has a large list of data formats it can read, including pandas dataframes from

I'm enjoying experimenting with Duckdb from python, it's a promising product and has a large list of data formats it can read, including pandas dataframes from in-memory with zero-copy. However its still quite the moving target, with a number of things not at maturity yet. e.g. the TimestampZ column type isn't implemented yet [1], although it is in the documentation. Edit: I came across it via the podcast: https://www.dataengineeringpodcast.com/duckdb-in-process-olap-database-episode-270/ https://www.dataengineeringpodcast.com/duckdb-in-process-ola... Latest release notes: https://github.com/duckdb/duckdb/releases/tag/v0.3.3 https://github.com/duckdb/duckdb/releases/tag/v0.3.3 [1] Error message: Not implemented Error: DataType TIMESTAMPZ not supported yet...

mytherin 4y ago
The correct type is TIMESTAMPTZ. Is the type TimestampZ mentioned anywhere in our documentation? If so, that looks like a typo. I fully agree that error message needs to improve, however. I will have a look at that.
- kristianp 4y ago
  You're right, I was using 'timestampz' when I should have been using 'timestamptz', (or 'timestamp with time zone') thanks for that.
  - mytherin 4y ago
    On the topic of Friendlier SQL, I have extended the similarity search to types in this PR [1], so the system will now offer you this correction as well :) [1] https://github.com/duckdb/duckdb/pull/3633 https://github.com/duckdb/duckdb/pull/3633