Return-Path: X-Original-To: apmail-phoenix-dev-archive@minotaur.apache.org Delivered-To: apmail-phoenix-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 94FEA17CFA for ; Sat, 7 Mar 2015 07:43:44 +0000 (UTC) Received: (qmail 9589 invoked by uid 500); 7 Mar 2015 07:43:44 -0000 Delivered-To: apmail-phoenix-dev-archive@phoenix.apache.org Received: (qmail 9531 invoked by uid 500); 7 Mar 2015 07:43:44 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 9520 invoked by uid 99); 7 Mar 2015 07:43:44 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Mar 2015 07:43:44 +0000 Received: from mail-yh0-f44.google.com (mail-yh0-f44.google.com [209.85.213.44]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id F0D551A00A0 for ; Sat, 7 Mar 2015 07:43:43 +0000 (UTC) Received: by yhoa41 with SMTP id a41so31523209yho.9 for ; Fri, 06 Mar 2015 23:43:43 -0800 (PST) MIME-Version: 1.0 X-Received: by 10.236.89.171 with SMTP id c31mr16549433yhf.160.1425714223220; Fri, 06 Mar 2015 23:43:43 -0800 (PST) Received: by 10.170.170.213 with HTTP; Fri, 6 Mar 2015 23:43:43 -0800 (PST) In-Reply-To: <0f0c01d0588c$8497f000$8dc7d000$@alibaba-inc.com> References: <0f0c01d0588c$8497f000$8dc7d000$@alibaba-inc.com> Date: Fri, 6 Mar 2015 23:43:43 -0800 Message-ID: Subject: Re: re : And expression of primary key RVCs can not compile From: James Taylor To: "dev@phoenix.apache.org" , =?UTF-8?B?5a2f5bqG5LmJKOWtn+W6huS5iSk=?= Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thank you very much for reporting this. I've filed PHOENIX-1709 and attached a patch. If you can let me know if the patch fixes the issue at your end, that would be much appreciated. We'll make sure this makes it into the next release. James On Fri, Mar 6, 2015 at 8:09 PM, =E5=AD=9F=E5=BA=86=E4=B9=89(=E5=AD=9F=E5=BA= =86=E4=B9=89) wrote: > Hi, taylor: > Phoenix 3.3 still has this issue > I tried in two way: > 1, download release version 3.3 > 2, compile from branch 3.2 > > > -----=E9=82=AE=E4=BB=B6=E5=8E=9F=E4=BB=B6----- > =E5=8F=91=E4=BB=B6=E4=BA=BA: James Taylor [mailto:jamestaylor@apache.org] > =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2015=E5=B9=B43=E6=9C=887=E6=97=A5 0= :36 > =E6=94=B6=E4=BB=B6=E4=BA=BA: dev@phoenix.apache.org; =E5=AD=9F=E5=BA=86= =E4=B9=89(=E5=AD=9F=E5=BA=86=E4=B9=89) > =E4=B8=BB=E9=A2=98: Re: And expression of primary key RVCs can not compil= e > > Please try on Phoenix 3.3 as I suspect this is fixed. > > On Friday, March 6, 2015, =E5=AD=9F=E5=BA=86=E4=B9=89(=E5=AD=9F=E5=BA=86= =E4=B9=89) 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 =3D 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.interse >> ctSlot >> s(WhereOptimizer.java:506) >> at >> >> org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.andKeyS >> lots(W >> hereOptimizer.java:551) >> at >> >> org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLe >> ave(Wh >> ereOptimizer.java:725) >> at >> >> org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLe >> ave(Wh >> ereOptimizer.java:349) >> at >> org.apache.phoenix.expression.AndExpression.accept(AndExpression.java:10= 0) >> at >> >> org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(Whe >> reOpti >> mizer.java:117) >> at >> org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:105) >> at >> >> org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompi >> ler.ja >> va:324) >> at >> org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:132) >> at >> >> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.com >> pilePl >> an(PhoenixStatement.java:296) >> at >> >> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.com >> pilePl >> an(PhoenixStatement.java:284) >> at >> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:20= 8) >> at >> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:20= 4) >> at >> >> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExec >> utor.j >> ava:54) >> at >> >> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.j= ava: >> 204) >> at >> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:9= 67) >> 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 >> >> >> >> >