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 8989418741 for ; Tue, 3 Nov 2015 11:10:46 +0000 (UTC) Received: (qmail 18650 invoked by uid 500); 3 Nov 2015 11:10:45 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 18579 invoked by uid 500); 3 Nov 2015 11:10:45 -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 18569 invoked by uid 99); 3 Nov 2015 11:10:45 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Nov 2015 11:10:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 954D6C8961 for ; Tue, 3 Nov 2015 11:10:44 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.901 X-Spam-Level: ** X-Spam-Status: No, score=2.901 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id zFppTVvutL0u for ; Tue, 3 Nov 2015 11:10:33 +0000 (UTC) Received: from mail-ig0-f174.google.com (mail-ig0-f174.google.com [209.85.213.174]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 7C8AA2139C for ; Tue, 3 Nov 2015 11:10:33 +0000 (UTC) Received: by igpw7 with SMTP id w7so77104915igp.0 for ; Tue, 03 Nov 2015 03:10:33 -0800 (PST) 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=rO+e74ig+j28WZ1c/a/HfR/zet/+pg6DbpW+4eRgwss=; b=xXRw1sVeHOorOtWs4TTpPK2vGt2tF9CP2Pv9lUNfGxmRrnEG2zQUB3gJrMuyCO5Mtr IjyzyxwRmIPXxouJmTAm9PicGdwseMQwNyDkfaiXqItGnVGHgd7k/bbl89i+D3AvkRPX mXIKpp1yc4kBAjb9/UlLJzXmHmNzrYu9AdVEaOS4v/gG0IQp8zearKtL8GVyn5UgzaU1 /Yt1rirf/TQ14mbEOYGXv7yVfCXHnoOuEv9VspROsVyU7Qv7237Sw7XR27PLNU9C08YW HpQI40CRGBW8w+ZWvy3n8fkfWxImBn91ufG6fvPi7s9rKgQ7SKL4KUTZTWhL4OEwyKYP gsOg== MIME-Version: 1.0 X-Received: by 10.50.66.141 with SMTP id f13mr15233843igt.51.1446549032908; Tue, 03 Nov 2015 03:10:32 -0800 (PST) Received: by 10.107.20.66 with HTTP; Tue, 3 Nov 2015 03:10:32 -0800 (PST) In-Reply-To: <00ac01d1160f$fcc11d90$f64358b0$@peridale.co.uk> References: <00ac01d1160f$fcc11d90$f64358b0$@peridale.co.uk> Date: Tue, 3 Nov 2015 16:40:32 +0530 Message-ID: Subject: Re: SemanticException Unable to fetch table t. null From: Rajkumar Singh To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7bdc0dd241bf290523a0f156 --047d7bdc0dd241bf290523a0f156 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable it seems that you are having a problem metastore. On Tue, Nov 3, 2015 at 1:46 PM, Mich Talebzadeh wrote= : > Hi, > > > > Has anyone got a quick fix for dropping such table please? > > > > hive> drop table t; > > FAILED: SemanticException Unable to fetch table t. null > > hive> desc t; > > FAILED: SemanticException Unable to fetch table t. null > > > > Thanks, > > > > Mich Talebzadeh > > > > *Sybase ASE 15 Gold Medal Award 2008* > > A Winning Strategy: Running the most Critical Financial Data on ASE 15 > > > http://login.sybase.com/files/Product_Overviews/ASE-Winning-Strategy-0919= 08.pdf > > Author of the books* "A Practitioner=E2=80=99s Guide to Upgrading to Syba= se ASE > 15", ISBN 978-0-9563693-0-7*. > > co-author *"Sybase Transact SQL Guidelines Best Practices", ISBN > 978-0-9759693-0-4* > > *Publications due shortly:* > > *Complex Event Processing in Heterogeneous Environments*, ISBN: > 978-0-9563693-3-8 > > *Oracle and Sybase, Concepts and Contrasts*, ISBN: 978-0-9563693-1-4, vol= ume > one out shortly > > > > http://talebzadehmich.wordpress.com > > > > NOTE: The information in this email is proprietary and confidential. This > message is for the designated recipient only, if you are not the intended > recipient, you should destroy it immediately. Any information in this > message shall not be understood as given or endorsed by Peridale Technolo= gy > Ltd, its subsidiaries or their employees, unless expressly so stated. It = is > the responsibility of the recipient to ensure that this email is virus > free, therefore neither Peridale Ltd, its subsidiaries nor their employee= s > accept any responsibility. > > > --047d7bdc0dd241bf290523a0f156 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
it seems that you are having a problem metastore.

On Tue, Nov 3, 2015 = at 1:46 PM, Mich Talebzadeh <mich@peridale.co.uk> wrote:

Hi,

<= span style=3D"font-family:"Arial",sans-serif">=C2=A0

Has anyone got a quick fix for dropping such table please?=

=C2=A0

hiv= e> drop table t;

FAILED: SemanticExce= ption Unable to fetch table t. null

hive= > desc t;

FAILED: SemanticException U= nable to fetch table t. null

=C2=A0<= /u>

Thanks,

<= span style=3D"font-family:"Arial",sans-serif">=C2=A0

Mich Talebzadeh

=C2=A0=

Sybase ASE 15 Gold Medal Award 2= 008

A Winning Strategy: Running the most Critical Financ= ial Data on ASE 15

http://login.sybase.com/= files/Product_Overviews/ASE-Winning-Strategy-091908.pdf

Author of the books "A Practitioner=E2=80=99s Guide to Upgradin= g to Sybase ASE 15", ISBN 978-0-9563693-0-7. =

co-autho= r "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-= 9759693-0-4

Publications due = shortly:<= /span>

Complex Event Processing in Heterogeneous Environments, ISBN: 978-0-9563693-3-8

Oracle and Sybase, Concepts and Contrast= s, ISBN: 978-0-9563693-1-4, volume on= e out shortly

=C2=A0

http://talebz= adehmich.wordpress.com

=C2=A0

NOTE: T= he information in this email is proprietary and confidential. This message = is for the designated recipient only, if you are not the intended recipient= , you should destroy it immediately. Any information in this message shall = not be understood as given or endorsed by Peridale Technology Ltd, its subs= idiaries or their employees, unless expressly so stated. It is the responsi= bility of the recipient to ensure that this email is virus free, therefore = neither Peridale Ltd, its subsidiaries nor their employees accept any respo= nsibility.

=C2=A0

--047d7bdc0dd241bf290523a0f156--