Re: ERROR 201 (22000): Illegal data on Upsert Select

2015-08-20 Thread Josh Mahonin
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

ERROR 201 (22000): Illegal data on Upsert Select

2015-08-20 Thread Yiannis Gkoufas
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:

Re: ERROR 201 (22000): Illegal data on Upsert Select

2015-08-20 Thread Samarth Jain
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