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

Yin Huai updated HIVE-6631:
---------------------------

    Affects Version/s: 0.14.0
                       0.13.0

> 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 two tables lineitem_orc_cg
> {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)

Reply via email to