I have created a view to map to an existing HBase table as following: create view "wanghai:obsweather"(pk VARCHAR primary key,
"d"."stationid" VARCHAR,
"d"."temp" Float,
...); In Hbase shell, my query on a row/column yields the following: hbase(main):004:0> get 'wanghai:obsweather', 'AP611_mesonet|2014-02-01 00:01:30', 'd:temp:toFloat'
COLUMN CELL
d:temp timestamp=1454132157194, value=274.261108398437
1 row(s) in 0.0210 seconds In Phoenix sqlline.py, I got the following: 0: jdbc:phoenix:localhost:2181:/hbase-unsecur> select pk, "d"."stationid", "d"."temp" from "wanghai:obsweather"
. . . . . . . . . . . . . . . . . . . . . . .> where pk='AP611_mesonet|2014-02-01 00:01:30';
'PK','stationid','temp'
'AP611_mesonet|2014-02-01 00:01:30','AP611_mesonet','-0.015067715'
1 row selected (0.11 seconds) Any idea for the same (row, cf:q), why I get "274.2611" from Hbase shell, but "-0.015067715" in Phoenix? What is wrong?
... View more
