[
https://issues.apache.org/jira/browse/HIVE-23964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17869343#comment-17869343
]
Krisztian Kasa commented on HIVE-23964:
---------------------------------------
There is no longer a {{c_last_review_date}} in the {{customer}} table. It is
replaced with {{c_last_review_date_sk}}
It seems that the TPC-DS schema changed:
{code}
Replaced two occurrences of "c_last_review_date" with "c_last_review_date_sk"
to be consistent
with Table 2-14 (Customer Table Column Definitions) in section 2.4.7 of the
specification (fogbugz
2046).
{code}
https://www.tpc.org/TPC_Documents_Current_Versions/pdf/TPC-DS_v3.2.0.pdf
> SemanticException in query 30 while generating logical plan
> -----------------------------------------------------------
>
> Key: HIVE-23964
> URL: https://issues.apache.org/jira/browse/HIVE-23964
> Project: Hive
> Issue Type: Bug
> Reporter: Stamatis Zampetakis
> Priority: Major
> Attachments: cbo_query30_stacktrace.txt
>
>
> Invalid table alias or column reference 'c_last_review_date' is thrown when
> running TPC-DS query 30 (cbo_query30.q, query30.q) on the metastore with the
> partitoned TPC-DS 30TB dataset.
> The respective stacktrace is attached to this case.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
