gojumprope opened a new issue, #14757: URL: https://github.com/apache/doris/issues/14757
### 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 Variable_name |Value | ---------------------------------+----------------------------------+ partition_prune_algorithm_version|2 | version |5.7.37 | version_comment |Doris version 1.1.3-rc02-b4364b451| ### What's Wrong? BE crash when select external odbc table with long string column, I have a table column that is nvarchar(max) in MS SQL Server which store more than 100000 characters in one row, after I created external table in doris, I am able to select the table without that column. When I select that column with data, BE will instantly crash. ### What You Expected? Able to select the data without BE crash. result of the select query: id|internalnote| --+------------+ 1|<long string with more than 100000 character>| ### How to Reproduce? In MS SQL Server, CREATE TABLE [dbo].[testtable]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [InternalNote] [nvarchar](max) NULL ) INSERT INTO supportportal.[dbo].[testtable] Values() -- please insert 100000 length of string In Doris, CREATE EXTERNAL TABLE IF NOT EXISTS external_testtable ( `id` bigint NOT NULL, `internalnote` varchar ) engine=odbc PROPERTIES ( "odbc_catalog_resource" = "mssql", "database" = "dbo", "table" = "testtable" ); select * from external_testtable; BE crashed, here is the error details SQL Error [1105] [HY000]: RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason be.out log: *** Aborted at 1669964636 (unix time) try "date -d @1669964636" if you are using GNU date *** *** SIGSEGV address not mapped to object (@0x5647c173a000) received by PID 3577208 (TID 0x7fb3d49b2700) from PID 18446744072660164608; stack trace: *** ### Anything Else? I have tried creating the external table column with different data type (string, text) for long characters still didn't work ### 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]
