hadoop - Phoenix view not reading HBase numerical values properly -



hadoop - Phoenix view not reading HBase numerical values properly -

my hbase table has columns containing bigint. bigints declared hive, has used hive generate hbase's hfiles mass loading.

from hbase shell can print row , see appropriate integer value :

... 00000020-079e-4e9f-800b-e71937a78b5d column=cf:p_le_id, timestamp=1428571993408, value=1395243843 ...

from phoenix select row , see negative value.

select "p_le_id" "bulk_1month" uuid = '00000020-079e-4e9f-800b-e71937a78b5d';

i tried several types declaring column in phoenix. none of them matched hbase value :

-- bigint : -5678131804545731784 -- unsigned int : 825440565 -- unsigned long : 3545240232309044024 -- unsigned_float : 2.6080447e-9 -- integer : -1.322.043.083

one interesting point : hbase value 1,395,243,843. phoenix type showing "more similar" value integer.

thanks in advance suggestions!

i noticed can read appropriate value when using varchar type numerical column.

it weird source declared of type bigint hive side.

hadoop hbase phoenix

Comments

Popular posts from this blog

java - How to set log4j.defaultInitOverride property to false in jboss server 6 -

c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable -

Using ajax with sonata admin list view pagination -