Mailing-List: contact yarn-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: yarn-dev@hadoop.apache.org
Received-SPF: unknown (nike.apache.org: error in processing during lookup of
 vikas.parashar@fosteringlinux.com)
MIME-Version: 1.0
From: Vikas Parashar <vikas.parashar@fosteringlinux.com>
Date: Thu, 26 Dec 2013 17:35:40 +0530
Message-ID: 
 <CAMZjM-on_+ihWtgc=rJAviN=VgkNjUJyE5zEdjpOO5fPeHRBOA@mail.gmail.com>
Subject: hbase hive integration
To: yarn-dev@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001a11c253800d71f904ee6ecd9f

--001a11c253800d71f904ee6ecd9f
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I am integrating hive(0.12) with hbase(0.96). Everything is working fine
there but get stuck between two quires.

When i create table or select * from table then it's working fine .
but in case of select count(*) from table it give me below error.


2013-12-26 13:25:01,864 ERROR ql.Driver (SessionState.java:printError(419))
- FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.mr.MapRedTask
2013-12-26 13:25:01,869 WARN  mapreduce.Counters
(AbstractCounters.java:getGroup(234)) - Group FileSystemCounters is
deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
2013-12-26 14:25:44,119 WARN  mapreduce.JobSubmitter
(JobSubmitter.java:copyAndConfigureFiles(149)) - Hadoop command-line option
parsing not performed. Implement the Tool interface and execute your
application with ToolRunner to remedy this.
2013-12-26 14:26:14,677 WARN  mapreduce.Counters
(AbstractCounters.java:getGroup(234)) - Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
2013-12-26 14:26:33,613 WARN  mapreduce.Counters
(AbstractCounters.java:getGroup(234)) - Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
2013-12-26 14:27:30,355 WARN  mapreduce.Counters
(AbstractCounters.java:getGroup(234)) - Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
2013-12-26 14:27:32,479 WARN  mapreduce.Counters
(AbstractCounters.java:getGroup(234)) - Group
org.apache.hadoop.mapred.Task$Counter is deprecated. Use
org.apache.hadoop.mapreduce.TaskCounter instead
2013-12-26 14:27:32,528 ERROR exec.Task (SessionState.java:printError(419))
- Ended Job = job_1388037394132_0013 with errors
2013-12-26 14:27:32,530 ERROR exec.Task (SessionState.java:printError(419))
- Error during job, obtaining debugging information...
2013-12-26 14:27:32,538 ERROR exec.Task (SessionState.java:printError(419))
- Examining task ID: task_1388037394132_0013_m_000000 (and more) from job
job_1388037394132_0013
2013-12-26 14:27:32,539 WARN  shims.HadoopShimsSecure
(Hadoop23Shims.java:getTaskAttemptLogUrl(72)) - Can't fetch tasklog:
TaskLogServlet is not supported in MR2 mode.
2013-12-26 14:27:32,593 WARN  shims.HadoopShimsSecure
(Hadoop23Shims.java:getTaskAttemptLogUrl(72)) - Can't fetch tasklog:
TaskLogServlet is not supported in MR2 mode.
2013-12-26 14:27:32,596 WARN  shims.HadoopShimsSecure
(Hadoop23Shims.java:getTaskAttemptLogUrl(72)) - Can't fetch tasklog:
TaskLogServlet is not supported in MR2 mode.
2013-12-26 14:27:32,599 WARN  shims.HadoopShimsSecure
(Hadoop23Shims.java:getTaskAttemptLogUrl(72)) - Can't fetch tasklog:
TaskLogServlet is not supported in MR2 mode.
2013-12-26 14:27:32,615 ERROR exec.Task (SessionState.java:printError(419))
-
Task with the most failures(4):
-----
Task ID:
  task_1388037394132_0013_m_000000

URL:

http://ambari1.hadoop.com:8088/taskdetails.jsp?jobid=job_1388037394132_0013&tipid=task_1388037394132_0013_m_000000
-----
Diagnostic Messages for this Task:
Error: java.io.IOException: java.io.IOException:
java.lang.reflect.InvocationTargetException
at
org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderCreationException(HiveIOExceptionHandlerChain.java:97)
 at
org.apache.hadoop.hive.io.HiveIOExceptionHandlerUtil.handleRecordReaderCreationException(HiveIOExceptionHandlerUtil.java:57)
 at
org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:244)
 at
org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getRecordReader(CombineHiveInputFormat.java:538)
 at
org.apache.hadoop.mapred.MapTask$TrackedRecordReader.<init>(MapTask.java:167)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:408)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
 at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:162)
at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAs(Subject.java:396)
 at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1491)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:157)
Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException
 at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:383)
at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:360)
 at
org.apache.hadoop.hbase.client.HConnectionManager.getConnection(HConnectionManager.java:244)
 at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:187)
at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:164)
 at
org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getRecordReader(HiveHBaseTableInputFormat.java:91)
 at
org.apache.hadoop.hive.ql.io.HiveInputFormat.getRecordReader(HiveInputFormat.java:241)
 ... 9 more
Caused by: java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:381)
... 15 more
Caused by: java.lang.NoClassDefFoundError: org/cloudera/htrace/Trace
at
org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.exists(RecoverableZooKeeper.java:196)
 at org.apache.hadoop.hbase.zookeeper.ZKUtil.checkExists(ZKUtil.java:479)
 at
org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:65)
at
org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:83)
 at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.retrieveClusterId(HConnectionManager.java:794)
 at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.<init>(HConnectionManager.java:627)
 ... 20 more
Caused by: java.lang.ClassNotFoundException: org.cloudera.htrace.Trace
 at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
 at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
 at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
 at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
 ... 26 more


2013-12-26 14:27:32,870 ERROR ql.Driver (SessionState.java:printError(419))
- FAILED: Execution Error, return code 2 from org.apache.

I think this error is related with mapred job. Whenever my query use the
map-R then i get error.

Any idea!!

-- 
Thanks & Regards:-
Vikas Parashar
Sr. Linux administrator Cum Developer
Mobile: +91 958 208 8852
Email: vikas.parashar@fosteringlinglinux.com

--001a11c253800d71f904ee6ecd9f--