phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Jha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
Date Thu, 15 Feb 2018 15:52:00 GMT
Aman Jha created PHOENIX-4609:
---------------------------------

             Summary: Error Occurs while selecting a specific set of columns
                 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


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*_

 

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)
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.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39)
at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:778)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
... 16 common frames omitted
{code}
 

Find the attached files for queries for reproducing the bug and the java file used for querying
the result.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message