Wujiao233 opened a new issue, #11465: URL: https://github.com/apache/doris/issues/11465
### 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 1.1.0-rc05 ### What's Wrong? hive table is like ```sql create table tmp.t_doris_import_test as select 'a' as id, 1 as `41_col` union all select 'b' as id, 2 as `41_col` union all select 'c' as id, 3 as `41_col` ``` which has a column name start with number and doris table is ```sql CREATE TABLE tmp.t_doris_import_test ( `id` varchar(20) ,`_41_col` bigint ) DUPLICATE KEY(`id`) DISTRIBUTED BY RANDOM ``` because doris cannot use column name start with number so I add a underline before number then use broker load to load data from hive to doris ```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`) ) WITH BROKER "brokers" ( "username" = "xxx", "password" = "xxx" ) PROPERTIES ( "timeout"="3600" ); ``` which finish successfully.. However when I query this table on doris ```sql select * from tmp.t_doris_import_test ``` it return | id | _41_col | | --- | --- | | a | NULL | | b | NULL | | c | NULL | ### What You Expected? the result should be like | id | _41_col | | --- | --- | | a | 1 | | b | 2 | | c | 3 | or maybe I use the wrong load configuration... ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
