Phoenix has a different serialization method than HBase for numericals.
> On Aug 5, 2016, at 08:16, Anupriya Chandran <anupriya...@gmail.com> wrote: > > Also when I tried integer and decimal, it returns some strange values which > was not at all related to the hbase insertions. > > create table "emp" (pk varchar primary key,"cf"."age" varchar , "cf"."bmi" > integer); > select * from "emp"; > +-----+------+--------------+ > | PK | age | bmi | > +-----+------+--------------+ > | 1 | 21 | -1305399758 | > | 2 | 28 | null | > +-----+------+--------------+ > > > create table "emp" (pk varchar primary key,"cf"."age" varchar , "cf"."bmi" > DECIMAL); > select * from "emp"; > +-----+------+---------------+ > | PK | age | bmi | > +-----+------+---------------+ > | 1 | 21 | -5.25551E+25 | > | 2 | 28 | null | > +-----+------+---------------+ > > > > On Fri, Aug 5, 2016 at 5:05 PM, Anupriya Chandran <anupriya...@gmail.com> > wrote: > >> I am using IBM BigInsights Hadoop distribution(Version 4.1) having Hbase >> version 1.1.1. >> My Apache phoenix version is 4.7. I am facing an issue as described below: >> >> I created a Hbase table as below inserted few rows : >> >> create 'emp' , 'cf' >> >> put 'emp' , '1' , 'cf:age' ,'21' >> put 'emp' , '2' , 'cf:age' ,'28' >> put 'emp' , '1' , 'cf:bmi' ,'21.2' >> put 'emp' , '2' , 'cf:bmi' ,'19.9' >> >> Then I created a table in Phoenix >> >> create table "emp" (pk varchar primary key,"cf"."age" varchar , "cf"."bmi" >> DOUBLE); >> >> but querying the table results in below error. If i change DOUBLE data >> type to any other datatype ,it works fine. But I need double. >> >> >> select * from "emp"; >> Error: ERROR 201 (22000): Illegal data. Expected length of at least 8 >> bytes, but had 4 (state=22000,code=201) >> java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of >> at least 8 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.getObject( >> PhoenixResultSet.java:524) >> at sqlline.Rows$Row.<init>(Rows.java:157) >> 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) >> >> Please have a look and help me. >> >> Many thanks in advance. >> >> Anupriya >>
