Thanks for all who replied.
After several retries in vain, I felt the issue might be because of version
mismatch. So I took Hadoop 2.7.1, Spark 1.3.1 and Hive 1.2.1. Tried with
these combination and I could successfully test the hive transactions
without any issue.
Regards,
Sarath.
On Fri, Aug 7
What version of Hive did you say you were using? In 0.14 we switched to
make sure all jdbc connections are either serializable or
read_committed, yet the error message below seems to indicate you're
seeing a connection request that doesn't match this.
The only other thing I know to try i swit
Sarath,
I assume that the failure you are seeing doesn't happen immediately? The
current timeout on the client is set to 5 minutes. A socket timeout usually
means that the client timed out before it can even get a response from the
server. So the server could either be very busy doing something if
Thanks Eugene, Alan.
@Alan,
As suggested checked the logs, here is what I found -
- On starting metastore server, I'm seeing following messages in the log
file -
*2015-08-07 18:32:56,678 ERROR [Thread-7]: compactor.Initiator
(Initiator.java:run(134)) - Caught an exception in the main loop
Ok, the next step is to look at the logs from your Hive metastore server
and see exactly what's happening. The error you're seeing is from the
client. On your metastore server there should be logs with the same
timestamp giving details on why the transaction operation failed.
Alan.
Sarath
ser@hive.apache.org>"
mailto:user@hive.apache.org>>
Date: Monday, August 3, 2015 at 8:02 PM
To: "user@hive.apache.org<mailto:user@hive.apache.org>"
mailto:user@hive.apache.org>>
Subject: Re: Error communicating with metastore
Thanks Alan.
Yes I've run metastore scripts
Thanks Alan.
Yes I've run metastore scripts for oracle instance. Infact I've removed my
previous metastore and created a fresh one by running the schema creation
script for 1.2.1. I've looked into the new schema and able to see the table
TXNS. I've also removed the hdfs location "/user/hive/wareho
Did you run the hive metastore upgrade scripts for your oracle
instance? This error message usually means the transaction related
tables have not been created in your database. Somewhere in your
distribution there should be a set of upgrade scripts. Look for scripts
of the form:
scripts/me
Thanks Sharath for your reply. I'm specifying these parameters already.
I've followed the documentation at
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions
But it still throws me this error
On Mon, Aug 3, 2015 at 8:45 PM, Sharath Punreddy
wrote:
> Here is another one:
>
> http
Check out:
http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.1/bk_dataintegration/content/ch_using-hive-transactions.html
You need to specify the following properties as well:
-
hive.txn.driver
-
hive.compactor.initiator.on
-
hive.compactor.worker.threads
On Mon, Aug 3,
Hi All,
Earlier I was using hive 0.13.0 and now trying to migrate to latest version
to utilize the transaction support introduced from hive 0.14.0.
I downloaded hive 1.2.1, created a metastore in oracle database and
provided all the required configuration parameters in conf/hive-site.xml to
enabl
11 matches
Mail list logo
