<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Hive does not run query: error 2 in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Hive-does-not-run-query-error-2/m-p/66047#M48218</link>
    <description>&lt;P&gt;Hi everyone,&lt;/P&gt;
&lt;P&gt;Inside Hue, whe I try to execute a query as select it works well. But when I try to execute a simple query of "insert overwrite" or count (*), that it implies map and reduce, it lasts a lot of time and finally it appears error code 2.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I read the logs but I do not understand them very well. I attached&amp;nbsp; part of it, I am not able the full file,if someone that understands could help me please.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;By the way, when I execute these queris in the quickstart cloudera virtual box, it works perfectly.&lt;/P&gt;
&lt;P&gt;Help me please &lt;span class="lia-unicode-emoji" title=":winking_face:"&gt;😉&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The information of logs are:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1st log&lt;/P&gt;
&lt;P&gt;&amp;nbsp;Log Type: syslog&lt;BR /&gt;&lt;BR /&gt;Log Upload Time: mié abr 04 22:50:02 +0200 2018&lt;BR /&gt;&lt;BR /&gt;Log Length: 86872&lt;BR /&gt;&lt;BR /&gt;0- exited : java.lang.RuntimeException: Error in configuring object&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:75)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:455)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at java.security.AccessController.doPrivileged(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at javax.security.auth.Subject.doAs(Subject.java:415)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1917)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)&lt;BR /&gt;Caused by: java.lang.reflect.InvocationTargetException&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at java.lang.reflect.Method.invoke(Method.java:606)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:106)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 9 more&lt;BR /&gt;Caused by: java.lang.RuntimeException: Error in configuring object&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:75)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.MapRunner.configure(MapRunner.java:38)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 14 more&lt;BR /&gt;Caused by: java.lang.reflect.InvocationTargetException&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at java.lang.reflect.Method.invoke(Method.java:606)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:106)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 17 more&lt;BR /&gt;Caused by: java.lang.RuntimeException: Map operator initialization failed&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:147)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 22 more&lt;BR /&gt;Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassNotFoundException: Class org.apache.hadoop.hive.contrib.serde2.RegexSerDe not found&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.MapOperator.getConvertedOI(MapOperator.java:323)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.MapOperator.setChildren(MapOperator.java:333)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:116)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 22 more&lt;BR /&gt;Caused by: java.lang.ClassNotFoundException: Class org.apache.hadoop.hive.contrib.serde2.RegexSerDe not found&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:2185)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.plan.PartitionDesc.getDeserializer(PartitionDesc.java:137)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.MapOperator.getConvertedOI(MapOperator.java:297)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 24 more&lt;BR /&gt;&lt;BR /&gt;2018-04-04 22:49:19,064 INFO [IPC Server handler 28 on 41836] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Diagnostics report from attempt_1522871964335_0004_m_000000_0: Error: java.lang.RuntimeException: Error in configuring object&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:75)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:455)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at java.security.AccessController.doPrivileged(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at javax.security.auth.Subject.doAs(Subject.java:415)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1917)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)&lt;BR /&gt;Caused by: java.lang.reflect.InvocationTargetException&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at java.lang.reflect.Method.invoke(Method.java:606)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:106)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 9 more&lt;BR /&gt;Caused by: java.lang.RuntimeException: Error in configuring object&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:75)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.mapred.MapRunner.configure(MapRunner.java:38)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 14 more&lt;BR /&gt;Caused by: java.lang.reflect.InvocationTargetException&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at java.lang.reflect.Method.invoke(Method.java:606)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:106)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 17 more&lt;BR /&gt;Caused by: java.lang.RuntimeException: Map operator initialization failed&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:147)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 22 more&lt;BR /&gt;Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassNotFoundException: Class org.apache.hadoop.hive.contrib.serde2.RegexSerDe not found&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.MapOperator.getConvertedOI(MapOperator.java:323)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.MapOperator.setChildren(MapOperator.java:333)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:116)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 22 more&lt;BR /&gt;Caused by: java.lang.ClassNotFoundException: Class org.apache.hadoop.hive.contrib.serde2.RegexSerDe not found&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:2185)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.plan.PartitionDesc.getDeserializer(PartitionDesc.java:137)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;at org.apache.hadoop.hive.ql.exec.MapOperator.getConvertedOI(MapOperator.java:297)&lt;BR /&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;... 24 more&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Fri, 16 Sep 2022 13:04:02 GMT</pubDate>
    <dc:creator>jaimie</dc:creator>
    <dc:date>2022-09-16T13:04:02Z</dc:date>
  </channel>
</rss>

