[ 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: {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} > 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org