ERROR 201 (22000) illegal data error, expected length at least 4 but had ...

Hi I’ve create a table in phoenix. CREATE TABLE WINLOSS ( dayNumber VARCHAR NOT NULL, type VARCHAR NOT NULL, historyId VARCHAR NOT NULL, seq INTEGER NOT NULL, timestamp BIGINT, name VARCHAR, gameType VARCHAR, playType VARCHAR, gameKind VARCHAR, onRitt BOOLE

Re: ERROR 201 (22000) illegal data error, expected length at least 4 but had ...

oh. phoenix version is 4.7.0 and on EMR. Thx. > On Aug 5, 2016, at 11:27 PM, Dong-iL, Kim wrote: > > Hi > I’ve create a table in phoenix. > > CREATE TABLE WINLOSS ( >dayNumber VARCHAR NOT NULL, >type VARCHAR NOT NULL, >historyId VARCHAR NOT NULL

phoenix 4.7.0 on EMR 5

Hi. I use phoenix on amazon EMR 5. but there is no repository of version 4.7.0-HBase-1.2. how can I build my application with maven? thanks.

Re: ERROR 201 (22000) illegal data error, expected length at least 4 but had ...

Thank you so much. > On Aug 9, 2016, at 6:27 PM, Ankit Singhal wrote: > > Hi Dong-iL Kim, > > As you said , you are inserting data from hbase, so the exception can be seen > if the primary key and columns are not properly represented or encoded as per > Phoenix. >

Re: ERROR 201 (22000) illegal data error, expected length at least 4 but had ...

Oh. Thanks a lot. do you have a snippet for generating composite key? I’m sorry for my laziness. > On Aug 12, 2016, at 3:24 PM, vikashtalanki wrote: > > Hi Dong, > > If you still want to insert through hbase, you can use the below snippets > for encoding values as per phoenix. ---> import >

java.lang.IllegalStateException: Number of bytes to resize to must be greater than zero, but instead is -1984010164

Hi. when I’m using simple groupby query, exception occured as below. What shall I do? Thanks. Error: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: PLAYER_ACTION,\x00\x00B\x8D2J7GvczV2U8J8Z2itjcODTGI\x003\x001\x004\x00\x80\x00\x00\x00\x00l\xE1e1

Re: java.lang.IllegalStateException: Number of bytes to resize to must be greater than zero, but instead is -1984010164

Thank you. I’ll dig with it. > On Aug 31, 2016, at 6:21 PM, Ankit Singhal wrote: > > can you confirm what values are set for > phoenix.groupby.estimatedDistinctValues(Integer) and > phoenix.groupby.maxCacheSize(long)? > > On Wed, Aug 31, 2016 at 12:24 PM, Dong-i

Caused by: org.apache.calcite.avatica.NoSuchStatementException: null

Hi. sporadically NoSuchStatementException occured when i’m using simple upsert. What shall I do? Regards.

using MapReduce java.sql.SQLException: No suitable driver found for jdbc:phoenix occured.

Hi. I've tested the map reduce code on homepage. It coudln’t find the jdbc driver as below. I've insert this code "Class.forName("org.apache.phoenix.jdbc.PhoenixDriver”);" in mred main method but there is no effect. What shall I do? Regards. Error: java.lang.RuntimeException: java.sql.SQLExcepti

Re: using MapReduce java.sql.SQLException: No suitable driver found for jdbc:phoenix occured.

1.1.jar >> ./phoenix-core-4.8.0-HBase-1.1-sources.jar >> >> add phoenix-4.8.0-HBase-1.1-client.jar >> or phoenix-4.8.0-HBase-1.1-hive.jar(I'm not quite sure which one, you >> might try ) to your classpath might solve your problem . >> >> On Tue,

Re: cannot drop a table in Phoenix

try add system tablespace. On Tue, 18 Oct 2016 at 12:41 AM Mich Talebzadeh wrote: > Hi, > > I have a table marketDataHbase create on Hbase as seen below: > > [image: Inline images 1] > > > Trying to drop it but it cannot find it > > 0: jdbc:phoenix:rhes564:2181> drop table "marketDataHbase"; > E

data chaned depending on condition

Hello. I’ve queried data as below. select /*+ NO_INDEX */ * from WINLOSS where DAYNUMBER=?; there are fields of null vaue. after that I retrieve it with primary key again there is no null value. select /*+ NO_INDEX */ * from WINLOSS where DAYNUMBER=? and GPID=? and TYPE=?; what is check point