# Finding errors while inserting data into hbase through hive
**URL:** https://discuss.elastic.co/t/finding-errors-while-inserting-data-into-hbase-through-hive/25006
**Category:** Elasticsearch
**Tags:** es-hadoop
**Created:** [July 7, 2015, 5:06am UTC](https://discuss.elastic.co/t/finding-errors-while-inserting-data-into-hbase-through-hive/25006 "2015-07-07T05:06:07Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Balu\_Dhanu](https://discuss.elastic.co/u/Balu_Dhanu)
#### Post date: [July 7, 2015, 5:06am UTC](https://discuss.elastic.co/t/finding-errors-while-inserting-data-into-hbase-through-hive/25006/1 "2015-07-07T05:06:07Z")
insert overwrite table 2014data select Symbol,Series,Day\_Mon\_Year,Prev\_Close,Open\_Price,High\_Price,Low\_Price,Last\_Price,Close\_Price,Average\_Price,Total\_Traded\_Quantity,Turnover\_in\_Lacs,No\_of\_Trades,Deliverable\_Qty,Percentage\_Dly\_Qt\_to\_Traded\_Qty from 2014\_data;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job\_201507061033\_0004, Tracking URL = [http://localhost:50030/jobdetails.jsp?jobid=job\_201507061033\_0004](http://localhost:50030/jobdetails.jsp?jobid=job_201507061033_0004)
Kill Command = /home/balu/work/hadoop-1.1.2/libexec/../bin/hadoop job -kill job\_201507061033\_0004
Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 0
2015-07-06 12:30:03,448 Stage-0 map = 0%, reduce = 0%
2015-07-06 12:30:27,528 Stage-0 map = 100%, reduce = 100%
Ended Job = job\_201507061033\_0004 with errors
Error during job, obtaining debugging information...
Job Tracking URL: [http://localhost:50030/jobdetails.jsp?jobid=job\_201507061033\_0004](http://localhost:50030/jobdetails.jsp?jobid=job_201507061033_0004)
Examining task ID: task\_201507061033\_0004\_m\_000002 (and more) from job job\_201507061033\_0004
Task with the most failures(4):
Task ID:
task\_201507061033\_0004\_m\_000000
URL:
[http://localhost:50030/taskdetails.jsp?jobid=job\_201507061033\_0004&tipid=task\_201507061033\_0004\_m\_000000](http://localhost:50030/taskdetails.jsp?jobid=job_201507061033_0004&tipid=task_201507061033_0004_m_000000)
Diagnostic Messages for this Task:
java.lang.RuntimeException: Error in configuring object
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:432)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:372)
at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1149)
at org.apache.hadoop.mapred.Child.main(Child.java:249)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:88)
... 9 more
Caused by: java.lang.RuntimeException: Error in configuring object
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64)
at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
at org.apache.hadoop.mapred.MapRunner.configure(MapRunner.java:34)
... 14 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:88)
... 17 more
Caused by: java.lang.RuntimeException: Map operator initialization failed
at org.apache.hadoop.hive.ql.exec.ExecMapper.configure(ExecMapper.java:121)
... 22 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.NullPointerException
at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:373)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:360)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:436)
at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:392)
at org.apache.hadoop.hive.ql.exec.SelectOperator.initializeOp(SelectOperator.java:62)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:360)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:436)
at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:392)
at org.apache.hadoop.hive.ql.exec.TableScanOperator.initializeOp(TableScanOperator.java:166)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:360)
at org.apache.hadoop.hive.ql.exec.MapOperator.initializeOp(MapOperator.java:441)
at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:360)
at org.apache.hadoop.hive.ql.exec.ExecMapper.configure(ExecMapper.java:98)
... 22 more
Caused by: java.lang.NullPointerException
at org.apache.hadoop.hive.ql.exec.FileSinkOperator.initializeOp(FileSinkOperator.java:315)
... 34 more
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec
---
### Author:  [@costin](https://discuss.elastic.co/u/costin)
#### Post date: [July 14, 2015, 7:49am UTC](https://discuss.elastic.co/t/finding-errors-while-inserting-data-into-hbase-through-hive/25006/2 "2015-07-14T07:49:41Z")
Hi,
Some formatting would help to increase the readability of your post. I've seen this error before but the root cause differs every time. The stacktrace doesn't contain any relevant information - basically there are tons of wrapper exceptions without any mention on what causes the NPE on Hive side.
Try to take a look at the Hive logs directly and see whether something pops up.
Also providing information about the environment, classpath and your actual script is essential for a fast and correct diagnosis.
---
### Author:  [@ebuildy](https://discuss.elastic.co/u/ebuildy)
#### Post date: [November 21, 2015, 10:24am UTC](https://discuss.elastic.co/t/finding-errors-while-inserting-data-into-hbase-through-hive/25006/3 "2015-11-21T10:24:18Z")
Look like a job configuration issue, did you install the latest elasticsearch Hadoop JAR in the right place?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:27pm UTC](https://discuss.elastic.co/t/finding-errors-while-inserting-data-into-hbase-through-hive/25006/4 "2017-07-06T13:27:09Z")