Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.
Debu77
New Contributor

Can we integrate an external Kafka cluster with At...

by New Contributor in Support Questions
‎06-28-2019 12:08 PM
‎06-28-2019 12:08 PM
Hi Everyone, Greetings ! I want to integrate Atlas to a Kafka Cluster , which is outside the Hortonworks Data Platform. Would you please be able to help let me know whether it's possible or is it mandatory that the Kafka cluster needs to exist within the HDP itself Thanks, Debu ... View more
Labels:

Hortonworks 2.5 - Hive ACID Insert is getting hung

by New Contributor in Support Questions
‎04-08-2017 06:27 PM
‎04-08-2017 06:27 PM
Hi, I am using HDP 2.5. I want to perform a delete operation from a Hive table. I have created a table with the following command: hive> create table test (x int, y string) clustered by (x) into 2 buckets stored as ORC tblproperties ("transactional" = "true"); OK Time taken: 0.148 seconds Further, I have set the following Hive properties: 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; set hive.optimize.sort.dynamic.partition=false; Then on, I am doing a test insert into the hive table leveraging the following command: INSERT INTO TEST VALUES (1,a); Unfortunately my Hive CLI shell is getting hung and I have to issue Ctrl + C command to get out of the shell. May I know why is this happening please? Is it due to the fact that my Hive schema / database contains a mixture of ACID and non-ACID tables ? Any suggestion to resolve this problem will be very helpful. Thanks in advance ! ... View more
Labels:

Re: How to activate ACID transactions in Hive with...

by New Contributor in Support Questions
‎04-08-2017 06:17 PM
‎04-08-2017 06:17 PM
Hi, I am using HDP 2.5. I want to perform a delete operation from a Hive table. I have created a table with the following command: hive> create table test (x int, y string) clustered by (x) into 2 buckets stored as ORC tblproperties ("transactional" = "true"); OK Time taken: 0.148 seconds Further, I have set the following Hive properties: 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; set hive.optimize.sort.dynamic.partition=false; Then on, I am doing a test insert into the hive table leveraging the following command: INSERT INTO TEST VALUES (1,a); Unfortunately my Hive CLI shell is getting hung and I have to issue Ctrl + C command to get out of the shell. May I know why is this happening please? Is it due to the fact that my Hive schema / database contains a mixture of ACID and non-ACID tables ? Any suggestion to resolve this problem will be very helpful. Thanks in advance ! ... View more
Contact Me
Online
Offline
Last Visited
‎09-27-2019 06:50 AM
Public Statistics
Date Registered ‎06-02-2019 02:20 AM
Last Visited ‎09-27-2019 06:50 AM
Total Messages Posted 4