Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

decimal(9,0) types in data unloading not work #55070

Open
titigmr opened this issue Jan 14, 2025 · 1 comment
Open

decimal(9,0) types in data unloading not work #55070

titigmr opened this issue Jan 14, 2025 · 1 comment
Labels
type/bug Something isn't working

Comments

@titigmr
Copy link

titigmr commented Jan 14, 2025

Hi, I'm using data unloading with FILES to write data into S3 in Parquet format. My table has some columns with the DECIMAL(9,0) type, but this command is not working, and I don't know how to work around it. Note that it works fine on columns with DECIMAL(19,0) type...

Steps to reproduce the behavior

INSERT INTO
FILES (
  "path" = "s3://data/table",
  "format" = "parquet",
  "aws.s3.access_key" = "xxx"
  ...
)
SELECT * from db.table;

Real behavior

mysql error: Doesn't support to write DECIMALV2(9,0) type data

StarRocks version

  • 3.3.4-56bcf6f
@titigmr titigmr added the type/bug Something isn't working label Jan 14, 2025
@titigmr
Copy link
Author

titigmr commented Jan 14, 2025

I tried the same query with the same data on allin1 image. It's works fine. But with fe and cn deployment not.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant