You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Charles Halpern <ch...@attinteractive.com> on 2009/11/23 20:29:11 UTC

Error trying to insert query results into a table

java.lang.NullPointerException
 at 
org.apache.hadoop.hive.ql.exec.MapOperator.initObjectInspector(MapOperator.j
ava:176)
 at 
org.apache.hadoop.hive.ql.exec.MapOperator.initializeOp(MapOperator.java:204
)
 at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:264)
 at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:103)
 at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
 at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:356)
 at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305)
 at org.apache.hadoop.mapred.Child.main(Child.java:170)



Trying to execute this hine statement:

insert overwrite table cah_test partition (ds='20091122', source='CS')
select <various fields> from src_table  where ds='20091122' and source='CS';


-- 
Charlie Halpern
Office:  818-937-5579
Cell:      818-641-8457
IM:       chazh98@yahoo.com

Re: Error trying to insert query results into a table

Posted by Carl Steinbach <ca...@cloudera.com>.
Hi Charlie,

Looks like you're running into this problem:
http://www.mail-archive.com/hive-dev@hadoop.apache.org/msg05533.html

It was fixed in HIVE-636, and this patch is included in hive-0.4.0.
Upgrading to 0.4.0 should fix the problem.

Thanks.

Carl

On Mon, Nov 23, 2009 at 11:29 AM, Charles Halpern <
chalpern@attinteractive.com> wrote:

>
> java.lang.NullPointerException
>  at
> org.apache.hadoop.hive.ql.exec.MapOperator.initObjectInspector(MapOperator.java:176)
>  at
> org.apache.hadoop.hive.ql.exec.MapOperator.initializeOp(MapOperator.java:204)
>  at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:264)
>  at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:103)
>  at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
>  at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:356)
>  at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305)
>  at org.apache.hadoop.mapred.Child.main(Child.java:170)
>
>
>
> Trying to execute this hine statement:
>
> insert overwrite table cah_test partition (ds='20091122', source='CS')
> select *<various fields>* from src_table  where ds='20091122' and
> source='CS';
>
>
> --
> *Charlie Halpern
> **Office*:  818-937-5579
> *Cell*:      818-641-8457
> *IM*:       chazh98@yahoo.com
>
>