You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Greg Rahn (Jira)" <ji...@apache.org> on 2019/11/05 22:03:00 UTC
[jira] [Updated] (IMPALA-9025) An Impala query fails with error
"ERROR: IllegalStateException: null"
[ https://issues.apache.org/jira/browse/IMPALA-9025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Greg Rahn updated IMPALA-9025:
------------------------------
Description:
Synopsis:
=========
An Impala query fails with error "ERROR: IllegalStateException: null"
Problem:
========
Customer has provided the following reproduction case:
{noformat}
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;
{noformat}
Impala logs shows the following warning:
{noformat}
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}}
{noformat}
was:
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}}
> 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
> Priority: Major
> Fix For: Impala 3.4.0
>
>
> Synopsis:
> =========
> An Impala query fails with error "ERROR: IllegalStateException: null"
> Problem:
> ========
> Customer has provided the following reproduction case:
> {noformat}
> 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;
> {noformat}
> Impala logs shows the following warning:
> {noformat}
> 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}}
> {noformat}
--
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