Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIVE - transactions not working - any help is highly appreciable

HIVE - transactions not working - any help is highly appreciable

Explorer

We have the following

 

HiveServer2

HiveMetaStoreServer

We using postgresl Database as metastore (shared )

both for hive / impala .

Hue server  - for data analysts

 

Right know we are using ORC table format.

I understand  all the necessary prequist for hive delete update operations

we are managing the cluster using Clouldera Manager . My only question is where does the below configuration go in Safety valve . When they service and Client side . I am confused any help is highly appreciable man

 

we fire query from Hue web interface .

 

Client Side

    hive.support.concurrency – true
    hive.enforce.bucketing – true (Not required as of Hive 2.0)
    hive.exec.dynamic.partition.mode – nonstrict
    hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
Server Side (Metastore)

    hive.compactor.initiator.on – true (See table below for more details)
    hive.compactor.worker.threads – a positive number on at least one instance of the Thrift metastore service

 

 

1 REPLY 1
Highlighted

Re: HIVE - transactions not working - any help is highly appreciable

Champion

@MattPatt

 

There are two options

 

1. Temporary setup. Go to Hue -> Hive query editor and set up your configuration

Ex: 

set hive.support.concurrency=true;
set hive.enforce.bucketing=true;

 

To get the current value, you can run it before & after setup

set hive.support.concurrency;

set hive.enforce.bucketing;

 

2. Permanent setup: As your admin to Go to Cloudera Manager -> Hive -> Configuration -> search for HiveServer2 Advanced Configuration Snippet (Safety Valve) and update the rqeuired properties as follows

 

Ex:

<property>

<name>hive.support.concurrency</name>

<value>true</value>

</property>

 

Note: The Temporary setup will influence only your scripts but Permanent setup will influence all the script executions. so think twice and take the necessary action

 

 

 

 

Don't have an account?
Coming from Hortonworks? Activate your account here