Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Merge Hive - Error : Method didn't match: passed

Highlighted

Merge Hive - Error : Method didn't match: passed

New Contributor

Hi all,

I have problem. I using "Merge" with Hive, and get error. I need a solution or desciption for it.

Log Hive:

2018-10-15 10:23:16,697 DEBUG exec.FilterOperator (Operator.java:initialize(373)) - Initialization Done 1 FIL done is reset.
2018-10-15 10:23:16,697 DEBUG exec.FilterOperator (Operator.java:initializeChildren(430)) - Operator 1 FIL initialized
2018-10-15 10:23:16,697 DEBUG exec.FilterOperator (Operator.java:initializeChildren(436)) - Initializing children of 1 FIL
2018-10-15 10:23:16,697 DEBUG exec.HashTableSinkOperator (Operator.java:initialize(470)) - Initializing child 2 HASHTABLESINK
2018-10-15 10:23:16,698 INFO  exec.HashTableSinkOperator (Operator.java:initialize(333)) - Initializing operator HASHTABLESINK[2]
2018-10-15 10:23:16,698 INFO  mapjoin.MapJoinMemoryExhaustionHandler (MapJoinMemoryExhaustionHandler.java:<init>(61)) - JVM Max Heap Size: 1046478848
2018-10-15 10:23:16,700 DEBUG exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2389)) - Hive Conf not found or Session not initiated, use thread based class loader instead
2018-10-15 10:23:16,701 DEBUG exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2389)) - Hive Conf not found or Session not initiated, use thread based class loader instead
2018-10-15 10:23:16,703 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [int] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.io.IntWritable)
2018-10-15 10:23:16,703 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method did match: passed = [varchar(100)] accepted = [decimal(38,18)] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.hive.serde2.io.HiveDecimalWritable)
2018-10-15 10:23:16,703 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [float] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.io.FloatWritable)
2018-10-15 10:23:16,704 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method did match: passed = [varchar(100)] accepted = [double] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.hive.serde2.io.DoubleWritable)
2018-10-15 10:23:16,704 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method did match: passed = [varchar(100)] accepted = [string] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.io.Text)
2018-10-15 10:23:16,704 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [timestamp] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.hive.serde2.io.TimestampWritable)
2018-10-15 10:23:16,704 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [bigint] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.io.LongWritable)
2018-10-15 10:23:16,704 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [void] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.io.NullWritable)
2018-10-15 10:23:16,704 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [boolean] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.io.BooleanWritable)
2018-10-15 10:23:16,705 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [tinyint] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.hive.serde2.io.ByteWritable)
2018-10-15 10:23:16,705 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method didn't match: passed = [varchar(100)] accepted = [smallint] method = public org.apache.hadoop.io.LongWritable org.apache.hadoop.hive.ql.udf.UDFToLong.evaluate(org.apache.hadoop.hive.serde2.io.ShortWritable)
2018-10-15 10:23:16,711 DEBUG exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2389)) - Hive Conf not found or Session not initiated, use thread based class loader instead
2018-10-15 10:23:16,711 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method did match: passed = [bigint] accepted = [decimal(38,18)] method = public org.apache.hadoop.hive.serde2.io.DoubleWritable org.apache.hadoop.hive.ql.udf.UDFToDouble.evaluate(org.apache.hadoop.hive.serde2.io.HiveDecimalWritable)
2018-10-15 10:23:16,711 DEBUG exec.FunctionRegistry (FunctionRegistry.java:getMethodInternal(1175)) - Method did match: passed = [bigint] accepted = [bigint] method = public org.apache.hadoop.hive.serde2.io.DoubleWritable org.apache.hadoop.hive.ql.udf.UDFToDouble.evaluate(org.apache.hadoop.io.LongWritable)
2018-10-15 10:23:16,712 ERROR mr.MapredLocalTask (MapredLocalTask.java:executeInProcess(356)) - Hive Runtime Error: Map local work failed
java.lang.NullPointerException
	at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.initialize(ExprNodeColumnEvaluator.java:56)
	at org.apache.hadoop.hive.ql.exec.JoinUtil.getObjectInspectorsFromEvaluators(JoinUtil.java:77)
	at org.apache.hadoop.hive.ql.exec.HashTableSinkOperator.initializeOp(HashTableSinkOperator.java:147)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:363)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:482)
	at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:439)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:482)
	at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:439)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:376)
	at org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.initializeOperators(MapredLocalTask.java:461)
	at org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.startForward(MapredLocalTask.java:365)
	at org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask.executeInProcess(MapredLocalTask.java:345)
	at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.main(ExecDriver.java:748)
	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.RunJar.run(RunJar.java:233)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:148)

Thanks.