[jira] [Updated] (HIVE-15097) Error: java.lang.RuntimeException: Error in configuring object Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
[ https://issues.apache.org/jira/browse/HIVE-15097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chen cong updated HIVE-15097: - Description: hive> CREATE TABLE user_tag_pre AS > SELECT A.userid , A.tag , A.single_tag_sumcount/B.sum_tag_sumcount_avg as pre > FROM user_tag_sumcount A , user_tag_avg B > WHERE A.userid = B.userid; Query ID = ubuntu_20161101091124_753d511e-c7b8-4d31-bf97-cf0c04203ddc Total jobs = 1 Execution log at: /tmp/ubuntu/ubuntu_20161101091124_753d511e-c7b8-4d31-bf97-cf0c04203ddc.log 2016-11-01 09:11:28 Starting to launch local task to process map join; maximum memory = 477626368 2016-11-01 09:11:30 Processing rows:20 Hashtable size: 19 Memory usage: 106513696 percentage: 0.223 2016-11-01 09:11:31 Processing rows:30 Hashtable size: 29 Memory usage: 92688064percentage: 0.194 2016-11-01 09:11:31 Processing rows:40 Hashtable size: 39 Memory usage: 152547912 percentage: 0.319 2016-11-01 09:11:31 Processing rows:50 Hashtable size: 49 Memory usage: 149501320 percentage: 0.313 2016-11-01 09:11:32 Processing rows:60 Hashtable size: 59 Memory usage: 170749448 percentage: 0.357 2016-11-01 09:11:32 Dump the side-table for tag: 1 with group count: 675226 into file: file:/tmp/ubuntu/9b365431-aea2-41fa-bebe-602435a22612/hive_2016-11-01_09-11-2 4_333_5456525982690482779-1/-local-10003/HashTable-Stage-4/MapJoin-mapfile01--.hashtable 2016-11-01 09:11:33 Uploaded 1 File to: file:/tmp/ubuntu/9b365431-aea2-41fa-bebe-602435a22612/hive_2016-11-01_09-11-24_333_5456525982690482779-1/-local-10003/HashTa ble-Stage-4/MapJoin-mapfile01--.hashtable (22302233 bytes) 2016-11-01 09:11:33 End of local task; Time Taken: 5.334 sec. Execution completed successfully MapredLocal task succeeded Launching Job 1 out of 1 Number of reduce tasks is set to 0 since there's no reduce operator Starting Job = job_1477989556419_0006, Tracking URL = http://master:8088/proxy/application_1477989556419_0006/ Kill Command = /home/ubuntu/cloud/hadoop-2.7.2/bin/hadoop job -kill job_1477989556419_0006 Hadoop job information for Stage-4: number of mappers: 1; number of reducers: 0 2016-11-01 09:11:43,429 Stage-4 map = 0%, reduce = 0% 2016-11-01 09:12:44,257 Stage-4 map = 0%, reduce = 0% 2016-11-01 09:13:44,706 Stage-4 map = 0%, reduce = 0% 2016-11-01 09:14:32,819 Stage-4 map = 100%, reduce = 0% Ended Job = job_1477989556419_0006 with errors Error during job, obtaining debugging information... Examining task ID: task_1477989556419_0006_m_00 (and more) from job job_1477989556419_0006 Task with the most failures(4): - Task ID: task_1477989556419_0006_m_00 URL: http://master:8088/taskdetails.jsp?jobid=job_1477989556419_0006=task_1477989556419_0006_m_00 - Diagnostic Messages for this Task: Error: java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:112) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:78) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:449) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109) ... 9 more Caused by: java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:112) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:78) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.mapred.MapRunner.configure(MapRunner.java:38) ... 14 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
[jira] [Updated] (HIVE-15097) Error: java.lang.RuntimeException: Error in configuring object Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded
[ https://issues.apache.org/jira/browse/HIVE-15097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chen cong updated HIVE-15097: - Description: hive> CREATE TABLE user_tag_pre AS > SELECT A.userid , A.tag , A.single_tag_sumcount/B.sum_tag_sumcount_avg as pre > FROM user_tag_sumcount A , user_tag_avg B > WHERE A.userid = B.userid; Query ID = ubuntu_20161031134731_bdbfeaa6-5687-460c-b331-86ce3237aa29 Total jobs = 2 Stage-7 is selected by condition resolver. Stage-1 is filtered out by condition resolver. Execution log at: /tmp/ubuntu/ubuntu_20161031134731_bdbfeaa6-5687-460c-b331-86ce3237aa29.log 2016-10-31 13:47:34 Starting to launch local task to process map join; maximum memory = 477626368 2016-10-31 13:47:37 Processing rows:20 Hashtable size: 19 Memory usage: 134844656 percentage: 0.282 2016-10-31 13:47:38 Processing rows:30 Hashtable size: 29 Memory usage: 121492112 percentage: 0.254 2016-10-31 13:47:38 Processing rows:40 Hashtable size: 39 Memory usage: 122277256 percentage: 0.256 2016-10-31 13:47:38 Processing rows:50 Hashtable size: 49 Memory usage: 151827872 percentage: 0.318 2016-10-31 13:47:40 Processing rows:60 Hashtable size: 59 Memory usage: 179637408 percentage: 0.376 2016-10-31 13:47:40 Dump the side-table for tag: 1 with group count: 675226 into file: file:/tmp/ubuntu/193dc11b-1e25-46a0-b124-210a7ffde96c/hive_2016-10-31_13-47-31_406_4438237799451830529-1/-local-10003/HashTable-Stage-4/MapJoin-mapfile01--.hashtable 2016-10-31 13:47:41 Uploaded 1 File to: file:/tmp/ubuntu/193dc11b-1e25-46a0-b124-210a7ffde96c/hive_2016-10-31_13-47-31_406_4438237799451830529-1/-local-10003/HashTable-Stage-4/MapJoin-mapfile01--.hashtable (22302233 bytes) 2016-10-31 13:47:41 End of local task; Time Taken: 6.116 sec. Execution completed successfully MapredLocal task succeeded Launching Job 2 out of 2 Number of reduce tasks is set to 0 since there's no reduce operator Starting Job = job_1477875480008_0012, Tracking URL = http://master:8088/proxy/application_1477875480008_0012/ Kill Command = /home/ubuntu/cloud/hadoop-2.7.2/bin/hadoop job -kill job_1477875480008_0012 Hadoop job information for Stage-4: number of mappers: 1; number of reducers: 0 2016-10-31 13:47:49,787 Stage-4 map = 0%, reduce = 0% 2016-10-31 13:48:50,370 Stage-4 map = 0%, reduce = 0% 2016-10-31 13:49:50,768 Stage-4 map = 0%, reduce = 0% 2016-10-31 13:50:35,748 Stage-4 map = 100%, reduce = 0% Ended Job = job_1477875480008_0012 with errors Error during job, obtaining debugging information... Examining task ID: task_1477875480008_0012_m_00 (and more) from job job_1477875480008_0012 Task with the most failures(4): - Task ID: task_1477875480008_0012_m_00 URL: http://master:8088/taskdetails.jsp?jobid=job_1477875480008_0012=task_1477875480008_0012_m_00 - Diagnostic Messages for this Task: Error: java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:112) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:78) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:449) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109) ... 9 more Caused by: java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:112) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:78) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.mapred.MapRunner.configure(MapRunner.java:38) ... 14 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
[jira] [Resolved] (HIVE-15089) Error: java.lang.RuntimeException: Hive Runtime Error while closing operators: java.lang.Integer cannot be cast to java.lang.Boolean
[ https://issues.apache.org/jira/browse/HIVE-15089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chen cong resolved HIVE-15089. -- Resolution: Fixed > Error: java.lang.RuntimeException: Hive Runtime Error while closing > operators: java.lang.Integer cannot be cast to java.lang.Boolean > > > Key: HIVE-15089 > URL: https://issues.apache.org/jira/browse/HIVE-15089 > Project: Hive > Issue Type: Bug >Reporter: chen cong > > SELECT userid , gamename , SUM(times) AS sumtimes > FROM user_fenci_sumcount A > RIGHT JOIN need_recommende_game B > ON (TRUE) > WHERE LOCATE(A.fenci,B.gamename) > GROUP BY userid , gamename > ORDER BY A.userid , sumtimes DESC > Error: java.lang.RuntimeException: Hive Runtime Error while closing > operators: java.lang.Integer cannot be cast to java.lang.Boolean > How can I solve it ? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-15089) Error: java.lang.RuntimeException: Hive Runtime Error while closing operators: java.lang.Integer cannot be cast to java.lang.Boolean
[ https://issues.apache.org/jira/browse/HIVE-15089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15614611#comment-15614611 ] chen cong commented on HIVE-15089: -- Thank you very much!I solved the problem! > Error: java.lang.RuntimeException: Hive Runtime Error while closing > operators: java.lang.Integer cannot be cast to java.lang.Boolean > > > Key: HIVE-15089 > URL: https://issues.apache.org/jira/browse/HIVE-15089 > Project: Hive > Issue Type: Bug >Reporter: chen cong > > SELECT userid , gamename , SUM(times) AS sumtimes > FROM user_fenci_sumcount A > RIGHT JOIN need_recommende_game B > ON (TRUE) > WHERE LOCATE(A.fenci,B.gamename) > GROUP BY userid , gamename > ORDER BY A.userid , sumtimes DESC > Error: java.lang.RuntimeException: Hive Runtime Error while closing > operators: java.lang.Integer cannot be cast to java.lang.Boolean > How can I solve it ? -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-15089) Error: java.lang.RuntimeException: Hive Runtime Error while closing operators: java.lang.Integer cannot be cast to java.lang.Boolean
[ https://issues.apache.org/jira/browse/HIVE-15089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] chen cong updated HIVE-15089: - Description: SELECT userid , gamename , SUM(times) AS sumtimes FROM user_fenci_sumcount A RIGHT JOIN need_recommende_game B ON (TRUE) WHERE LOCATE(A.fenci,B.gamename) GROUP BY userid , gamename ORDER BY A.userid , sumtimes DESC Error: java.lang.RuntimeException: Hive Runtime Error while closing operators: java.lang.Integer cannot be cast to java.lang.Boolean How can I solve it ? was: SELECT userid , gamename , SUM(times) AS sumtimes FROM user_fenci_sumcount A RIGHT JOIN need_recommende_game B ON (TRUE) WHERE LOCATE(A.fenci,B.gamename) GROUP BY userid , gamename ORDER BY A.userid , sumtimes DESC > Error: java.lang.RuntimeException: Hive Runtime Error while closing > operators: java.lang.Integer cannot be cast to java.lang.Boolean > > > Key: HIVE-15089 > URL: https://issues.apache.org/jira/browse/HIVE-15089 > Project: Hive > Issue Type: Bug >Reporter: chen cong > > SELECT userid , gamename , SUM(times) AS sumtimes > FROM user_fenci_sumcount A > RIGHT JOIN need_recommende_game B > ON (TRUE) > WHERE LOCATE(A.fenci,B.gamename) > GROUP BY userid , gamename > ORDER BY A.userid , sumtimes DESC > Error: java.lang.RuntimeException: Hive Runtime Error while closing > operators: java.lang.Integer cannot be cast to java.lang.Boolean > How can I solve it ? -- This message was sent by Atlassian JIRA (v6.3.4#6332)