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 BOOLEAN, contributedAmount BIGINT, payAmount BIGINT CONSTRAINT rowid PRIMARY KEY(dayNumber, type, historyId, seq) ) default_column_family = 'winloss';
insert data through hbase. and I got an error when querying table. just like this. select * from WINLESS; Error: ERROR 201 (22000): Illegal data. Expected length of at least 4 bytes, but had 1 (state=22000,code=201) java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 4 bytes, but had 1 at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:422) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) at org.apache.phoenix.schema.types.PDataType.checkForSufficientLength(PDataType.java:274) at org.apache.phoenix.schema.types.PInteger$IntCodec.decodeInt(PInteger.java:183) at org.apache.phoenix.schema.types.PInteger.toObject(PInteger.java:81) at org.apache.phoenix.schema.types.PInteger.toObject(PInteger.java:28) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:985) at org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:75) at org.apache.phoenix.jdbc.PhoenixResultSet.getObject(PhoenixResultSet.java:524) at sqlline.Rows$Row.<init>(Rows.java:157) at sqlline.BufferedRows.<init>(BufferedRows.java:38) at sqlline.SqlLine.print(SqlLine.java:1650) at sqlline.Commands.execute(Commands.java:833) 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) what shall I do? Thanks.