为什么删除功能在蜂巢壳中不起作用? [英] why is delete function not working in hive shell?
本文介绍了为什么删除功能在蜂巢壳中不起作用?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
hive> delete from daily_case where num_casedaily=0;
FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
先谢谢您
推荐答案
@Chema解释了HIVE的ACID交易.您可以更改表属性以允许事务.
As @Chema explained ACID Transactions of HIVE. You can change the table property to allow transaction.
OR
您可以执行以下操作.这样，您不必更改表属性.
You can do the following. With this you don't have to change table properties.
INSERT OVERWRITE INTO daily_case
SELECT * FROM daily_case WHERE num_casedaily <> 0;
这篇关于为什么删除功能在蜂巢壳中不起作用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
