首页 > 解决方案 > Hive ACID 表抛出错误 FAILED: UnsupportedOperationException openTxn is not supported in aws EMR

问题描述

我尝试在AWS EMR 6.3.0中创建 Hive ACID 表。我已设置必要的参数以在配置单元托管表上启用 ACID 属性。设置属性后和创建表时遇到以下错误 FAILED: UnsupportedOperationException openTxn is not supported

请找到我遵循的步骤

步骤1:

set hive.support.concurrency = true;
set hive.enforce.bucketing = true;
set hive.exec.dynamic.partition.mode = nonstrict;
set hive.txn.manager =org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.compactor.initiator.on = true;
set hive.compactor.worker.threads = 1;

第2步:

hive>
    >
    > create table Sample_Table2(
    > col1 Int,
    > col2 String,
    > col3 String)
    > clustered by (col3) into 3 buckets
    > stored as orc
    > TBLPROPERTIES ('transactional'='true');
FAILED: UnsupportedOperationException openTxn is not supported

标签: hiveamazon-emr

解决方案


推荐阅读