phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Mahonin <jmaho...@interset.com>
Subject Re: "ERROR 201 (22000): Illegal data" on Upsert Select
Date Fri, 21 Aug 2015 01:33:06 GMT
Tracking in https://issues.apache.org/jira/browse/PHOENIX-2169

On Thu, Aug 20, 2015 at 5:14 PM, Samarth Jain <samarth@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 <johngouf85@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!
>>
>
>

Mime
View raw message