You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sungwoo (Jira)" <ji...@apache.org> on 2022/10/11 14:12:00 UTC
[jira] [Commented] (HIVE-26621) TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []
[ https://issues.apache.org/jira/browse/HIVE-26621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17615850#comment-17615850 ]
Sungwoo commented on HIVE-26621:
--------------------------------
I used the master branch, commit 57d1ad69f56f990d387b4a48354aea7581745f07 of Oct 11, 2022. For loading ORC tables and executing TPC-DS queries, I used Hive on Tez.
> TPC-DS query 2 fails with java.lang.RuntimeException: cannot find field _col0 from []
> -------------------------------------------------------------------------------------
>
> Key: HIVE-26621
> URL: https://issues.apache.org/jira/browse/HIVE-26621
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0-alpha-1
> Reporter: Sungwoo
> Priority: Critical
>
> How to reproduce:
> 1. Build Hive using the master branch. Tez version is 0.10.2.
> 2. Generate 100GB TPC-DS text data.
> 3. Load the TPC-DS data using ORC format.
> 4. Run TPC-DS queries. Query 2 fails with the error shown below.
>
> {code:java}
> Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: cannot find field _col0 from []
> at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOperator.java:384)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:888)
> at org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:94)
> at org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:370)
> ... 19 more
> Caused by: java.lang.RuntimeException: cannot find field _col0 from []
> at org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.getStandardStructFieldRef(ObjectInspectorUtils.java:550)
> at org.apache.hadoop.hive.serde2.objectinspector.StandardStructObjectInspector.getStructFieldRef(StandardStructObjectInspector.java:153)
> at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.initialize(ExprNodeColumnEvaluator.java:56)
> at org.apache.hadoop.hive.ql.exec.Operator.initEvaluators(Operator.java:1073)
> at org.apache.hadoop.hive.ql.exec.Operator.initEvaluatorsAndReturnStruct(Operator.java:1099)
> at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOperator.java:305)
> ... 22 more
>
> {code}
>
> A slightly simplified query that produces the same error is:
> {code:java}
> with wscs as
> (select sold_date_sk
> ,sales_price
> from (select ws_sold_date_sk sold_date_sk
> ,ws_ext_sales_price sales_price
> from web_sales) x
> union all
> (select cs_sold_date_sk sold_date_sk
> ,cs_ext_sales_price sales_price
> from catalog_sales)),
> wswscs as
> (select d_week_seq
> from wscs
> ,date_dim
> where d_date_sk = sold_date_sk
> group by d_week_seq)
> select d_week_seq1
> from
> (select wswscs.d_week_seq d_week_seq1
> from wswscs,date_dim
> where date_dim.d_week_seq = wswscs.d_week_seq and d_year = 2001) y,
> (select wswscs.d_week_seq d_week_seq2
> from wswscs,date_dim
> where date_dim.d_week_seq = wswscs.d_week_seq and d_year = 2001+1) z
> where d_week_seq1=d_week_seq2-53
> order by d_week_seq1;{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)