Comments on: Transactions in Hive https://acadgild.com/blog/transactions-in-hive/ Learn. Do. Earn. Thu, 25 Aug 2016 12:12:23 +0000 hourly 1 https://wordpress.org/?v=4.5.3 By: Amol Vishwarupe https://acadgild.com/blog/transactions-in-hive/#comment-2947 Thu, 30 Jun 2016 07:18:05 +0000 https://acadgild.com/blog/?p=1099#comment-2947 Hello Satyam ,
Thanks for quick help , setting properties from command prompt didn’t worked for me ,
as i mentioned its just hanging for ever .

I tried another way and it is working for me

I have update above all properties in hive-site.xml + one extra property i added

then restarted the service …( just shut down VM and restarted ….) and its working now.

—————————————————————————————————————————————————–my hive-site.xml looks like below
( may be useful for others who may stuck with same error i got)

javax.jdo.option.ConnectionURL
jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true
metadata is stored in a MySQL server

javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
MySQL JDBC driver class

javax.jdo.option.ConnectionUserName
hiveuser
user name for connecting to mysql server

javax.jdo.option.ConnectionPassword
password
password for connecting to mysql server

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

hive.compactor.worker.threads
2

hive.in.test
true

]]> By: Amol Vishwarupe https://acadgild.com/blog/transactions-in-hive/#comment-2946 Thu, 30 Jun 2016 06:54:57 +0000 https://acadgild.com/blog/?p=1099#comment-2946 some test

]]> By: Amol Vishwarupe https://acadgild.com/blog/transactions-in-hive/#comment-2945 Thu, 30 Jun 2016 06:54:00 +0000 https://acadgild.com/blog/?p=1099#comment-2945 I did that i have given 2

after setting all those properties whatever next hive statement i give it hangs for ever.

i am trying win hive-site.xml now , mean time if you have any inputs please let me know.

]]> By: Satyam https://acadgild.com/blog/transactions-in-hive/#comment-2944 Thu, 30 Jun 2016 06:25:23 +0000 https://acadgild.com/blog/?p=1099#comment-2944 Hi Amol,
set hive.compactor.worker.threads = a positive number on at least one instance of the Thrift metastore service;
For this you need to give any positive value for example
set hive.compactor.worker.threads = 5;

]]> By: Amol Vishwarupe https://acadgild.com/blog/transactions-in-hive/#comment-2943 Thu, 30 Jun 2016 05:56:45 +0000 https://acadgild.com/blog/?p=1099#comment-2943 HEllo Kiran

after setting the below properties
hive>set hive.support.concurrency = true;

hive>set hive.enforce.bucketing = true;

hive>set hive.exec.dynamic.partition.mode = nonstrict;

hive>set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

hive>set hive.compactor.initiator.on = true;

hive>set hive.compactor.worker.threads = a positive number on at least one instance of the Thrift metastore service;

Its getting hanged and no operation can be done after that ……can you please help on it
I am using acadgild VM on 64 bit

]]> By: Guarav https://acadgild.com/blog/transactions-in-hive/#comment-823 Wed, 03 Feb 2016 05:45:17 +0000 https://acadgild.com/blog/?p=1099#comment-823 When I am inserting a row into my table my API hangs at kill command, can you please help me out with this ?

]]> By: pratheep https://acadgild.com/blog/transactions-in-hive/#comment-580 Sun, 10 Jan 2016 18:13:37 +0000 https://acadgild.com/blog/?p=1099#comment-580 Tanks a lot for your information its very useful and can you provide any information regarding for apache oozie with real time scenario?

]]>