Return-Path: 
 <user-return-7622-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 BA5689694
	for <apmail-hive-user-archive@www.apache.org>;
 Thu, 16 Feb 2012 20:08:07 +0000 (UTC)
Received: (qmail 63282 invoked by uid 500); 16 Feb 2012 20:08:06 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 63188 invoked by uid 500); 16 Feb 2012 20:08:06 -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 63177 invoked by uid 99); 16 Feb 2012 20:08:06 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2012 20:08:06 +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 carl@cloudera.com designates
 209.85.216.41 as permitted sender)
Received: from [209.85.216.41] (HELO mail-qw0-f41.google.com) (209.85.216.41)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2012 20:07:59 +0000
Received: by qadz32 with SMTP id z32so58075qad.14
        for <user@hive.apache.org>; Thu, 16 Feb 2012 12:07:39 -0800 (PST)
MIME-Version: 1.0
Received: by 10.229.173.104 with SMTP id o40mr2520140qcz.155.1329422859013;
 Thu, 16 Feb 2012 12:07:39 -0800 (PST)
Received: by 10.229.223.199 with HTTP; Thu, 16 Feb 2012 12:07:38 -0800 (PST)
In-Reply-To: <03381B41-B73C-41B3-A789-82B6BE9580C3@stumbleupon.com>
References: <03381B41-B73C-41B3-A789-82B6BE9580C3@stumbleupon.com>
Date: Thu, 16 Feb 2012 12:07:38 -0800
Message-ID: 
 <CAJqeMKSYP=smy3s48_NvAfdQBqF9=qwghfEgt232Qg4887KYmQ@mail.gmail.com>
Subject: Re: hive -e '<query>' not working in 0.8.0
From: Carl Steinbach <carl@cloudera.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=00504502d9d0448da104b91a61c6
X-Gm-Message-State: 
 ALoCoQlpfU/bv8v7uz8kio7E4CqilBO5bvtLfrhIV05Tcec3pzkZHdPGyznqQfmCCr9fQ2g34FE9
X-Virus-Checked: Checked by ClamAV on apache.org

--00504502d9d0448da104b91a61c6
Content-Type: text/plain; charset=ISO-8859-1

Hi Sam,

I tried running this against the hive-0.8.0 release tarball and did not
encounter any problems.
Is it possible that you have some old JARs or shell scripts hanging around
from a previous Hive install?

On Thu, Feb 16, 2012 at 11:58 AM, Sam William <sampd@stumbleupon.com> wrote:

> We recently upgraded to Hive-0.8.0  and noticed that all queries   fail
> when run as  hive -e <query>  with the error ,
>
>
> sampd@face:~$ hive -e "show tables;"
>
> FAILED: Parse Error: line 1:0 cannot recognize input near 'show' '<EOF>'
> '<EOF>' in ddl statement
>
>
> hive -f option works though .  Has anyone else faced this ?
>
> Sam William
> sampd@stumbleupon.com
>
>
>
>

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

Hi Sam,<div><br></div><div>I tried running this against the hive-0.8.0 rele=
ase tarball and did not encounter any problems.</div><div>Is it possible th=
at you have some old JARs or shell scripts hanging around from a previous=
=A0Hive install?</div>
<div><br><div class=3D"gmail_quote">On Thu, Feb 16, 2012 at 11:58 AM, Sam W=
illiam <span dir=3D"ltr">&lt;<a href=3D"mailto:sampd@stumbleupon.com">sampd=
@stumbleupon.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
We recently upgraded to Hive-0.8.0 =A0and noticed that all queries =A0 fail=
 when run as =A0hive -e &lt;query&gt; =A0with the error ,<br>
<br>
<br>
sampd@face:~$ hive -e &quot;show tables;&quot;<br>
<br>
FAILED: Parse Error: line 1:0 cannot recognize input near &#39;show&#39; &#=
39;&lt;EOF&gt;&#39; &#39;&lt;EOF&gt;&#39; in ddl statement<br>
<br>
<br>
hive -f option works though . =A0Has anyone else faced this ?<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
Sam William<br>
<a href=3D"mailto:sampd@stumbleupon.com">sampd@stumbleupon.com</a><br>
<br>
<br>
<br>
</font></span></blockquote></div><br></div>

--00504502d9d0448da104b91a61c6--