From user-return-451-apmail-phoenix-user-archive=phoenix.apache.org@phoenix.incubator.apache.org Thu Apr 3 20:42:40 2014 Return-Path: X-Original-To: apmail-phoenix-user-archive@minotaur.apache.org Delivered-To: apmail-phoenix-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4B2C7112AA for ; Thu, 3 Apr 2014 20:42:40 +0000 (UTC) Received: (qmail 18311 invoked by uid 500); 3 Apr 2014 20:42:39 -0000 Delivered-To: apmail-phoenix-user-archive@phoenix.apache.org Received: (qmail 18285 invoked by uid 500); 3 Apr 2014 20:42:39 -0000 Mailing-List: contact user-help@phoenix.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@phoenix.incubator.apache.org Delivered-To: mailing list user@phoenix.incubator.apache.org Received: (qmail 18277 invoked by uid 99); 3 Apr 2014 20:42:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Apr 2014 20:42:38 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of chilinglam@gmail.com designates 209.85.128.177 as permitted sender) Received: from [209.85.128.177] (HELO mail-ve0-f177.google.com) (209.85.128.177) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Apr 2014 20:42:32 +0000 Received: by mail-ve0-f177.google.com with SMTP id sa20so715933veb.36 for ; Thu, 03 Apr 2014 13:42:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=H/c6NbO7uiCJg6StLnQ/7+4WL7+L0oyNu7WWLVRXjpQ=; b=xG3tXq2WEORdYWX7gWbHEleMVEH9OSxAlsQtqbTDRFUxHMw/IdGHwJ6kP9i4jS+vRM 2E3QgW5nuPbocnu6FCRBETbKWoAtLohCToDA6VTBhX/ZPx1YJcDbOye/or3ONOQ4HLkc pW4DodfIOUOdrh4j1pdp4SGBWlSUs/GGXqPNhLsQ0KcN7wX9CBys9ymo1dhOtL9V8QqF ApHFLOLy88cH00/t0AyLuCMFVVVDNYn2uaMf+6/qJfGoFe8Lh6I/gJUkD4XN5eU6kSYg Qlv5/TISWfbZtOaO1ZmjPcJKj9zH+WWjfS6JH/ifyswFalf5Yc3+7r3HTTdrGox9pLtv CO0A== MIME-Version: 1.0 X-Received: by 10.221.29.137 with SMTP id ry9mr4584062vcb.6.1396557730641; Thu, 03 Apr 2014 13:42:10 -0700 (PDT) Received: by 10.221.2.202 with HTTP; Thu, 3 Apr 2014 13:42:10 -0700 (PDT) Date: Thu, 3 Apr 2014 16:42:10 -0400 Message-ID: Subject: specifying bytes in column name for "CREATE VIEW" From: Jerry Lam To: user@phoenix.incubator.apache.org Content-Type: multipart/alternative; boundary=001a1133935c717c6b04f6296fc7 X-Virus-Checked: Checked by ClamAV on apache.org --001a1133935c717c6b04f6296fc7 Content-Type: text/plain; charset=ISO-8859-1 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 --001a1133935c717c6b04f6296fc7 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
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 =A0column= 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:=A0

crea= te view "my_hbase_table" (id VARCHAR primary key, "f".&= quot;01" VARCHAR);
create view "my_hbase_table" (i= d VARCHAR primary key, "f"."\x01" VARCHAR);=A0
create view "my_hbase_table" (id VARCHAR primary key, "= f"."1" VARCHAR);=A0

none of the= m works. Do you have a solution for this?

Best Reg= ards,

Jerry
--001a1133935c717c6b04f6296fc7--