分享

hive0.14-insert、update、delete操作测试

howtodown 2015-3-24 14:47:11 发表于 实操演练 [显示全部楼层] 回帖奖励 阅读模式 关闭右栏 10 290169
georgehym 发表于 2016-6-29 15:48:31
楼主,我刚刚也遇到了这个问题:DELETE 出现Attempt to do update or delete using transaction manager that does not support these operations.错误
配置文件以后还是报一样的错呢,重启过hive了。
hive-site.xml中新增了:
<property>
    <name>hive.support.concurrency</name>
    <value>true</value>
  </property>
<property>
    <name>hive.enforce.bucketing</name>
    <value>true</value>
  </property>
<property>
    <name>hive.exec.dynamic.partition.mode</name>
    <value>nonstrict</value>
  </property>
<property>
    <name>hive.txn.manager</name>
    <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
  </property>
<property>
    <name>hive.compactor.initiator.on</name>
    <value>true</value>
  </property>
<property>
    <name>hive.compactor.worker.threads</name>
    <value>1</value>
  </property>
同样错误依然存在,重启过hive了:
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
        at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231)
        at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217)
        at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:244)
回复

使用道具 举报

12
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条