Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 0151519CA0 for ; Sat, 9 Apr 2016 09:51:57 +0000 (UTC) Received: (qmail 61843 invoked by uid 500); 9 Apr 2016 09:51:55 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 61777 invoked by uid 500); 9 Apr 2016 09:51:55 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 61764 invoked by uid 99); 9 Apr 2016 09:51:55 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Apr 2016 09:51:55 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id A3216C023C for ; Sat, 9 Apr 2016 09:51:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id g-UVt5Iseg1k for ; Sat, 9 Apr 2016 09:51:53 +0000 (UTC) Received: from mail-yw0-f181.google.com (mail-yw0-f181.google.com [209.85.161.181]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id C52FF5F231 for ; Sat, 9 Apr 2016 09:51:52 +0000 (UTC) Received: by mail-yw0-f181.google.com with SMTP id o66so69326301ywc.3 for ; Sat, 09 Apr 2016 02:51:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=b1ynz0AFxL3XcPNywh5tKnHZLvXH7KmMXM3x+hOuPaI=; b=nLdtGQoopitLn3XewzO6kufud6X5svzrM6VZ8ejzh62bfOb5v7bNJYjUdrhtWdTYK3 LVxuBR9OdPIrrZSQBpcDxRWAsZz2fm4bxfmeFgN3iQGHbVOCtIsXwv9uDdlJntf5g7BK FM6RKyZWjsy85KIbdLd9b3PLtsimZo0atafixrkA1sOLhf6RfMPeZLBgZkCLpvoywSOf aJFfdoSqAa61xv8SvYDfDaoGI2zqItASxgkRDcqHHNMRPyxO2S28VPv1lvNSB3GrLbVQ XDFKbgOXohzkLXv/hOtV8VTAj+3QEyu4qGAFCHM2sgEnH6a7VPga89v7FpNeby725IA8 DwLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=b1ynz0AFxL3XcPNywh5tKnHZLvXH7KmMXM3x+hOuPaI=; b=cUjaLC4F6McbMYwtDLeL38IA28uL+nXBvJTR2gzsLqeebEWFUIv4kqgsapJbHenhnq nDjTLGO32YxlsnAG2yxTK4hwd2s/e3XC7QAe70z89F+2hlRMPfPZNzhbMUCOEe4pGJ+Q mmfuGwtoIozSUAxbtqwmz4LVVj+NKPk8q9V25JwqDjnD5OeGzD376ADSLbc8u+mMfUH8 GFsBnikqLST90MsOp5Rwk8vvSJilI8w62WcDzfT1V8fmk5LItAFjOhjTkHzpzLfMYb34 rCl3PmVBNYT8D/dXCJtpSqxRzQN4DpWxR0356IBu21anxuHCBVUrMM33Kgm8ou14cDwZ EXfw== X-Gm-Message-State: AD7BkJIoyL6r2rWx/FpTxva85SCBcojbLy6COodCptrWo34uDgZFRPUHcxHBedVmY9L31s+2S5sgu3vcUrhG1Q== MIME-Version: 1.0 X-Received: by 10.129.44.139 with SMTP id s133mr6481752yws.182.1460195511896; Sat, 09 Apr 2016 02:51:51 -0700 (PDT) Received: by 10.37.214.212 with HTTP; Sat, 9 Apr 2016 02:51:51 -0700 (PDT) In-Reply-To: References: Date: Sat, 9 Apr 2016 02:51:51 -0700 Message-ID: Subject: Re: Column qualifier name in byte array in hbase From: Ted Yu To: Viswanathan J Cc: "user@hbase.apache.org" Content-Type: multipart/alternative; boundary=001a1141e82aca126805300a4278 --001a1141e82aca126805300a4278 Content-Type: text/plain; charset=UTF-8 I guess you have read: https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration#HBaseIntegration-HiveMAPtoHBaseColumnFamily where example for column family mapping is given. If you need to map column qualifier, probably poll hive mailing list on syntax. FYI On Sat, Apr 9, 2016 at 12:30 AM, Viswanathan J wrote: > Hi, > > I'm trying to create external hive table to map hbase table and i'm facing > issue in the column mapping because the column qualifier is in byte array > as below, how to define/map this. > > eg., > > column=cf:\x00\x00\x00\x00\x00\x00\x00\x00, timestamp=1455990558044 > > -- > Regards, > Viswa.J > --001a1141e82aca126805300a4278--