[jira] [Created] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
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
[jira] [Updated] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4609: -- Attachment: SelectStatement.sql > 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 >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*_ > > 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.i
[jira] [Updated] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4609: -- Attachment: DML_DDL.sql > 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 >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*_ > > 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.L
[jira] [Updated] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4609: -- Attachment: TestPhoenix.java > 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 >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*_ > > 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.iter
[jira] [Commented] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16365790#comment-16365790 ] Aman Jha commented on PHOENIX-4609: --- [~jamestaylor] [~samarthjain] is there a workaround for this issue. > 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 >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*_ > > 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.
[jira] [Updated] (PHOENIX-4609) Error Occurs while selecting a specific set of columns
[ https://issues.apache.org/jira/browse/PHOENIX-4609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4609: -- Description: 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) 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}
[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 > org.apache.phoenix.iterate.LookAheadRes
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16373199#comment-16373199 ] Aman Jha commented on PHOENIX-4609: --- [~elserj] are you sure? the stack trace seems different for both the cases. Moreover, I cannot understand how SquirrelSQL client is able to handle the response, but java code for the same cannot? Is there any other way to process Phoenix ResultSet? > 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.LookAheadResul
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16378151#comment-16378151 ] Aman Jha commented on PHOENIX-4609: --- [~ankit.singhal] can you comment on whether this issue is same as -PHOENIX-4588- or any other fix is required? > 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 > org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultIterator.jav
[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) > at
[jira] [Created] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
Aman Jha created PHOENIX-3952: - Summary: "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions Key: PHOENIX-3952 URL: https://issues.apache.org/jira/browse/PHOENIX-3952 Project: Phoenix Issue Type: Bug Affects Versions: 4.8.1 Environment: HBase v-1.2.4 running on CentOS 6.0, Phoenix v-4.8.1, Squirrel v-3.7 running on Windows 10 Reporter: Aman Jha If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} *+TEST CASE : +* Create the following tables : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); Make following entries : upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1', 'L10'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); {code} *+Run the following query : +* {code:java} SELECT * FROM po_test INNER JOIN cbl ON ( ( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) ); {code} *Expected O/P :* {noformat} 1 Devcast C3 B4 L5 C3 * * 3 Jabber C3 B4 L1 C3 * * 4 Yakijo C3 B8 L9 C3 * * 11 DabZC1 B1 L10 C1 B1 * {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-3952: -- Description: If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} +*TEST CASE :*+ Create the following tables : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); {code} Make following entries : {code:java} upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1', 'L10'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); {code} *+Run the following query : +* {code:java} SELECT * FROM po_test INNER JOIN cbl ON ( ( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) ); {code} *Expected O/P :* {noformat} 1 Devcast C3 B4 L5 C3 * * 3 Jabber C3 B4 L1 C3 * * 4 Yakijo C3 B8 L9 C3 * * 11 DabZC1 B1 L10 C1 B1 * {noformat} was: If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} *+TEST CASE : +* Create the following tables : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); Make following entries : upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1', 'L10'); up
[jira] [Updated] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-3952: -- Description: If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} +*TEST CASE :*+ Create the following tables : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); {code} Make following entries : {code:java} upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1', 'L10'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); {code} +*Run the following query :*+ {code:java} SELECT * FROM po_test INNER JOIN cbl ON ( ( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) ); {code} +*Expected O/P :*+ {noformat} 1 Devcast C3 B4 L5 C3 * * 3 Jabber C3 B4 L1 C3 * * 4 Yakijo C3 B8 L9 C3 * * 11 DabZC1 B1 L10 C1 B1 * {noformat} was: If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} +*TEST CASE :*+ Create the following tables : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); {code} Make following entries : {code:java} upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1',
[jira] [Updated] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-3952: -- Description: If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} +*TEST CASE :*+ Create the following tables and entries : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1', 'L10'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); {code} +*Run the following query :*+ {code:java} SELECT * FROM po_test INNER JOIN cbl ON ( ( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) ); {code} +*Expected O/P :*+ {noformat} 1 Devcast C3 B4 L5 C3 * * 3 Jabber C3 B4 L1 C3 * * 4 Yakijo C3 B8 L9 C3 * * 11 DabZC1 B1 L10 C1 B1 * {noformat} was: If I'm joining two tables, say inner join, on an OR based condition, then the following exception is thrown in Squirrel: {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition specified. Consider using table list with where clause. SQLState: 22017 ErrorCode: 217{color} +*TEST CASE :*+ Create the following tables : {code:java} CREATE TABLE IF NOT EXISTS CBL ( COM_CODE VARCHAR NOT NULL , BU_CODE VARCHAR NOT NULL , LOC_CODE VARCHAR NOT NULL CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) ); CREATE TABLE IF NOT EXISTS PO_TEST ( PO_ID VARCHAR PRIMARY KEY, BU_ID VARCHAR , PO_NAME VARCHAR, C_ID VARCHAR, LOC_ID VARCHAR ); {code} Make following entries : {code:java} upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', 'Devcast', 'C3', 'B4', 'L5'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', 'Thought', 'C2', 'B1', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', 'Jabber', 'C3', 'B4', 'L1'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', 'Yakijo', 'C3', 'B8', 'L9'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', 'Youfeed', 'C2', 'B3', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', 'Jayo', 'C2', 'B1', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', 'Trilia', 'C1', 'B10', 'L2'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', 'Podcat', 'C1', 'B3', 'L10'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', 'Twitter', 'C1', 'B5', 'L8'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', 'DabZ', 'C1', 'B8', 'L4'); upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', 'DabZ', 'C1', 'B1', 'L10'); upsert into CBL (COM_CODE,B
[jira] [Commented] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16051996#comment-16051996 ] Aman Jha commented on PHOENIX-3952: --- [~jamestaylor] Could you kindly suggest some workaround for this, till the issue is fixed. > "Ambiguous or non-equi join condition specified" Exception thrown for usage > of OR expression in join conditions > > > Key: PHOENIX-3952 > URL: https://issues.apache.org/jira/browse/PHOENIX-3952 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.1 > Environment: HBase v-1.2.4 running on CentOS 6.0, Phoenix v-4.8.1, > Squirrel v-3.7 running on Windows 10 >Reporter: Aman Jha > > If I'm joining two tables, say inner join, on an OR based condition, then the > following exception is thrown in Squirrel: > {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition > specified. Consider using table list with where clause. > SQLState: 22017 > ErrorCode: 217{color} > +*TEST CASE :*+ > Create the following tables and entries : > {code:java} > CREATE TABLE IF NOT EXISTS CBL > ( > COM_CODE VARCHAR NOT NULL , > BU_CODE VARCHAR NOT NULL , > LOC_CODE VARCHAR NOT NULL > CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) > ); > CREATE TABLE IF NOT EXISTS PO_TEST > ( >PO_ID VARCHAR PRIMARY KEY, >BU_ID VARCHAR , >PO_NAME VARCHAR, >C_ID VARCHAR, >LOC_ID VARCHAR > ); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', > 'Devcast', 'C3', 'B4', 'L5'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', > 'Thought', 'C2', 'B1', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', > 'Jabber', 'C3', 'B4', 'L1'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', > 'Yakijo', 'C3', 'B8', 'L9'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', > 'Youfeed', 'C2', 'B3', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', > 'Jayo', 'C2', 'B1', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', > 'Trilia', 'C1', 'B10', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', > 'Podcat', 'C1', 'B3', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', > 'Twitter', 'C1', 'B5', 'L8'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', > 'DabZ', 'C1', 'B8', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', > 'DabZ', 'C1', 'B1', 'L10'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); > {code} > +*Run the following query :*+ > {code:java} > SELECT * FROM po_test INNER JOIN cbl ON > ( >( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) >AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) >AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) > ); > {code} > +*Expected O/P :*+ > {noformat} > 1 Devcast C3 B4 L5 C3 * * > 3 Jabber C3 B4 L1 C3 * * > 4 Yakijo C3 B8 L9 C3 * * > 11DabZC1 B1 L10 C1 B1 * > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16052072#comment-16052072 ] Aman Jha commented on PHOENIX-3952: --- [~jamestaylor] still getting the same error using the suggested solution > "Ambiguous or non-equi join condition specified" Exception thrown for usage > of OR expression in join conditions > > > Key: PHOENIX-3952 > URL: https://issues.apache.org/jira/browse/PHOENIX-3952 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.1 > Environment: HBase v-1.2.4 running on CentOS 6.0, Phoenix v-4.8.1, > Squirrel v-3.7 running on Windows 10 >Reporter: Aman Jha > > If I'm joining two tables, say inner join, on an OR based condition, then the > following exception is thrown in Squirrel: > {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition > specified. Consider using table list with where clause. > SQLState: 22017 > ErrorCode: 217{color} > +*TEST CASE :*+ > Create the following tables and entries : > {code:java} > CREATE TABLE IF NOT EXISTS CBL > ( > COM_CODE VARCHAR NOT NULL , > BU_CODE VARCHAR NOT NULL , > LOC_CODE VARCHAR NOT NULL > CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) > ); > CREATE TABLE IF NOT EXISTS PO_TEST > ( >PO_ID VARCHAR PRIMARY KEY, >BU_ID VARCHAR , >PO_NAME VARCHAR, >C_ID VARCHAR, >LOC_ID VARCHAR > ); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', > 'Devcast', 'C3', 'B4', 'L5'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', > 'Thought', 'C2', 'B1', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', > 'Jabber', 'C3', 'B4', 'L1'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', > 'Yakijo', 'C3', 'B8', 'L9'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', > 'Youfeed', 'C2', 'B3', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', > 'Jayo', 'C2', 'B1', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', > 'Trilia', 'C1', 'B10', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', > 'Podcat', 'C1', 'B3', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', > 'Twitter', 'C1', 'B5', 'L8'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', > 'DabZ', 'C1', 'B8', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', > 'DabZ', 'C1', 'B1', 'L10'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); > {code} > +*Run the following query :*+ > {code:java} > SELECT * FROM po_test INNER JOIN cbl ON > ( >( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) >AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) >AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) > ); > {code} > +*Expected O/P :*+ > {noformat} > 1 Devcast C3 B4 L5 C3 * * > 3 Jabber C3 B4 L1 C3 * * > 4 Yakijo C3 B8 L9 C3 * * > 11DabZC1 B1 L10 C1 B1 * > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Comment Edited] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16052072#comment-16052072 ] Aman Jha edited comment on PHOENIX-3952 at 6/16/17 4:12 PM: [~jamestaylor] Still getting the same error using the suggested solution. Is there any thing else I can trying out? was (Author: aman@zycus.com): [~jamestaylor] still getting the same error using the suggested solution > "Ambiguous or non-equi join condition specified" Exception thrown for usage > of OR expression in join conditions > > > Key: PHOENIX-3952 > URL: https://issues.apache.org/jira/browse/PHOENIX-3952 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.1 > Environment: HBase v-1.2.4 running on CentOS 6.0, Phoenix v-4.8.1, > Squirrel v-3.7 running on Windows 10 >Reporter: Aman Jha > > If I'm joining two tables, say inner join, on an OR based condition, then the > following exception is thrown in Squirrel: > {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition > specified. Consider using table list with where clause. > SQLState: 22017 > ErrorCode: 217{color} > +*TEST CASE :*+ > Create the following tables and entries : > {code:java} > CREATE TABLE IF NOT EXISTS CBL > ( > COM_CODE VARCHAR NOT NULL , > BU_CODE VARCHAR NOT NULL , > LOC_CODE VARCHAR NOT NULL > CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) > ); > CREATE TABLE IF NOT EXISTS PO_TEST > ( >PO_ID VARCHAR PRIMARY KEY, >BU_ID VARCHAR , >PO_NAME VARCHAR, >C_ID VARCHAR, >LOC_ID VARCHAR > ); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', > 'Devcast', 'C3', 'B4', 'L5'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', > 'Thought', 'C2', 'B1', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', > 'Jabber', 'C3', 'B4', 'L1'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', > 'Yakijo', 'C3', 'B8', 'L9'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', > 'Youfeed', 'C2', 'B3', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', > 'Jayo', 'C2', 'B1', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', > 'Trilia', 'C1', 'B10', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', > 'Podcat', 'C1', 'B3', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', > 'Twitter', 'C1', 'B5', 'L8'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', > 'DabZ', 'C1', 'B8', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', > 'DabZ', 'C1', 'B1', 'L10'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); > {code} > +*Run the following query :*+ > {code:java} > SELECT * FROM po_test INNER JOIN cbl ON > ( >( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) >AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) >AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) > ); > {code} > +*Expected O/P :*+ > {noformat} > 1 Devcast C3 B4 L5 C3 * * > 3 Jabber C3 B4 L1 C3 * * > 4 Yakijo C3 B8 L9 C3 * * > 11DabZC1 B1 L10 C1 B1 * > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Comment Edited] (PHOENIX-3952) "Ambiguous or non-equi join condition specified" Exception thrown for usage of OR expression in join conditions
[ https://issues.apache.org/jira/browse/PHOENIX-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16052072#comment-16052072 ] Aman Jha edited comment on PHOENIX-3952 at 6/16/17 4:12 PM: [~jamestaylor] Still getting the same error using the suggested solution. Is there any thing else I can try out? was (Author: aman@zycus.com): [~jamestaylor] Still getting the same error using the suggested solution. Is there any thing else I can trying out? > "Ambiguous or non-equi join condition specified" Exception thrown for usage > of OR expression in join conditions > > > Key: PHOENIX-3952 > URL: https://issues.apache.org/jira/browse/PHOENIX-3952 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.1 > Environment: HBase v-1.2.4 running on CentOS 6.0, Phoenix v-4.8.1, > Squirrel v-3.7 running on Windows 10 >Reporter: Aman Jha > > If I'm joining two tables, say inner join, on an OR based condition, then the > following exception is thrown in Squirrel: > {color:red}Error: ERROR 217 (22017): Ambiguous or non-equi join condition > specified. Consider using table list with where clause. > SQLState: 22017 > ErrorCode: 217{color} > +*TEST CASE :*+ > Create the following tables and entries : > {code:java} > CREATE TABLE IF NOT EXISTS CBL > ( > COM_CODE VARCHAR NOT NULL , > BU_CODE VARCHAR NOT NULL , > LOC_CODE VARCHAR NOT NULL > CONSTRAINT PK_CBL PRIMARY KEY (COM_CODE, BU_CODE, LOC_CODE) > ); > CREATE TABLE IF NOT EXISTS PO_TEST > ( >PO_ID VARCHAR PRIMARY KEY, >BU_ID VARCHAR , >PO_NAME VARCHAR, >C_ID VARCHAR, >LOC_ID VARCHAR > ); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('1', > 'Devcast', 'C3', 'B4', 'L5'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('2', > 'Thought', 'C2', 'B1', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('3', > 'Jabber', 'C3', 'B4', 'L1'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('4', > 'Yakijo', 'C3', 'B8', 'L9'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('5', > 'Youfeed', 'C2', 'B3', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('6', > 'Jayo', 'C2', 'B1', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('7', > 'Trilia', 'C1', 'B10', 'L2'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('8', > 'Podcat', 'C1', 'B3', 'L10'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('9', > 'Twitter', 'C1', 'B5', 'L8'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('10', > 'DabZ', 'C1', 'B8', 'L4'); > upsert into PO_TEST (PO_ID, PO_NAME, C_ID, BU_ID, LOC_ID) values ('11', > 'DabZ', 'C1', 'B1', 'L10'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B1','*'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B2','L2'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L3'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C1','B3','L5'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C2','*','L1'); > upsert into CBL (COM_CODE,BU_CODE,LOC_CODE) values ('C3','*','*'); > {code} > +*Run the following query :*+ > {code:java} > SELECT * FROM po_test INNER JOIN cbl ON > ( >( cbl.com_code = '*' OR cbl.com_code = po_test.c_id ) >AND ( cbl.bu_code = '*' OR cbl.bu_code = po_test.bu_id ) >AND ( cbl.loc_code = '*' OR cbl.loc_code = po_test.loc_id ) > ); > {code} > +*Expected O/P :*+ > {noformat} > 1 Devcast C3 B4 L5 C3 * * > 3 Jabber C3 B4 L1 C3 * * > 4 Yakijo C3 B8 L9 C3 * * > 11DabZC1 B1 L10 C1 B1 * > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Created] (PHOENIX-4043) NumberFormatException on adding expressions containing division by zeros
Aman Jha created PHOENIX-4043: - Summary: NumberFormatException on adding expressions containing division by zeros Key: PHOENIX-4043 URL: https://issues.apache.org/jira/browse/PHOENIX-4043 Project: Phoenix Issue Type: Bug Affects Versions: 4.8.1 Environment: OS : Linux (Server) , Windows(SquirrelSQL Client) Hbase: 1.2.4 Reporter: Aman Jha When two columns containing zero values are divided and added to another expression, number format exception is raised on server and the client shows no error(times out after a certain interval) The following stack trace is generated on server : {code:java} java.lang.NumberFormatException at java.math.BigDecimal.(BigDecimal.java:494) at java.math.BigDecimal.(BigDecimal.java:383) at java.math.BigDecimal.(BigDecimal.java:806) at java.math.BigDecimal.valueOf(BigDecimal.java:1274) at org.apache.phoenix.schema.types.PDecimal.toObject(PDecimal.java:139) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:991) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1003) at org.apache.phoenix.expression.DecimalAddExpression.evaluate(DecimalAddExpression.java:65) at org.apache.phoenix.expression.DecimalSubtractExpression.evaluate(DecimalSubtractExpression.java:64) at org.apache.phoenix.expression.aggregator.ServerAggregators.aggregate(ServerAggregators.java:59) at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:618) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:214) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:259) at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133) at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108) at java.lang.Thread.run(Thread.java:745) {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (PHOENIX-4043) NumberFormatException on adding expressions containing division by zeros
[ https://issues.apache.org/jira/browse/PHOENIX-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4043: -- Description: When two columns containing zero values are divided and added to another expression, number format exception is raised on server and the client shows no error(times out after a certain interval) The following stack trace is generated on server : {code:java} java.lang.NumberFormatException at java.math.BigDecimal.(BigDecimal.java:494) at java.math.BigDecimal.(BigDecimal.java:383) at java.math.BigDecimal.(BigDecimal.java:806) at java.math.BigDecimal.valueOf(BigDecimal.java:1274) at org.apache.phoenix.schema.types.PDecimal.toObject(PDecimal.java:139) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:991) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1003) at org.apache.phoenix.expression.DecimalAddExpression.evaluate(DecimalAddExpression.java:65) at org.apache.phoenix.expression.DecimalSubtractExpression.evaluate(DecimalSubtractExpression.java:64) at org.apache.phoenix.expression.aggregator.ServerAggregators.aggregate(ServerAggregators.java:59) at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:618) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:214) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:259) at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133) at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108) at java.lang.Thread.run(Thread.java:745) {code} The error occurs due to conversion of Double.NaN to BigDecimal was: When two columns containing zero values are divided and added to another expression, number format exception is raised on server and the client shows no error(times out after a certain interval) The following stack trace is generated on server : {code:java} java.lang.NumberFormatException at java.math.BigDecimal.(BigDecimal.java:494) at java.math.BigDecimal.(BigDecimal.java:383) at java.math.BigDecimal.(BigDecimal.java:806) at java.math.BigDecimal.valueOf(BigDecimal.java:1274) at org.apache.phoenix.schema.types.PDecimal.toObject(PDecimal.java:139) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:991) at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1003) at org.apache.phoenix.expression.DecimalAddExpression.evaluate(DecimalAddExpression.java:65) at org.apache.phoenix.expression.DecimalSubtractExpression.evaluate(DecimalSubtractExpression.java:64) at org.apache.phoenix.expression.aggregator.ServerAggregators.aggregate(ServerAggregators.java:59) at org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:618) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:214) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:259) at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133) at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108) at java.lang.Thread.run(Thread.java:745) {code} > NumberFormatException on adding expressions containing division by zeros > > > Key: PHOENIX-4043 > URL: https://issues.apache.org/jira/browse/PHOENIX-4043 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.8.1 > Environment: OS : Linux (Server) , Windows(SquirrelSQL Client) > Hbase: 1.2.4 >Reporter: Aman Jha > > When two columns containing zero values are divided a
[jira] [Updated] (PHOENIX-4043) NumberFormatException on adding expressions containing division by zeros
[ https://issues.apache.org/jira/browse/PHOENIX-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Jha updated PHOENIX-4043: -- Affects Version/s: 4.9.0 4.10.0 4.11.0 > NumberFormatException on adding expressions containing division by zeros > > > Key: PHOENIX-4043 > URL: https://issues.apache.org/jira/browse/PHOENIX-4043 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.9.0, 4.8.1, 4.10.0, 4.11.0 > Environment: OS : Linux (Server) , Windows(SquirrelSQL Client) > Hbase: 1.2.4 >Reporter: Aman Jha > > When two columns containing zero values are divided and added to another > expression, number format exception is raised on server and the client shows > no error(times out after a certain interval) > The following stack trace is generated on server : > {code:java} > java.lang.NumberFormatException > at java.math.BigDecimal.(BigDecimal.java:494) > at java.math.BigDecimal.(BigDecimal.java:383) > at java.math.BigDecimal.(BigDecimal.java:806) > at java.math.BigDecimal.valueOf(BigDecimal.java:1274) > at > org.apache.phoenix.schema.types.PDecimal.toObject(PDecimal.java:139) > at > org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:991) > at > org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1003) > at > org.apache.phoenix.expression.DecimalAddExpression.evaluate(DecimalAddExpression.java:65) > at > org.apache.phoenix.expression.DecimalSubtractExpression.evaluate(DecimalSubtractExpression.java:64) > at > org.apache.phoenix.expression.aggregator.ServerAggregators.aggregate(ServerAggregators.java:59) > at > org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:618) > at > org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:214) > at > org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:259) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563) > at > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at > org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108) > at java.lang.Thread.run(Thread.java:745) > {code} > The error occurs due to conversion of Double.NaN to BigDecimal -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (PHOENIX-4043) NumberFormatException on adding expressions containing division by zeros
[ https://issues.apache.org/jira/browse/PHOENIX-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16094513#comment-16094513 ] Aman Jha commented on PHOENIX-4043: --- [~samarthjain] is any work-around available for this scenario? > NumberFormatException on adding expressions containing division by zeros > > > Key: PHOENIX-4043 > URL: https://issues.apache.org/jira/browse/PHOENIX-4043 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.9.0, 4.8.1, 4.10.0, 4.11.0 > Environment: OS : Linux (Server) , Windows(SquirrelSQL Client) > Hbase: 1.2.4 >Reporter: Aman Jha > > When two columns containing zero values are divided and added to another > expression, number format exception is raised on server and the client shows > no error(times out after a certain interval) > The following stack trace is generated on server : > {code:java} > java.lang.NumberFormatException > at java.math.BigDecimal.(BigDecimal.java:494) > at java.math.BigDecimal.(BigDecimal.java:383) > at java.math.BigDecimal.(BigDecimal.java:806) > at java.math.BigDecimal.valueOf(BigDecimal.java:1274) > at > org.apache.phoenix.schema.types.PDecimal.toObject(PDecimal.java:139) > at > org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:991) > at > org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1003) > at > org.apache.phoenix.expression.DecimalAddExpression.evaluate(DecimalAddExpression.java:65) > at > org.apache.phoenix.expression.DecimalSubtractExpression.evaluate(DecimalSubtractExpression.java:64) > at > org.apache.phoenix.expression.aggregator.ServerAggregators.aggregate(ServerAggregators.java:59) > at > org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:618) > at > org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:214) > at > org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:259) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563) > at > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at > org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108) > at java.lang.Thread.run(Thread.java:745) > {code} > The error occurs due to conversion of Double.NaN to BigDecimal -- This message was sent by Atlassian JIRA (v6.4.14#64029)