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 <[email protected]> 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 <[email protected]> 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 >> > >
