Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EA07411CA1 for ; Thu, 14 Aug 2014 04:21:42 +0000 (UTC) Received: (qmail 37283 invoked by uid 500); 14 Aug 2014 04:21:41 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 37208 invoked by uid 500); 14 Aug 2014 04:21:41 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 37195 invoked by uid 99); 14 Aug 2014 04:21:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Aug 2014 04:21:41 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of felixwams@outlook.com designates 65.54.190.154 as permitted sender) Received: from [65.54.190.154] (HELO BAY004-OMC3S16.hotmail.com) (65.54.190.154) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Aug 2014 04:21:34 +0000 Received: from BAY405-EAS21 ([65.54.190.188]) by BAY004-OMC3S16.hotmail.com with Microsoft SMTPSVC(7.5.7601.22712); Wed, 13 Aug 2014 21:21:14 -0700 X-TMN: [EWDe+Ra0JxOuIqgiFfBinz4ICmEXnC0i] X-Originating-Email: [felixwams@outlook.com] Message-ID: From: Felix Wang To: Subject: Supported character set of hbase.columns.mapping? Date: Thu, 14 Aug 2014 12:21:12 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002B_01CFB7BA.3C9520C0" X-Mailer: Microsoft Outlook 16.0 Thread-Index: Ac+3dimfIhFB4XtaQbi9hGaz73Zm+g== Content-Language: en-us X-OriginalArrivalTime: 14 Aug 2014 04:21:14.0123 (UTC) FILETIME=[2F65DDB0:01CFB777] X-Virus-Checked: Checked by ClamAV on apache.org ------=_NextPart_000_002B_01CFB7BA.3C9520C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, We want to create Hive EXTERNAL TABLE to map to HBase tables. Our questions is, what kind of character set "hbase.columns.mapping" can support? For example, for below clause. CREATE EXTERNAL TABLE SomeTable (Default_Key STRING, `Hive Column Name` STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = "HBase Column Name") TBLPROPERTIES("hbase.table.name" = "SomeHBaseTable"); What kind of character set of "HBase Column Name" can support? Especially, seems like when there are COLON (:) or COMMA (,) it does not work. Is there any workaround (like, how to escape them) in these cases? Thanks, -Felix ------=_NextPart_000_002B_01CFB7BA.3C9520C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

We want to = create Hive EXTERNAL TABLE to map to HBase tables.

Our questions is, what kind of character set = “hbase.columns.mapping” can support?

 

For = example,  for below clause…

 

CREATE EXTERNAL TABLE SomeTable = (Default_Key STRING, `Hive = Column Name` STRING) STORED BY = 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES = ("hbase.columns.mapping" =3D "HBase Column = Name") = TBLPROPERTIES("hbase.table.name" =3D = "SomeHBaseTable");

 

What kind of = character set of “HBase Column Name” can support? =

Especially, seems like when there = are COLON (:) or COMMA (,)  it does not work. Is = there any workaround (like, how to escape them) in these = cases?

 

Thanks,

-Felix

------=_NextPart_000_002B_01CFB7BA.3C9520C0--