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 87F9CDBF6 for ; Thu, 4 Oct 2012 18:33:06 +0000 (UTC) Received: (qmail 10972 invoked by uid 500); 4 Oct 2012 18:33:05 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 10838 invoked by uid 500); 4 Oct 2012 18:33:05 -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 10828 invoked by uid 99); 4 Oct 2012 18:33:05 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Oct 2012 18:33:05 +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 yuzhihong@gmail.com designates 209.85.212.182 as permitted sender) Received: from [209.85.212.182] (HELO mail-wi0-f182.google.com) (209.85.212.182) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Oct 2012 18:32:59 +0000 Received: by mail-wi0-f182.google.com with SMTP id hm2so883776wib.5 for ; Thu, 04 Oct 2012 11:32:38 -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 :content-type; bh=GTGXu7Jkhesmw8UYnCRctcunUVRIMXyZbZncs/G7kNg=; b=KCAyaFcfpa6E4b04r92wZU9Kj0ZFK8YS7weuWHJpu4U8tPGNNa6DQD6fFA4TtTh/1E b56z4iKDzLpVIgzMP4uzZjMk5plaWihaEa5EioGJc9jv5aFfPO1fQcHn+q60oLkTBWP2 a5/aI2yFYKOwJ43blTYJ3fb3xwrnCRZOCO/DLdUjJW7vASWwYFErIdVvceF45DSJZ9Nz UMMgqBx9qMhxNbjDADY6r7Lq8iNfe1pX9Jo0mNiP0GLMEoqBVyxlUNXBtKlimKZG3ECl 5Nz41lMnzw7+5aTIEv/h4GsfZxKiSeYvQKPHkyb/1QSCMwsQJN08Hl1OC5tcmD09DkPl fWNA== MIME-Version: 1.0 Received: by 10.216.201.80 with SMTP id a58mr3894885weo.15.1349375557639; Thu, 04 Oct 2012 11:32:37 -0700 (PDT) Received: by 10.216.245.79 with HTTP; Thu, 4 Oct 2012 11:32:37 -0700 (PDT) In-Reply-To: <8CF707565A97C67-FB0-8165@webmail-m047.sysops.aol.com> References: <8CF707565A97C67-FB0-8165@webmail-m047.sysops.aol.com> Date: Thu, 4 Oct 2012 11:32:37 -0700 Message-ID: Subject: Re: no data in external table From: Ted Yu To: user@hive.apache.org Content-Type: multipart/alternative; boundary=0016e6db7bc7c81e5b04cb3ffa9a --0016e6db7bc7c81e5b04cb3ffa9a Content-Type: text/plain; charset=ISO-8859-1 Can you tell us how you created mapping for the existing table ? In task log, do you see any connection attempt to HBase ? Cheers On Thu, Oct 4, 2012 at 11:30 AM, wrote: > Hello, > > I use hive-0.9.0 with hadoop-0.20.2 and hbase -0.92.1. I have created > external table, mapping it to an existing table in hbase. When I do "select > * from myextrenaltable" it returns no results, although scan in hbase shows > data, and I do not see any errors in jobtracker log. > > Any ideas how to debug this issue. > > Thanks. > Alex. > --0016e6db7bc7c81e5b04cb3ffa9a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Can you tell us how you created mapping for the existing table ?

In t= ask log, do you see any connection attempt to HBase ?

Cheers

On Thu, Oct 4, 2012 at 11:30 AM, <alxsss@aim.com<= /a>> wrote:

H= ello,

I use hive-0.9.0 with hadoop-0.20.2 and hbase -0.92.1. I have created exter= nal table, mapping it to an existing table in hbase. When I do "select= * from myextrenaltable" it returns no results, although scan in hbase= shows data, and I do not see any errors in jobtracker log.

Any ideas how to debug this issue.

Thanks.
Alex.