Yin Huai created HIVE-6631:
------------------------------

             Summary: 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
            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