You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Yin Huai (JIRA)" <ji...@apache.org> on 2014/03/22 03:16:43 UTC

[jira] [Resolved] (HIVE-6631) NPE when select a field of a struct from a table stored by ORC

     [ https://issues.apache.org/jira/browse/HIVE-6631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yin Huai resolved HIVE-6631.
----------------------------

    Resolution: Duplicate

> NPE when select a field of a struct from a table stored by ORC
> --------------------------------------------------------------
>
>                 Key: HIVE-6631
>                 URL: https://issues.apache.org/jira/browse/HIVE-6631
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor, Serializers/Deserializers
>    Affects Versions: 0.13.0, 0.14.0
>            Reporter: Yin Huai
>
> I have a table like this ...
> {code:sql}
> create table lineitem_orc_cg
> (
> CG1 STRUCT<L_PARTKEY:INT,
>            L_SUPPKEY:INT,
>            L_COMMITDATE:STRING,
>            L_RECEIPTDATE:STRING,
>            L_SHIPINSTRUCT:STRING,
>            L_SHIPMODE:STRING,
>            L_COMMENT:STRING,
>            L_TAX:float,
>            L_RETURNFLAG:STRING,
>            L_LINESTATUS:STRING,
>            L_LINENUMBER:INT,
>            L_ORDERKEY:INT>,
> CG2 STRUCT<L_QUANTITY:float,
>            L_EXTENDEDPRICE:float,
>            L_DISCOUNT:float,
>            L_SHIPDATE:STRING>
> )
> row format serde 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
> stored as orc tblproperties ("orc.compress"="NONE");
> {code}
> When I want to select a field from a struct by using
> {code:sql}
> select cg1.l_comment from lineitem_orc_cg limit 1;
> {code}
> I got 
> {code}
> Caused by: java.lang.NullPointerException
> 	at org.apache.hadoop.hive.ql.exec.ExprNodeFieldEvaluator.initialize(ExprNodeFieldEvaluator.java:61)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initEvaluators(Operator.java:928)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initEvaluatorsAndReturnStruct(Operator.java:954)
> 	at org.apache.hadoop.hive.ql.exec.SelectOperator.initializeOp(SelectOperator.java:65)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:375)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:459)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:415)
> 	at org.apache.hadoop.hive.ql.exec.TableScanOperator.initializeOp(TableScanOperator.java:189)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:375)
> 	at org.apache.hadoop.hive.ql.exec.MapOperator.initializeOp(MapOperator.java:409)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:375)
> 	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:133)
> 	... 22 more
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)