phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: specifying bytes in column name for "CREATE VIEW"
Date Tue, 08 Apr 2014 05:24:38 GMT
Hi,
Putting your column names in double quotes is the only option we have
currently. Can you not represent the value of your column name as a Java
String? What happens if you generate the SQL query using Java to form the
column name (in double quotes)?
Thanks,
James


On Mon, Apr 7, 2014 at 6:11 AM, Jerry Lam <chilinglam@gmail.com> wrote:

> Hi Phoenix,
>
> Should I assume that it is impossible to use Phoenix when column names are
> not in ascii? I think I'm not the only one who will have trouble to use
> Phoenix just because of this. Any thought?
>
> Best Regards,
>
> Jerry
>
>
> On Thu, Apr 3, 2014 at 4:42 PM, Jerry Lam <chilinglam@gmail.com> wrote:
>
>> Hello Phoenix users,
>>
>> I wonder if anyone knows how to specify column name in byte for "CREATE
>> VIEW".
>>
>> I have an existing hbase table in which each  column name is encoded in a
>> single java byte (i.e. values between -128 and 127). How can I create view
>> with column names that map to a byte?
>>
>> I tried the following:
>>
>> create view "my_hbase_table" (id VARCHAR primary key, "f"."01" VARCHAR);
>> create view "my_hbase_table" (id VARCHAR primary key, "f"."\x01"
>> VARCHAR);
>> create view "my_hbase_table" (id VARCHAR primary key, "f"."1" VARCHAR);
>>
>> none of them works. Do you have a solution for this?
>>
>> Best Regards,
>>
>> Jerry
>>
>
>

Mime
View raw message