hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amit Bajpai <Amit.Baj...@flextronics.com>
Subject Hive Insert query is failing
Date Sat, 07 Jan 2017 23:42:30 GMT
Hi,

Hive query running on Tez to insert from one table to another is failing with the below error.
Both the tables have file format as ORC and all the columns in both the tables are string.
Can anyone help on how it can be fixed.

Hive version: 1.2.1.2.4

Error message:
Vertex failed, vertexName=Map 1, vertexId=vertex_1483552897173_0276_1_00, diagnostics=[Task
failed, taskId=task_1483552897173_0276_1_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Error:
Failure while running task:java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException:
java.io.IOException: ORC does not support type conversion from VARCHAR to STRING
at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:173)
at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:139)
at org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:344)
at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:181)
at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:172)
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:1709)
at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable.callInternal(TezTaskRunner.java:172)
at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable.callInternal(TezTaskRunner.java:168)
at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Query:
insert into table tableB  select col1, col2, col3, col4, col5, col6, col7, col8 from tableA

Thanks
Amit

Legal Disclaimer:
The information contained in this message may be privileged and confidential. It is intended
to be read only by the individual or entity to whom it is addressed or by their designee.
If the reader of this message is not the intended recipient, you are on notice that any distribution
of this message, in any form, is strictly prohibited. If you have received this message in
error, please immediately notify the sender and delete or destroy any copy of this message!
Mime
View raw message