phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 金砖 <jinzh...@wacai.com>
Subject Re: problems about using phoenix over hbase
Date Wed, 20 Apr 2016 06:32:50 GMT
Got it!

Thanks !

在 2016年04月20日 14:20, Ankit Singhal 写道:
> 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 
> <mailto:jinzhuan@wacai.com>> wrote:
>
>     thanks for your reply rafa!
>
>     It works. Now the value isn't null,  but is -1322110156
>     <tel: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
>>     <mailto: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