thanks for your reply rafa!
It works. Now the value isn't null, but is -1322110156.
But when using this : create view if not exists "test" (pk VARCHAR
primary key, "family"."number" UNSIGNED_INT);
value of number is 825373492.
value is right only when I use this: create view if not exists "test"
(pk VARCHAR primary key, "family"."number" varche nar);
Does this mean I could only use varchar? I'm totally confused.
在 2016年04月19日 20:17, rafa 写道:
Hi,
test with:
create view if not exists "test" (pk VARCHAR primary key,
"family"."number" INTEGER);
regards,
rafa
On Tue, Apr 19, 2016 at 12:58 PM, 金砖 <[email protected]
<mailto:[email protected]>> wrote:
I'm new to phoenix
using phoenix-4.7.0-HBase-1.1 on hbase-1.1.3
my steps:
1. create hbase table
create 'test', 'family'
2. put row in hbase table
put 'test', 'row1', 'family:number', '123456'
3. create view in phoenix
create view if not exists "test" (pk VARCHAR primary key,
"family".number INTEGER);
4. select phoenix view
select NUMBER from "test";
But why result is null ? Is there anything wrong about the steps ?
