Skip to content
This repository has been archived by the owner on Feb 12, 2022. It is now read-only.

phoenix map hbase table , phoenix data content is not correct #735

Open
yanbit opened this issue Sep 17, 2014 · 1 comment
Open

phoenix map hbase table , phoenix data content is not correct #735

yanbit opened this issue Sep 17, 2014 · 1 comment

Comments

@yanbit
Copy link

yanbit commented Sep 17, 2014

Hi all

I used phoenix-4.0,hbase-0.96

I import data bulkload way to hbase, and then mapped by phoenix hbase table , if the data type is varchar data content can correct reality , if the data type is DOUBLE, LONG, INTEGER ( data content is assumed to be : 20091020 )

0: jdbc:phoenix:localhost> select * from client_demo limit 5;
1| 201305101111 | 11111 | 11111 | -1305464525 | -1342177280 | 0 | -1305464525 | -1271712972
2|....
3|....
4|....
Fifth row data error
java.lang.IllegalArgumentException: offset (192498) + length (8) exceed the capacity of the array: 192504
at org.apache.hadoop.hbase.util.Bytes.explainWrongLengthOrOffset(Bytes.java:600)
at org.apache.hadoop.hbase.util.Bytes.toLong(Bytes.java:578)
at org.apache.hadoop.hbase.util.Bytes.toLong(Bytes.java:563)
at org.apache.phoenix.schema.PDataType$DoubleCodec.decodeDouble(PDataType.java:6280)
at org.apache.phoenix.schema.PDataType$8.toObject(PDataType.java:1193)
at org.apache.phoenix.schema.PDataType$8.toObject(PDataType.java:1069)
at org.apache.phoenix.schema.PDataType.toObject(PDataType.java:6864)
at org.apache.phoenix.compile.ExpressionProjector.getValue(ExpressionProjector.java:75)
at org.apache.phoenix.jdbc.PhoenixResultSet.getObject(PhoenixResultSet.java:482)
at sqlline.SqlLine$Rows$Row.(SqlLine.java:2314)
at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2430)
at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074)
at sqlline.SqlLine.print(SqlLine.java:1735)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3683)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
at sqlline.SqlLine.dispatch(SqlLine.java:821)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)

Abnormal data
-1305464525 | -1342177280
Normal data
20130502 | 0

@jtaylor-sfdc
Copy link
Contributor

Phoenix moved to Apache about a year ago. Please repost your question on
our mailing list here: http://phoenix.apache.org/mailing_list.html

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants