xujunwei916 opened a new issue, #29712: URL: https://github.com/apache/doris/issues/29712
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.3 ### What's Wrong? When I read the CSV table through hms catalog, the result is only one column, and the other columns are all null values. ### What You Expected? The query columns is likely hive ### How to Reproduce? My hive version is Hive 2.1.1-cdh6.3.2 Steps for bug occurrence **create hms catalog** ```sql CREATE CATALOG hive PROPERTIES ( 'type'='hms', 'hive.metastore.uris' = 'thrift://******:9083', 'hive.metastore.sasl.enabled' = 'true', 'hive.metastore.kerberos.principal' = 'hive/_HOST@******', 'dfs.nameservices'='nameservice1', 'dfs.ha.namenodes.nameservice1'='namenode63,namenode65', 'dfs.namenode.rpc-address.nameservice1.namenode63'='cdh6-leader-01.**:8020', 'dfs.namenode.rpc-address.nameservice1.namenode65'='cdh6-leader-02.**:8020', 'dfs.client.failover.proxy.provider.nameservice1'='org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider', 'hadoop.security.authentication' = 'kerberos', 'hadoop.kerberos.keytab' = '/data/keytab/**.keytab', 'hadoop.kerberos.principal' = '**/**@**', 'yarn.resourcemanager.principal' = 'yarn/_HOST@**' , 'file.meta.cache.ttl-second' = '60', 'hive.version' = '2.1.1' ); ``` **user hive Beeline Cli create a one table and insert two line data:** ```sql create table employee_gz(name string,salary string) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde' with serdeproperties ('quoteChar'='\"' ,'seperatorChar'=','); insert into employee_gz values ('a', '1.1'), ('b', '2.2'); +-------------------+---------------------+ | employee_gz.name | employee_gz.salary | +-------------------+---------------------+ | a | 1.1 | | b | 2.2 | +-------------------+---------------------+ ``` **where I read table by doris,I has a one column result** ```sql SELECT * FROM hive.test.employee_gz +-------------------+---------------------+ | name | salary | +-------------------+---------------------+ | "a","1.1" | null | | "b","2.2" | null | +-------------------+---------------------+ ```  The query results I expect are as follows: ```text +-------------------+---------------------+ | name | salary | +-------------------+---------------------+ | a | 1.1 | | b | 2.2 | +-------------------+---------------------+ ``` ### 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-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
