[X] I had searched in the issues and found no similar issues.
Version
1.2.7
What's Wrong?
Preconditions:
1.Modify the hive field from bigint to string;
Is normal when the hive field type havent chenaged.
When I use Doris' hive catalog to query the hive table, the Doris be process crashes,Simultaneously obtaining the following exceptions:
RpcException, msg: org.apache.doris.rpc.RpcException: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
Using presto to query for errors as follows:
Malformed ORC file. Can not read SQL type varchar from ORC stream .age of type LONG
What You Expected?
Is normal to use doris hive catalog,without exception.
How to Reproduce?
1.Create a hive table with orc type:
CREATE EXTERNAL TABLE IF NOT EXISTS test_qa.testcatalog( idstring, namestring, agebigint ) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';
2.Insert into test_qa.testcatalog values('a','a',1);
3.Query by Doris is ok:
select * from hive.test_qa.testcatalog;
4.Change the table field age type,from bigint to string:
alter table test_qa.testcatalog change column age age string;
5.Query by Doris,I get a exception,bucause be crashes:
RpcException, msg: org.apache.doris.rpc.RpcException: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
vinlee19
commented
1 year ago
Search before asking
Version
1.2.7
What's Wrong?
Preconditions: 1.Modify the hive field from bigint to string; Is normal when the hive field type havent chenaged.
When I use Doris' hive catalog to query the hive table, the Doris be process crashes,Simultaneously obtaining the following exceptions: RpcException, msg: org.apache.doris.rpc.RpcException: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
Using presto to query for errors as follows: Malformed ORC file. Can not read SQL type varchar from ORC stream .age of type LONG
What You Expected?
Is normal to use doris hive catalog,without exception.
How to Reproduce?
1.Create a hive table with orc type:
CREATE EXTERNAL TABLE IF NOT EXISTS test_qa.testcatalog(idstring,namestring,agebigint ) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat';2.Insert into test_qa.testcatalog values('a','a',1); 3.Query by Doris is ok:select * from hive.test_qa.testcatalog;4.Change the table field age type,from bigint to string:alter table test_qa.testcatalog change column age age string;5.Query by Doris,I get a exception,bucause be crashes:RpcException, msg: org.apache.doris.rpc.RpcException: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reasonAnything Else?
No response
Are you willing to submit PR?
Code of Conduct