Repository navigation
[Bug] can't load parquet file with column name case sensitive with Doris column #9351
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
1.0.0-rc03
What's Wrong?
doris table
CREATE TABLE `record` (
`id` varchar(50) NOT NULL ,
`energySerial` varchar(3) NULL
) ENGINE=OLAP
UNIQUE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 10;
LOAD LABEL test.record_20220502
(
DATA INFILE ("hdfs://172.0.0.9/tmp/part0.parq")
INTO TABLE record format as parquet ( id,energyserial)
SET
(
id = id,
energySerial = energyserial
)
) WITH BROKER 'Broker_Doris' ( "username" = "hadoop" );
to show the key difference more clearly in sample above,
energySerial.toLowerCase() = energyserial
we get an load error msg like
unknown reference column, column=energySerial, reference=energyserial
we can't load that parquet column to doris
What You Expected?
it could works
How to Reproduce?
No response
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
Activity
fix apache#9351 can't load parquet file with column name case sensiti…
apache#9351 add some comments
apache#9351 add some comments
apache#9351 fix reviewed