-
Notifications
You must be signed in to change notification settings - Fork 3.7k
Closed
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
master, lts-1.2
What's Wrong?
Decimal v3 precision loss in the multi catalog module.
What You Expected?
Decimal v3 precision not loss in the multi catalog module.
How to Reproduce?
1. Create hive table and import data.
CREATE TABLE my_table2 (
my_int INT,
my_decimal DECIMAL(38,12)
) STORED AS ORC;
INSERT INTO my_table2 (my_int, my_decimal)
VALUES (123,10.123456789876);
2. Create Doris table and import data:
CREATE TABLE my_table2 (
my_int INT,
my_decimal DECIMALV3(38,12)
)
DISTRIBUTED BY HASH(`my_int`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1");
3. Load hive orc files to Doris table by broker loader.
LOAD LABEL deciamlv3test
(
DATA INFILE("hdfs://172.16.10.13:4007/usr/hive/warehouse/lqftest.db/my_table2/*")
INTO TABLE my_table2
FORMAT AS "orc"
)
WITH BROKER 'broker'
(
"username" = "hadoop",
"password" = ""
)
PROPERTIES
(
"timeout" = "3600"
);
Anything Else?
No response
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct
Metadata
Metadata
Assignees
Labels
No labels

