Tracking in https://issues.apache.org/jira/browse/PHOENIX-2169
On Thu, Aug 20, 2015 at 5:14 PM, Samarth Jain <sama...@apache.org> wrote: > Yiannis, > > Can you please provide a reproducible test case (schema, minimum data to > reproduce the error) along with the phoenix and hbase versions so we can > take a look at it further. > > Thanks, > Samarh > > On Thu, Aug 20, 2015 at 2:09 PM, Yiannis Gkoufas <johngou...@gmail.com> > wrote: > >> Hi there, >> >> I am getting an error while executing: >> >> UPSERT INTO READINGS >> SELECT R.SMID, R.DT, R.US, R.GEN, R.USEST, R.GENEST, RM.LAT, RM.LON, >> RM.ZIP, RM.FEEDER >> FROM READINGS AS R >> JOIN >> (SELECT SMID,LAT,LON,ZIP,FEEDER >> FROM READINGS_META) AS RM >> ON R.SMID = RM.SMID >> >> the full stacktrace is: >> >> Error: ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. >> Expected length of at least 70 bytes, but had 25 (state=22000,code=201) >> java.sql.SQLException: ERROR 201 (22000): Illegal data. ERROR 201 >> (22000): Illegal data. Expected length of at least 70 bytes, but had 25 >> at >> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:388) >> at >> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) >> at >> org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:131) >> at >> org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:115) >> at >> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:104) >> at >> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:553) >> at >> org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176) >> at >> org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91) >> at >> org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44) >> at >> org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:685) >> at >> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314) >> at >> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:306) >> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> at >> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:304) >> at >> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1374) >> at sqlline.Commands.execute(Commands.java:822) >> at sqlline.Commands.sql(Commands.java:732) >> at sqlline.SqlLine.dispatch(SqlLine.java:808) >> at sqlline.SqlLine.begin(SqlLine.java:681) >> at sqlline.SqlLine.start(SqlLine.java:398) >> at sqlline.SqlLine.main(SqlLine.java:292) >> >> I was wondering whether its something wrong with my data or its a bug of >> Phoenix. >> How can I debug this error and identify what row is problematic? >> But the way, the SELECT statement on its own works fine. >> >> Thanks a lot! >> > >