Yongzhi Chen created IMPALA-9025:
------------------------------------
Summary: An Impala query fails with error "ERROR:
IllegalStateException: null"
Key: IMPALA-9025
URL: https://issues.apache.org/jira/browse/IMPALA-9025
Project: IMPALA
Issue Type: Bug
Components: Frontend
Reporter: Yongzhi Chen
Assignee: Yongzhi Chen
Synopsis:
=========
An Impala query fails with error "ERROR: IllegalStateException: null"
Problem:
========
Customer has provided the following reproduction case:
create table tab1( tdate decimal(10,0) )
partitioned by (p_tdate int);
select
*
from
(SELECT
t.*
FROM
tab1 t
INNER JOIN
(SELECT 20191004 tdate ) d
WHERE
t.p_tdate < d.tdate
) q
where
p_tdate <> tdate
and P_TDATE = 20191004;
Impala logs shows the following warning:
W1007 10:04:42.954334 1945974 Expr.java:1075] Not able to analyze after
rewrite: org.apache.impala.common.AnalysisException: Column/field reference is
ambiguous: 'tdate' conjuncts: BinaryPredicate{op=!=,
NumericLiteral{value=20191004, type=BIGINT} CastExpr{isImplicit=true,
target=BIGINT, SlotRef{path=tdate, type=DECIMAL(10,0), id=1}}}
BinaryPredicate{op==, SlotRef{path=p_tdate, type=INT, id=2}
NumericLiteral{value=20191004, type=INT}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
