Skip to content

Issue with read_parquet: Unknown column type for prepare: TIME WITH TIME ZONE #1807

@mesner

Description

@mesner

Reading the following parquet file (saved with a jpg suffix to allow for upload) fails in the R duckdb package v1.4.2.

time_test.parquet.jpg

> duckdb::sql_query('select * from read_parquet("time_test.parquet.jpg")')
Error in `dbSendQuery()`:
! Unknown column type for prepare: TIME WITH TIME ZONE
ℹ Context: rapi_prepare
Run `rlang::last_trace()` to see where the error occurred.
> rlang::last_trace()
<error/rlang_error>
Error in `dbSendQuery()`:
! Unknown column type for prepare: TIME WITH TIME ZONE
ℹ Context: rapi_prepare
---
Backtrace:
    ▆
 1. └─duckdb::sql_query("select * from \"time_test.parquet\"")
 2.   ├─DBI::dbGetQuery(conn, sql)
 3.   └─DBI::dbGetQuery(conn, sql)
 4.     └─DBI (local) .local(conn, statement, ...)
 5.       ├─DBI::dbSendQuery(conn, statement, ...)
 6.       └─duckdb::dbSendQuery(conn, statement, ...)
Run rlang::last_trace(drop = FALSE) to see 17 hidden frames.

Reading the file in python works:

import duckdb
duckdb.sql("select * from read_parquet('time_test.parquet.jpg')")
┌─────────────────────┐
│          t          │
│ time with time zone │
├─────────────────────┤
│ 00:00:00+00         │
└─────────────────────┘

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions