Return-Path: 
 <user-return-7623-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 7336D9BF1
	for <apmail-hive-user-archive@www.apache.org>;
 Thu, 16 Feb 2012 20:23:01 +0000 (UTC)
Received: (qmail 16892 invoked by uid 500); 16 Feb 2012 20:23:00 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 16849 invoked by uid 500); 16 Feb 2012 20:23:00 -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 16841 invoked by uid 99); 16 Feb 2012 20:23:00 -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:23:00 +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 sampd@stumbleupon.com
 designates 209.85.210.48 as permitted sender)
Received: from [209.85.210.48] (HELO mail-pz0-f48.google.com) (209.85.210.48)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Feb 2012 20:22:52 +0000
Received: by dadp13 with SMTP id p13so2922290dad.35
        for <user@hive.apache.org>; Thu, 16 Feb 2012 12:22:31 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=stumbleupon.com; s=google;
        h=from:mime-version:content-type:subject:date:in-reply-to:to
         :references:message-id:x-mailer;
        bh=M4ZHYXFDRZJ2HITLzA+XuGcMCEXwRUA4+5QSKXsGJRw=;
        b=dTYy9pU8Zgbb26rHpblN96EGrREqBvCYeTsmm2kvd1H0H9HNrh8Jl1Hn6P4B1rH6kV
         s1abu2wWBXI+7A2+tNj7y9eSPJLB5KD6Ykhg+QTNMChpzk+6Li2R4Oz0qRO7a+7fCLee
         b3lCCRTIkQcQhyZfV450+p/ByxzcpN6h3/rJU=
Received: by 10.68.74.97 with SMTP id s1mr17212666pbv.46.1329423751294;
        Thu, 16 Feb 2012 12:22:31 -0800 (PST)
Received: from h-24-190.sfo.stumble.net ([38.102.133.103])
        by mx.google.com with ESMTPS id a6sm3123363pbs.68.2012.02.16.12.22.29
        (version=TLSv1/SSLv3 cipher=OTHER);
        Thu, 16 Feb 2012 12:22:30 -0800 (PST)
From: Sam William <sampd@stumbleupon.com>
Mime-Version: 1.0 (Apple Message framework v1251.1)
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_DCBD7576-A8A3-4513-BBD3-1DDFDC03E9C7"
Subject: Re: hive -e '<query>' not working in 0.8.0
Date: Thu, 16 Feb 2012 12:22:28 -0800
In-Reply-To: 
 <CAJqeMKSYP=smy3s48_NvAfdQBqF9=qwghfEgt232Qg4887KYmQ@mail.gmail.com>
To: user@hive.apache.org
References: <03381B41-B73C-41B3-A789-82B6BE9580C3@stumbleupon.com>
 <CAJqeMKSYP=smy3s48_NvAfdQBqF9=qwghfEgt232Qg4887KYmQ@mail.gmail.com>
Message-Id: <B1AB2BB7-8390-4713-8195-8F9AC8909D39@stumbleupon.com>
X-Mailer: Apple Mail (2.1251.1)
X-Gm-Message-State: 
 ALoCoQmHGeqRL0W75dRz3jL7H0YTKYWCyhE3QbUQwZD4lfO1DhuBGZSCiepRdwt6j8mu95+6lPRB
X-Virus-Checked: Checked by ClamAV on apache.org


--Apple-Mail=_DCBD7576-A8A3-4513-BBD3-1DDFDC03E9C7
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1

Sorry guys,  I figured this out.  We have a shell script that sets the =
env variables and then calls  the standard  hive-0.8.0/bin/hive  "$@" .  =
 The  problem was that the quotes around  $@ were missing and the hive =
executable was just getting  the first word .=20

It was just my bad.

Thanks,
Sam


On Feb 16, 2012, at 12:07 PM, Carl Steinbach wrote:

> Hi Sam,
>=20
> 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?
>=20
> 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 ,
>=20
>=20
> sampd@face:~$ hive -e "show tables;"
>=20
> FAILED: Parse Error: line 1:0 cannot recognize input near 'show' =
'<EOF>' '<EOF>' in ddl statement
>=20
>=20
> hive -f option works though .  Has anyone else faced this ?
>=20
> Sam William
> sampd@stumbleupon.com
>=20
>=20
>=20
>=20

Sam William
sampd@stumbleupon.com




--Apple-Mail=_DCBD7576-A8A3-4513-BBD3-1DDFDC03E9C7
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=iso-8859-1

<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Sorry guys, &nbsp;I figured this out. &nbsp;We have a shell script that sets the env variables and then calls &nbsp;the standard &nbsp;hive-0.8.0/bin/hive &nbsp;"$@" . &nbsp; The &nbsp;problem was that the quotes around &nbsp;$@ were missing and the hive executable was just getting &nbsp;the first word .&nbsp;<div><br></div><div>It was just my bad.</div><div><br></div><div>Thanks,</div><div>Sam</div><div><br></div><div><br><div><div>On Feb 16, 2012, at 12:07 PM, Carl Steinbach wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hi Sam,<div><br></div><div>I tried running this against the hive-0.8.0 release tarball and did not encounter any problems.</div><div>Is it possible that you have some old JARs or shell scripts hanging around from a previous&nbsp;Hive install?</div>
<div><br><div class="gmail_quote">On Thu, Feb 16, 2012 at 11:58 AM, Sam William <span dir="ltr">&lt;<a href="mailto:sampd@stumbleupon.com">sampd@stumbleupon.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
We recently upgraded to Hive-0.8.0 &nbsp;and noticed that all queries &nbsp; fail when run as &nbsp;hive -e &lt;query&gt; &nbsp;with the error ,<br>
<br>
<br>
sampd@face:~$ hive -e "show tables;"<br>
<br>
FAILED: Parse Error: line 1:0 cannot recognize input near 'show' '&lt;EOF&gt;' '&lt;EOF&gt;' in ddl statement<br>
<br>
<br>
hive -f option works though . &nbsp;Has anyone else faced this ?<br>
<span class="HOEnZb"><font color="#888888"><br>
Sam William<br>
<a href="mailto:sampd@stumbleupon.com">sampd@stumbleupon.com</a><br>
<br>
<br>
<br>
</font></span></blockquote></div><br></div>
</blockquote></div><br><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div>Sam William</div><div><a href="mailto:sampd@stumbleupon.com">sampd@stumbleupon.com</a></div><div><br></div></span><br class="Apple-interchange-newline">
</div>
<br></div></body></html>
--Apple-Mail=_DCBD7576-A8A3-4513-BBD3-1DDFDC03E9C7--