Csaba Ringhofer created IMPALA-10425:
----------------------------------------
Summary: Cryptic error message for missing tables in subqueries
Key: IMPALA-10425
URL: https://issues.apache.org/jira/browse/IMPALA-10425
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Reporter: Csaba Ringhofer
{code}
explain select ps_suppkey
from tpch_parquet.partsupp
where ps_supplycost = (
select
min(ps_supplycost)
from
partsupp
);
{code}
leads to the error:
{code}
ERROR: AnalysisException: Illegal table reference to non-collection type:
'partsupp'
Path resolved to type:
STRUCT<ps_partkey:BIGINT,ps_suppkey:BIGINT,ps_availqty:INT,ps_supplycost:DECIMAL(12,2),ps_comment:STRING>
{code}
This happens only if the table in the outer query is fully qualified and
exists, but we use a non fully qualified name in the inner query, and no such
table exists in the current database. Otherwise the error returned is the much
simpler:
{code}
ERROR: AnalysisException: Could not resolve table reference: 'partsupp'
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
