Return-Path: 
 <user-return-12584-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
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 0EF3010350
	for <apmail-hive-user-archive@www.apache.org>;
 Tue, 23 Apr 2013 05:02:59 +0000 (UTC)
Received: (qmail 96566 invoked by uid 500); 23 Apr 2013 04:48:52 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 96458 invoked by uid 500); 23 Apr 2013 04:48:51 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 96413 invoked by uid 99); 23 Apr 2013 04:48:50 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Apr 2013 04:48:50 +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 tangxun.alice@gmail.com
 designates 209.85.212.176 as permitted sender)
Received: from [209.85.212.176] (HELO mail-wi0-f176.google.com)
 (209.85.212.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Apr 2013 04:48:43 +0000
Received: by mail-wi0-f176.google.com with SMTP id hj19so5516808wib.3
        for <user@hive.apache.org>; Mon, 22 Apr 2013 21:48:23 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=x-received:mime-version:from:date:message-id:subject:to
         :content-type;
        bh=Lj39px0+nzF/2iXU2u7K3pfZR7KjCJyszm0sGzNA2Hw=;
        b=VntEzu+p92qMkzcS5dalZQMcF4GIA9OFDFh43k8GN1QB0tcWeI7pQZ/vlUNcBurzPm
         3bLqu0oIAcIgvHU40dNE9gEgAx52HkH8vcKykNmDdyaZV97ie+u3vdSEdaza229D1z7B
         BeeDm7p1hppORKgGTgAoda89l2wtXN38/kA0OiHHVrgjGumJCyVwAAQ9+p4UTWyPQi7V
         5iMplbBGyyBjdWAv7lYQ5inbeqA2W1U0O470PPql2awL2HLwJKLyXC18LlMFbYu3V5HD
         /COa3skrXZQ8e3AmDa7hJewxYmmWid+xI18XUv6ooFc0vram252a+UysLAllzEYE2A8V
         5PgA==
X-Received: by 10.194.82.34 with SMTP id f2mr108843wjy.25.1366692503791; Mon,
 22 Apr 2013 21:48:23 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.194.21.196 with HTTP; Mon, 22 Apr 2013 21:48:03 -0700 (PDT)
From: Xun TANG <tangxun.alice@gmail.com>
Date: Mon, 22 Apr 2013 21:48:03 -0700
Message-ID: 
 <CAAAJpYztAk6B5+mtKiP7UdTosGyyzuFmy9v5sGUgo1YmejF2bw@mail.gmail.com>
Subject: Table present in HDFS but 'show table' Returns Empty
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=047d7beb95c034b01d04daffe5a5
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7beb95c034b01d04daffe5a5
Content-Type: text/plain; charset=ISO-8859-1

Hi guys,

I've created hive tables via 'hive -f' or hive interactive shell. Data are
loaded to tables right after, so the tables are not empty. However, when I
log out and log in to hive shell again, 'show tables' return 0 table, while
'hadoop list' command shows the hdfs files are still where they were.

So my questions are,
1. What triggered hive to 'forget' the tables?
2. How to make hive permanently (or within the lifecycle of hadoop daemons)
remember the tables until they were dropped?

This problem has puzzled me for a while, and I could not find similar
question/answer online... Did I miss some configuration?


Thanks,
Alice

--047d7beb95c034b01d04daffe5a5
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi guys,<div><br></div><div style>I&#39;ve created hive ta=
bles via &#39;hive -f&#39; or hive interactive shell. Data are loaded to ta=
bles right after, so the tables are not empty. However, when I log out and =
log in to hive shell again, &#39;show tables&#39; return 0 table, while &#3=
9;hadoop list&#39; command shows the hdfs files are still where they were.=
=A0</div>

<div style><br></div><div style>So my questions are,</div><div style>1. Wha=
t triggered hive to &#39;forget&#39; the tables?</div><div style>2. How to =
make hive permanently (or within the lifecycle of hadoop daemons) remember =
the tables until they were dropped?</div>

<div style><br></div><div style>This problem has puzzled me for a while, an=
d I could not find similar question/answer online... Did I miss some config=
uration?=A0</div><div style><br></div><div style><br></div><div style>Thank=
s,</div>

<div style>Alice</div></div>

--047d7beb95c034b01d04daffe5a5--