but based on the datatype I get a different answer for the same query.
I have a table in hbase
get 'beta_accounts_created', '20130425020340|000000564259|
COLUMN
d:balance
I go to phoenix and create the following view
CREATE VIEW "beta_accounts_created" (
pk VARCHAR PRIMARY KEY
, "d"."balance" DOUBLE
);
The query is straight foward
select "d"."balance" from "beta_accounts_created" where pk = '20130425020340|000000564259|
-4.3912361131335697E71
then I recreate the view with a different number datatype
CREATE VIEW "beta_accounts_created" (
pk VARCHAR PRIMARY KEY
, "d"."balance" BIGINT
);
select "d"."balance" from "beta_accounts_created" where pk = '20130425020340|000000564259|
-5678986353556037888
then I recreate the view with as a VARCHAR datatype and then I get the right answer
CREATE VIEW "beta_accounts_created" (
pk VARCHAR PRIMARY KEY
, "d"."balance" VARCHAR
);
100
Is this known behavior?
hbase 0.98.6
phoenix 4.2.2
sqlline 1.2.2
댓글 없음:
댓글 쓰기