apache / apache/arrow-adbc

Clarification on Timestamp Precision in ADBC GetObjects Metadata

Open
#2,496 1 comment 0 reactions 0 assignees View on GitHub
Type: question
Dominant language
C#
Stars
627
Forks
217
Avg merge
17h
Merged PRs (30d)
57

Description

I have been looking at how parameterized types are represented in the schema returned by `AdbcConnectionGetObjects`. I found that for `DECIMAL(precision, scale)`, the precision and scale map to `xdbc_column_size` and `xdbc_decimal_digits` respectively. However, I wasn't able to determine where the time unit (`s`/`ms`/`us`/`ns`) of a `TIMESTAMP` type should be specified.

From my understanding, the column properties in `COLUMN_SCHEMA` are designed to mirror JDBC/ODBC metadata. However, I haven't found any standardized documentation that explicitly states how timestamp precision should be represented in this context.

My questions:

- Is there a standard way to represent timestamp precision in the ADBC metadata schema?
- If so, which field should hold this information?
- Does this align with JDBC/ODBC metadata standards, and if so, where is it documented?

Any clarification on this would be greatly appreciated! Thanks in advance.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.