[jira] [Updated] (PHOENIX-4609) Error Occurs while selecting a specific set of columns : ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 2
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4609: -- Priority: Blocker (was: Critical) > Error Occurs while selecting a specific set of columns : ERROR 201 (22000): > Illegal data. Expected length of at least 8 bytes, but had 2 > > > Key: PHOENIX-4609 > URL: https://issues.apache.org/jira/browse/PHOENIX-4609 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.11.0, 4.13.0 >Reporter: Aman Jha >Priority: Blocker > Attachments: DML_DDL.sql, SelectStatement.sql, TestPhoenix.java > > > While selecting columns from a table, an error occurs for Illegal Data. > h3. _*ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, > but had 2*_ > The data is read/write only through the Phoenix Client. > Moreover, this error only occurs while running queries via Java Program only > and not through the Squirrel SQL client. Is there any other way to access > results from the ResultSet that is returned from Phoenix Client. > > *Environment Details* : > *HBase Version* : _1.2.6 on Hadoop 2.8.2_ > *Phoenix Version* : _4.11.0-HBase-1.2_ > *OS*: _LINUX(RHEL)_ > > The following error is caused when selecting columns via a Java Program > {code:java} > ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had > 2; nested exception is java.sql.SQLException: ERROR 201 (22000): Illegal > data. Expected length of at least 8 bytes, but had 2 > at > org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) > at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:474) > at > com.zycus.qe.service.impl.PhoenixHBaseDAOImpl.fetchAggregationResult(PhoenixHBaseDAOImpl.java:752) > ... 14 common frames omitted > Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected > length of at least 8 bytes, but had 2 > at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:483) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > at org.apache.phoenix.schema.KeyValueSchema.next(KeyValueSchema.java:213) > at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:165) > at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:171) > at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:175) > at > org.apache.phoenix.expression.ProjectedColumnExpression.evaluate(ProjectedColumnExpression.java:115) > at > org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:260) > at > org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) > at > org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47) > at > org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59) > at > org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultIterator.java:65) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) > at > org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255) > at > org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199) > at > org.apache.phoenix.iterate.OrderedAggregatingResultIterator.next(OrderedAggregatingResultIterator.java:51) > at > org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44) > at > org.apache.phoenix.execute.TupleProjectionPlan$1.next(TupleProjectionPlan.java:62) > at > org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47) > at > org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59) > at > org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultIterator.java:65) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) >
[jira] [Updated] (PHOENIX-4609) Error Occurs while selecting a specific set of columns : ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 2
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4609: -- Summary: Error Occurs while selecting a specific set of columns : ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 2 (was: Error Occurs while selecting a specific set of columns) > Error Occurs while selecting a specific set of columns : ERROR 201 (22000): > Illegal data. Expected length of at least 8 bytes, but had 2 > > > Key: PHOENIX-4609 > URL: https://issues.apache.org/jira/browse/PHOENIX-4609 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.11.0, 4.13.0 >Reporter: Aman Jha >Priority: Critical > Attachments: DML_DDL.sql, SelectStatement.sql, TestPhoenix.java > > > While selecting columns from a table, an error occurs for Illegal Data. > h3. _*ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, > but had 2*_ > The data is read/write only through the Phoenix Client. > Moreover, this error only occurs while running queries via Java Program only > and not through the Squirrel SQL client. Is there any other way to access > results from the ResultSet that is returned from Phoenix Client. > > *Environment Details* : > *HBase Version* : _1.2.6 on Hadoop 2.8.2_ > *Phoenix Version* : _4.11.0-HBase-1.2_ > *OS*: _LINUX(RHEL)_ > > The following error is caused when selecting columns via a Java Program > {code:java} > ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had > 2; nested exception is java.sql.SQLException: ERROR 201 (22000): Illegal > data. Expected length of at least 8 bytes, but had 2 > at > org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) > at > org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) > at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419) > at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:474) > at > com.zycus.qe.service.impl.PhoenixHBaseDAOImpl.fetchAggregationResult(PhoenixHBaseDAOImpl.java:752) > ... 14 common frames omitted > Caused by: java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected > length of at least 8 bytes, but had 2 > at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:483) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > at org.apache.phoenix.schema.KeyValueSchema.next(KeyValueSchema.java:213) > at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:165) > at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:171) > at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:175) > at > org.apache.phoenix.expression.ProjectedColumnExpression.evaluate(ProjectedColumnExpression.java:115) > at > org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:260) > at > org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) > at > org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47) > at > org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59) > at > org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultIterator.java:65) > at > org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) > at > org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(OrderedResultIterator.java:255) > at > org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultIterator.java:199) > at > org.apache.phoenix.iterate.OrderedAggregatingResultIterator.next(OrderedAggregatingResultIterator.java:51) > at > org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44) > at > org.apache.phoenix.execute.TupleProjectionPlan$1.next(TupleProjectionPlan.java:62) > at > org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadResultIterator.java:47) > at > org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultIterator.java:59) > at >