Please try on Phoenix 3.3 as I suspect this is fixed. On Friday, March 6, 2015, 孟庆义(孟庆义) <qingyi....@alibaba-inc.com> wrote:
> Dears: > > 1 . create table t (a integer not null, b integer not null, c integer > constrains pk primary key (a,b)); > > 2. select c from t where a in (1,2) and b = 3 and (a,b) in ( (1,2) , > (1,3) > ); > > I got exception on compile : > > java.lang.IllegalArgumentException > at > com.google.common.base.Preconditions.checkArgument(Preconditions.java:76) > at > > org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor$KeySlot.inter > sect(WhereOptimizer.java:955) > at > > org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.intersectSlot > s(WhereOptimizer.java:506) > at > > org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.andKeySlots(W > hereOptimizer.java:551) > at > > org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLeave(Wh > ereOptimizer.java:725) > at > > org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLeave(Wh > ereOptimizer.java:349) > at > org.apache.phoenix.expression.AndExpression.accept(AndExpression.java:100) > at > > org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(WhereOpti > mizer.java:117) > at > org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:105) > at > > org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.ja > va:324) > at > org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:132) > at > > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePl > an(PhoenixStatement.java:296) > at > > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePl > an(PhoenixStatement.java:284) > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:208) > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:204) > at > > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.j > ava:54) > at > > org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java: > 204) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:967) > at sqlline.SqlLine$Commands.execute(SqlLine.java:3673) > at sqlline.SqlLine$Commands.sql(SqlLine.java:3584) > at sqlline.SqlLine.dispatch(SqlLine.java:821) > at sqlline.SqlLine.begin(SqlLine.java:699) > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) > at sqlline.SqlLine.main(SqlLine.java:424) > > > > Is this an known issue? I use phoenix3.0 > > > > Daniel.meng > > > >
