Andrew Tindle created HIVE-4043:
-----------------------------------

             Summary: Parallel Hive Queries: Sporadic Errors of form: Error in 
metadata: javax.jdo.JDOFatalDataStoreException: IO Error: Connection reset
                 Key: HIVE-4043
                 URL: https://issues.apache.org/jira/browse/HIVE-4043
             Project: Hive
          Issue Type: Bug
          Components: Metastore
    Affects Versions: 0.9.0
         Environment: O/S: RHEL 6.3
Metastore: Oracle 11gR2
            Reporter: Andrew Tindle


I have a program that spawns Hive queries/processes, up to a maximum of 5, in 
parallel. When the number of queries drops below. ie the process has ended, 
another Hive query/process is initiated.

Sometimes, this program works, i.e. all 34 queries successfully process.

However, on other occasions, I get sporadic instances of the following error 
for some of the queries:

FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: IO Error: 
Connection reset
NestedThrowables:
java.sql.SQLRecoverableException: IO Error: Connection reset
FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.DDLTask

Can anyone help in identifying/resolving why this occurs. It looks to me as if 
there is some kind of race condition/collision with the Hive Metastore, this 
being hosted in an Oracle DB on the same node as the Hadoop infrastructure 
(single node).


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to