hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjeev Verma <sanjeev.verm...@gmail.com>
Subject Re: hive create table error
Date Mon, 12 Oct 2015 07:28:16 GMT
getting this exception

Error: java.lang.RuntimeException:
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
processing row

at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:185)

at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)

at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:435)

at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347)

at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAs(Subject.java:415)

at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1566)

at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
Error while processing row

at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:503)

at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:176)

... 8 more

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unexpected
exception: org.apache.hadoop.io.Text cannot be cast to
org.apache.hadoop.hive.serde2.io.HiveVarcharWritable

at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:311)

at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:815)

at
org.apache.hadoop.hive.ql.exec.FilterOperator.processOp(FilterOperator.java:120)

at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:815)

at
org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:95)

at
org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.forward(MapOperator.java:157)

at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:493)

... 9 more

Caused by: java.lang.ClassCastException: org.apache.hadoop.io.Text cannot
be cast to org.apache.hadoop.hive.serde2.io.HiveVarcharWritable

at
org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableHiveVarcharObjectInspector.copyObject(WritableHiveVarcharObjectInspector.java:109)

at
org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.copyToStandardObject(ObjectInspectorUtils.java:305)

at org.apache.hadoop.hive.ql.exec.JoinUtil.computeValues(JoinUtil.java:193)

at
org.apache.hadoop.hive.ql.exec.CommonJoinOperator.getFilteredValue(CommonJoinOperator.java:408)

at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:295)

... 15 more





FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.mr.MapRedTask

MapReduce Jobs Launched:

Stage-Stage-4: Map: 2 MAPRFS Read: 0 MAPRFS Write: 0 FAIL

Total MapReduce CPU Time Spent: 0 msec

On Mon, Oct 12, 2015 at 12:42 PM, Syed Abulullah <sabulullah@hortonworks.com
> wrote:

> Hi Sanjeev -
>
> Did you try to change your query to explicitly specify par.*
>
> create table sample_table AS select *par.** from parquet_table par inner
> join parquet_table_counter ptc  ON ptc.user_id=par.user_id;
>
> Thanks.
> From: Sanjeev Verma <sanjeev.verma82@gmail.com>
> Reply-To: "user@hive.apache.org" <user@hive.apache.org>
> Date: Monday, October 12, 2015 at 2:07 AM
> To: "user@hive.apache.org" <user@hive.apache.org>, "dev@hive.apache.org" <
> dev@hive.apache.org>
> Subject: hive create table error
>
> I am creating a table from the two parquet partioned tables and getting
> the error duplicate column. any idea whats going wrong here.
>
> create table sample_table AS select * from parquet_table par inner
> join parquet_table_counter ptc  ON ptc.user_di=par.user_id;
>
>
> FAILED: SemanticException [Error 10036]: Duplicate column name: user_id
>

Mime
View raw message