[jira] [Created] (IMPALA-10425) Cryptic error message for missing tables in subqueries

["Csaba Ringhofer (Jira)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org