phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: problems about using phoenix over hbase
Date Wed, 20 Apr 2016 06:20:13 GMT
Hi,

I think when you are doing a put from shel then value is going as String
not as Integer. So phoenix can decode it with varchar only .
If you want to put Integer to your hbase table , use byte representation of
integer or java api instead.

Regards,
Ankit Singhal

On Wed, Apr 20, 2016 at 8:00 AM, 金砖 <jinzhuan@wacai.com> wrote:

> 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, 金砖 <jinzhuan@wacai.com> 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 ?
>>
>
>
>

Mime
View raw message