JasonGofen opened a new issue, #14987: URL: https://github.com/apache/doris/issues/14987
### 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 1.2.0-rc04 ### What's Wrong? After establishing an external table with SAP HANA using "Doris on JDBC", data can be queried and inserted normally, but data cannot be updated or deleted. 使用“Doris on JDBC”与SAP HANA建立外部表后，可以正常查询和插入数据，但不能更新或删除数据。 ### What You Expected? Use 'Doris on JDBC' to update and delete SAP HANA table data normally. 使用“Doris on JDBC”正常更新和删除SAP HANA表数据。 ### How to Reproduce? Environment information: SAP HANA version:2.00.030.00 Doris version:1.2.0-rc04, 1FE+3BE SAP HANA JDBC driver version:[ngdbc-2.4.51.jar.zip](https://github.com/apache/doris/files/10199576/ngdbc-2.4.51.jar.zip) Server information: [CPU 16C 64GB, Memory 64GB, Disk HHD 1TB,Physical machine] * 4 ----------------------- SQL script: CREATE EXTERNAL RESOURCE prd_bwhana_zhivetohana_jdbc properties ( "type"="jdbc", "user"="ZBI_MODEL", "password"="*****", "jdbc_url"="jdbc:sap://192.168.50.100:30015?reconnect=true¤tschema=ZHIVETOHANA&locale=en_US", "driver_url"="file:///home/doris/jdbc_driver/ngdbc-2.4.51.jar", "driver_class"="com.sap.db.jdbc.Driver" ); CREATE EXTERNAL TABLE `test_for_doris` ( `column_1` varchar(100) NULL ) ENGINE=JDBC COMMENT 'JDBC' PROPERTIES ( "resource" = "prd_bwhana_zhivetohana_jdbc", "table" = "TEST_FOR_DORIS", "table_type"="clickhouse" ); mysql> set enable_vectorized_engine = true; Query OK, 0 rows affected (0.00 sec) mysql> select * from ods_xmcx.test_for_doris; +----------+ | column_1 | +----------+ | I am in | +----------+ 1 row in set (0.12 sec) mysql> insert into ods_xmcx.test_for_doris values('I am in too.'); Query OK, 0 rows affected (0.51 sec) mysql> select * from ods_xmcx.test_for_doris; +--------------+ | column_1 | +--------------+ | I am in | | I am in too. | +--------------+ 2 rows in set (0.48 sec) mysql> delete from ods_xmcx.test_for_doris where column_1 = 'I am in'; ERROR 1105 (HY000): errCode = 2, detailMessage = Table 'test_for_doris' is not a OLAP table mysql> update ods_xmcx.test_for_doris set column_1 = 'I am out.' where column_1 = 'I am in'; ERROR 1105 (HY000): errCode = 2, detailMessage = Only unique olap table could be updated. ### Anything Else? "table_type"="clickhouse" Whether "sap hana" type can be added？(^_^) 是否可以给”table_type“属性增加“sap hana”类型？(^_^) ### 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]
