This error message indicates that you are trying to delete data from a table that is not transactional, which is not allowed. In order to perform such operations, you need to set the "transactional" property of the table to "true".

To set the "transactional" property, you can use the following command:

ALTER TABLE table_name SET TBLPROPERTIES ('transactional'='true');

Replace "table_name" with the actual name of the table you want to make transactional.

Once you have set the "transactional" property, you should be able to delete data from the table without encountering this error

FAILED ODPS-013007111 Semantic analysis exception - trying to delete from a non-transactional table is not allowed Set tblproperties transactional = true in order to use this feature

原文地址: http://www.cveoy.top/t/topic/dfCW 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录