Discussion:
Can not do insert query error code -101
ZongtianHou
2018-10-27 12:50:17 UTC
Permalink
Hi, everyone,
I have installed hive3.0 and tried it. I created a table , but can’t insert a record into it. Below is the operation and error info, any hint will be very appreciated!

hive> create table ii(a int);
OK
Time taken: 1.337 seconds
hive> insert into ii values (2);
Query ID = kousouda_20181027204327_b848a734-a159-4ac1-95e5-82ccc9859567
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. tried to access method com.google.common.base.Stopwatch.<init>()V from class org.apache.hadoop.mapreduce.lib.input.FileInputFormat
Tanvi Thacker
2018-10-31 19:44:24 UTC
Permalink
Detail exception would be more helpful if you can share by re-running the
query after enabling debug mode in Hive?

As per the current information, it seems that you have a conflicting guava
dependency in the Hive classpath(probably pulled from older Hadoop), check
what all guava versions you have in the classpath and keep the one which is
shipped with Hive 3.0 only.

Regards
Tanvi Thacker
Post by ZongtianHou
Hi, everyone,
I have installed hive3.0 and tried it. I created a table , but can’t
insert a record into it. Below is the operation and error info, any hint
will be very appreciated!
hive> create table ii(a int);
OK
Time taken: 1.337 seconds
hive> insert into ii values (2);
Query ID = kousouda_20181027204327_b848a734-a159-4ac1-95e5-82ccc9859567
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
FAILED: Execution Error, return code -101 from
org.apache.hadoop.hive.ql.exec.mr.MapRedTask. tried to access method
com.google.common.base.Stopwatch.<init>()V from class
org.apache.hadoop.mapreduce.lib.input.FileInputFormat
陈伟光
2018-11-05 06:37:59 UTC
Permalink
Thank you for your answer
My Hadoop is indeed an older version of Hadoop, but it can perform select
operations in HPL/SQL
I just contacted Hadoop, so I don't know how to ask my question better. I
hope you can provide a link, and I will be very grateful to you
Regards
Weiguang Chen
Post by Tanvi Thacker
Detail exception would be more helpful if you can share by re-running the
query after enabling debug mode in Hive?
As per the current information, it seems that you have a conflicting guava
dependency in the Hive classpath(probably pulled from older Hadoop), check
what all guava versions you have in the classpath and keep the one which is
shipped with Hive 3.0 only.
Regards
Tanvi Thacker
Post by ZongtianHou
Hi, everyone,
I have installed hive3.0 and tried it. I created a table , but can’t
insert a record into it. Below is the operation and error info, any hint
will be very appreciated!
hive> create table ii(a int);
OK
Time taken: 1.337 seconds
hive> insert into ii values (2);
Query ID = kousouda_20181027204327_b848a734-a159-4ac1-95e5-82ccc9859567
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
FAILED: Execution Error, return code -101 from
org.apache.hadoop.hive.ql.exec.mr.MapRedTask. tried to access method
com.google.common.base.Stopwatch.<init>()V from class
org.apache.hadoop.mapreduce.lib.input.FileInputFormat
Loading...