Re: Exception ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 4

2017-07-11 Thread Takashi Sasaki
Hi Josh, PHOENIX-3453 is a similar phenomenon, but it seems to be different exactly. I executed query directly, but the error wasn't occur. Perhaps it is a complex cause. I'm using HBase with AWS S3 storage mode, and wrapping JDBC with MyBATIS, and so on. I'll report it again when the same

Re: Exception ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 4

2017-07-06 Thread Josh Mahonin
Hi Takashi, Thanks for the update. Do you think it could be the same issue as https://issues.apache.org/jira/browse/PHOENIX-3453 ? If not, it would be great if you could file a new JIRA ticket with as much detail as possible, and ideally a simple way to reproduce it. Thanks! Josh On Thu, Jul

Re: Exception ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 4

2017-07-06 Thread Takashi Sasaki
Hi Josh, Well, it is difficult soon. I'll execute query directly if I have time. Information on the table is difficult to post due to confidentiality agreement, but negotiate with my boss and provide it if possible. By the way, changing all local indexes to all global indexes no longer causes

Re: Exception ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 4

2017-07-05 Thread Josh Mahonin
Hi, >From the logs you attached, it appears that you're getting the exception on the following query: SELECT trid, tid, frtp, frno, gzid, ontm, onty, onlt, onln, oftm, ofty, oflt, ofln, onwk, onhr, wday, dist, drtn, delf, sntf, cdtm, udtm FROM trp WHERE tid = ? AND delf = FALSE ORDER BY oftm

Exception ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 4

2017-07-04 Thread Takashi Sasaki
Hi, I'm using Phoenix4.9.0/HBase1.3.0 with Spark2.1.1 on AWS EMR 5.6.0. When one side uses Spark Streaming to write a lot of data and the other side uses Spark to read data, I encounter several similar exceptions. 17/07/05 04:33:47 ERROR Executor: Exception in task 83.0 in stage 166.0 (TID