Hive supports transactions by setting the correct parameters. To enable transactions, the following configurations need to be set. These configuration parameters must be set appropriately to turn on transaction support in Hive:
hive.support.concurrency - true
hive.enforce.bucketing - true
hive.exec.dynamic.partition.mode - nonstrict
hive.txn.manager - org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
hive.compactor.initiator.on - true on one instance of the Thrift metastore service
hive.compactor.worker.threads - 10 for an instance of the Thrift metastore service
Use this specific table format:
CREATE TABLE mytable (
c1 int,
c2 string,
c3 string
)
CLUSTERED BY (c1) INTO x BUCKETS
STORED AS orc
TBLPROPERTIES('transactional' = 'true');
hive.support.concurrency - true
hive.enforce.bucketing - true
hive.exec.dynamic.partition.mode - nonstrict
hive.txn.manager - org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
hive.compactor.initiator.on - true on one instance of the Thrift metastore service
hive.compactor.worker.threads - 10 for an instance of the Thrift metastore service
Use this specific table format:
CREATE TABLE mytable (
c1 int,
c2 string,
c3 string
)
CLUSTERED BY (c1) INTO x BUCKETS
STORED AS orc
TBLPROPERTIES('transactional' = 'true');
Share this article with your friends.
I am happy for sharing on this blog its awesome blog I really impressed. thanks for sharing. Great efforts.
ReplyDeleteLooking for Big Data Hadoop Training Institute in Bangalore, India. Prwatech is the best one to offers computer training courses including IT software course in Bangalore, India.
Also it provides placement assistance service in Bangalore for IT. Best Data Science Certification Course in Bangalore.
Some training courses we offered are:Big Data Training In Bangalore
big data training institute in btm
hadoop training in btm layout
Best Python Training in BTM Layout
Data science training in btm
R Programming Training Institute in Bangalore
apache spark training in bangalore
Best tableau training institutes in Bangalore
data science training institutes in bangalore