Member since
06-02-2019
4
Posts
0
Kudos Received
0
Solutions
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:
- Labels:
-
Apache Atlas
-
Apache Kafka
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
- Tags:
- Data Processing
- Hive
Labels:
- Labels:
-
Apache Hive
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