[GitHub] [incubator-doris] dataalive opened a new issue, #9351: [Bug] can't load parquet file with column name case sensitive with Doris column

[GitBox <gi...@apache.org>]

dataalive opened a new issue, #9351:
URL: https://github.com/apache/incubator-doris/issues/9351

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   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 
   ```
   
   ### What's Wrong?
   
   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
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [incubator-doris] morningman closed issue #9351: [Bug] can't load parquet file with column name case sensitive with Doris column

[GitBox <gi...@apache.org>]

morningman closed issue #9351: [Bug] can't load parquet file with column name case sensitive with Doris column
URL: https://github.com/apache/incubator-doris/issues/9351


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org