You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 :
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;
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 :
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
The text was updated successfully, but these errors were encountered: