From dev-return-49458-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Thu Feb 15 16:52:04 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 36B2518067B for ; Thu, 15 Feb 2018 16:52:04 +0100 (CET) Received: (qmail 98611 invoked by uid 500); 15 Feb 2018 15:52:03 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 98593 invoked by uid 99); 15 Feb 2018 15:52:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Feb 2018 15:52:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 98D0B1A0975 for ; Thu, 15 Feb 2018 15:52:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -102.311 X-Spam-Level: X-Spam-Status: No, score=-102.311 tagged_above=-999 required=6.31 tests=[RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 1LcNXRUZCZ7d for ; Thu, 15 Feb 2018 15:52:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id E941B5F125 for ; Thu, 15 Feb 2018 15:52:00 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 70785E021F for ; Thu, 15 Feb 2018 15:52:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 2A5D221E5D for ; Thu, 15 Feb 2018 15:52:00 +0000 (UTC) Date: Thu, 15 Feb 2018 15:52:00 +0000 (UTC) From: "Aman Jha (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (PHOENIX-4609) Error Occurs while selecting a specific set of columns MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Aman Jha created PHOENIX-4609: --------------------------------- Summary: Error Occurs while selecting a specific set of column= s 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*_ =C2=A0 Moreover, this error only occurs while running queries via=C2=A0Java Progra= m only and not through the Squirrel SQL client. Is there any other way to a= ccess results from the ResultSet that is returned from Phoenix Client.=C2= =A0 =C2=A0 *Environment Details* :=C2=A0 *HBase Version* : _1.2.6 on Hadoop 2.8.2_ *Phoenix Version* : _4.11.0-HBase-1.2_ *OS*: _LINUX(RHEL)_ =C2=A0 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 h= ad 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.doTransl= ate(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(Pho= enixHBaseDAOImpl.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(SQL= ExceptionCode.java:483) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptio= nInfo.java:150) at org.apache.phoenix.schema.KeyValueSchema.next(KeyValueSchema.java:213) at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:16= 5) at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:17= 1) at org.apache.phoenix.schema.KeyValueSchema.iterator(KeyValueSchema.java:17= 5) at org.apache.phoenix.expression.ProjectedColumnExpression.evaluate(Project= edColumnExpression.java:115) at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(Order= edResultIterator.java:260) at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultItera= tor.java:199) at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(Bas= eGroupedAggregatingResultIterator.java:64) at org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadRe= sultIterator.java:47) at org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultI= terator.java:59) at org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultI= terator.java:65) at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(Bas= eGroupedAggregatingResultIterator.java:64) at org.apache.phoenix.iterate.OrderedResultIterator.getResultIterator(Order= edResultIterator.java:255) at org.apache.phoenix.iterate.OrderedResultIterator.next(OrderedResultItera= tor.java:199) at org.apache.phoenix.iterate.OrderedAggregatingResultIterator.next(Ordered= AggregatingResultIterator.java:51) at org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIte= rator.java:44) at org.apache.phoenix.execute.TupleProjectionPlan$1.next(TupleProjectionPla= n.java:62) at org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadRe= sultIterator.java:47) at org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultI= terator.java:59) at org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultI= terator.java:65) at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(Bas= eGroupedAggregatingResultIterator.java:64) at org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAheadRe= sultIterator.java:47) at org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResultI= terator.java:59) at org.apache.phoenix.iterate.LookAheadResultIterator.next(LookAheadResultI= terator.java:65) at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(Bas= eGroupedAggregatingResultIterator.java:64) at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(Ungro= upedAggregatingResultIterator.java:39) at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:778) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.jav= a:207) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.jav= a:207) ... 16 common frames omitted {code} =C2=A0 Find the attached files for queries for reproducing the bug and the java fi= le used for querying the result. -- This message was sent by Atlassian JIRA (v7.6.3#76005)