[
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)
