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 372ECD3A6 for ; Sun, 9 Sep 2012 10:49:46 +0000 (UTC) Received: (qmail 56522 invoked by uid 500); 9 Sep 2012 10:49:44 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 56264 invoked by uid 500); 9 Sep 2012 10:49:44 -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 56227 invoked by uid 99); 9 Sep 2012 10:49:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Sep 2012 10:49:42 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of samuel.d.darwin@gmail.com designates 209.85.210.176 as permitted sender) Received: from [209.85.210.176] (HELO mail-iy0-f176.google.com) (209.85.210.176) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Sep 2012 10:49:35 +0000 Received: by iagt4 with SMTP id t4so1107675iag.35 for ; Sun, 09 Sep 2012 03:49:14 -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=R5iv3EjEHSNqCMFMWuPPyW63apUIkqSgTLO5o+xSxNQ=; b=jyZPv3jWBILT8W/HwpK8l8VVg4d2+Uu+cYiJs8sU2E2HRsugb82QSAsIsAYbApY1r/ IeEOzyHYpqmng1fbQWWJNMk1+7uLX1OSWT2S4BWl8o+z68JZxcTafBAoblyj0IMHUqd7 +BRRJwINUs9KmEe2EIUlZ/7kiRDuwYOHRONDIJxRFZtO7gySRhCFYfakZNJZKuuBkNIJ 5QoVPkwh98scT1GX5w7vdMc1WNtW0TLLGGu3+TYLxxQ944x/keEvGhzxKsrqmAg/XJXn Dc9Bd1cIX6XebtxekfuYzUHfiaUHpAET99x9uvdEm3vlcr93Ib+fZ7cQPkXxhOR/yxM6 aJuQ== MIME-Version: 1.0 Received: by 10.50.76.137 with SMTP id k9mr6385608igw.58.1347187754042; Sun, 09 Sep 2012 03:49:14 -0700 (PDT) Received: by 10.64.165.230 with HTTP; Sun, 9 Sep 2012 03:49:14 -0700 (PDT) Date: Sun, 9 Sep 2012 12:49:14 +0200 Message-ID: Subject: hive table missing From: Sam Darwin To: user@hive.apache.org Content-Type: text/plain; charset=ISO-8859-1 Hi, We are seeing a hive table is gone unexpectedly. I suspect that this must have been caused by someone somewhere issuing a "drop table" command. But it's unclear. My question is : are there other known ways for hive to lose a table besides "drop table". For example, let's say that the underlying hdfs file system is having some trouble, it is unreachable for a few minutes, maybe hive could think "I don't see the hdfs files I need for this table. I will assume the user wishes to delete the table." And then it proceeds to cause an automatic deletion. That would certainly be terrible. :-) But I hope you see what I am getting at.. Other ways which might cause a table to be lost, besides someone typing in the "drop table" command in a hive session. Thanks, Sam