[ https://issues.apache.org/jira/browse/PHOENIX-4394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Josh Elser resolved PHOENIX-4394. --------------------------------- Resolution: Duplicate PHOENIX-4395 [~rajat.thakur], please be patient when you are creating new JIRA issues. You created 6 issues for the same problem which creates unnecessary work for us to clean up. Thank you in advance. > ERROR 201 (22000): Illegal data. Expected length of at least 49 bytes, but > had 4 > -------------------------------------------------------------------------------- > > Key: PHOENIX-4394 > URL: https://issues.apache.org/jira/browse/PHOENIX-4394 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.12.0 > Reporter: Rajat Thakur > Priority: Critical > > I am trying to load data from Oracle ExaData to Hbase via Sqoop and then > query via Phoenix. > These kind of errors occur for importing following data Type : > Oracle Exadata PHoenix > Date Date > Timestamp Timestamp > Number(p,s) Decimal(p,s) > Error: ERROR 201 (22000): Illegal data. Expected length of at least 49 bytes, > but had 4 (state=22000,code=201) > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at > least 49 bytes, but had 4 > at > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:422) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) > at > org.apache.phoenix.schema.KeyValueSchema.next(KeyValueSchema.java:211) > at > org.apache.phoenix.expression.ProjectedColumnExpression.evaluate(ProjectedColumnExpression.java:115) > at > org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:69) > at > org.apache.phoenix.jdbc.PhoenixResultSet.getString(PhoenixResultSet.java:608) > at sqlline.Rows$Row.<init>(Rows.java:183) > at sqlline.BufferedRows.<init>(BufferedRows.java:38) > at sqlline.SqlLine.print(SqlLine.java:1650) > at sqlline.Commands.execute(Commands.java:833) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:808) > at sqlline.SqlLine.begin(SqlLine.java:681) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) -- This message was sent by Atlassian JIRA (v6.4.14#64029)