duckdb / duckdb/unity_catalog

decimal type not handled

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

Description

Hey folks,

I'm currently running duckdb 1.1.1 and tried to use a table which contains decimal columns.
Creating it on UC generate following type_text "decimal" not "decimal(" because scale and precision are handled separatly with the type_precision and type_scale.

**How to reproduce:**
Create a table with following schema parameters :
bin/uc table create --full_name unity.default.local_sales --column 'gmv_recorded_at date, item_code string, country_code string, gmv_item_quantity long, gmv_amount decimal(32,6), gmv_amount_euros decimal(32,6)' --format PARQUET --storage_location 's3://whateverBucket/myDataset'

result should be something like this for the decimal columns :
image

on duckdb perform the following :
install uc_catalog from core_nightly;
load uc_catalog;
CREATE SECRET (
TYPE UC,
TOKEN 'not-used',
ENDPOINT 'http://127.0.0.1:8080',
AWS_REGION 'us-east-2'
);
ATTACH 'unity' AS unity (TYPE UC_CATALOG);
show all tables;

**Where issue could be :**
https://github.com/duckdb/uc_catalog/blob/e416fd95465b6d6137492b18db4421bf232fb1fe/src/uc_utils.cpp#L58C13-L58C22

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.