[GitHub] [doris] Wujiao233 commented on issue #11465: [Bug] Broker Load cannot correctly import hive data when column name start with number

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

Wujiao233 commented on issue #11465:
URL: https://github.com/apache/doris/issues/11465#issuecomment-1204705819

   after use 'SET' it works fine now 
   ```sql
   LOAD LABEL sync_t_doris_import_test_1
   (
       DATA INFILE("hdfs://path/to/warehouse/tmp.db/t_doris_import_test/*")
       INTO TABLE t_doris_import_test
       FORMAT AS "orc"
       (`id`,`41_col`)
       SET (`_41_col` = `41_col`)
   )
   WITH BROKER "brokers"
       (
       "username" = "xxx",
       "password" = "xxx"
       )
   PROPERTIES
   (
       "timeout"="3600"
   );
   ```
   
   I assume the default column mapping is by it's index.. and thanks for your help 
   


-- 
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