Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of the1plummie@gmail.com
 designates 209.85.220.176 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=SmyVQvZlsOLbdfZhhryInnDcUx+IykP8KI4MMI2+ckE5tzAadzpM1JzNTBEk/1WMex
         a7qkOyQ6OVyXNnOl5ayE/TEYfVIkYIxeXcButt6drGr45xf+FSilMVWnOAU/QpgdqzJj
         xUBjg1TGSjN6b3RZnwco8vKdVI9dz5Yl5MKiU=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=ORqeg0NOr-SxckicbbWciFp8gBw@mail.gmail.com>
References: <BANLkTi=ORqeg0NOr-SxckicbbWciFp8gBw@mail.gmail.com>
Date: Tue, 14 Jun 2011 21:12:56 -0700
Message-ID: <BANLkTikUjx8JEEtsoKoC1+weVVTj60W2_Q@mail.gmail.com>
Subject: Re: how to save the output information of hive console client to a
 file?
From: Shouguo Li <the1plummie@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=bcaec51a7d5a07772504a5b85e1e

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

you can save the output to a directory, for later use. like this:
INSERT OVERWRITE LOCAL DIRECTORY '/tmp/hive_query_dump/'
SELECT * FROM table1;

more details here: http://wiki.apache.org/hadoop/Hive/LanguageManual/DML
(scroll to the end of the page)

if you need to do more complicated processing after you get the output from
hive, maybe you want to run queries from some scripts (like python) via hive
server. here are some docs about that:
http://wiki.apache.org/hadoop/Hive/HiveServer
http://wiki.apache.org/hadoop/Hive/HiveClient

hope that helps.
good luck!

On Tue, Jun 14, 2011 at 4:45 AM, jinhang du <dujinhang@gmail.com> wrote:

> Hi all,
>
> I want record the output of every commends executed on hive console client.
> How to do it ?
>
> Thanks.
>
> --
> dujinhang
>

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

you can save the output to a directory, for later use. like this:<br>
INSERT OVERWRITE LOCAL DIRECTORY &#39;/tmp/hive_query_dump/&#39;<br>
SELECT * FROM table1;<br>
<br>
more details here: <a href=3D"http://wiki.apache.org/hadoop/Hive/LanguageMa=
nual/DML">http://wiki.apache.org/hadoop/Hive/LanguageManual/DML</a><br>
(scroll to the end of the page)<br><br>if you need to do more complicated p=
rocessing after you get the output from hive, maybe you want to run queries=
 from some scripts (like python) via hive server. here are some docs about =
that:<br>
<a href=3D"http://wiki.apache.org/hadoop/Hive/HiveServer">http://wiki.apach=
e.org/hadoop/Hive/HiveServer</a><br><a href=3D"http://wiki.apache.org/hadoo=
p/Hive/HiveClient">http://wiki.apache.org/hadoop/Hive/HiveClient</a><br><br=
>
hope that helps.<br>
good luck!<br><br><div class=3D"gmail_quote">On Tue, Jun 14, 2011 at 4:45 A=
M, jinhang du <span dir=3D"ltr">&lt;<a href=3D"mailto:dujinhang@gmail.com">=
dujinhang@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;=
">
Hi all,<br><br>I want record the output of every commends executed on hive =
console client.<br>How to do it ?<br><br>Thanks.<br clear=3D"all"><font col=
or=3D"#888888"><br>-- <br>dujinhang<br>
</font></blockquote></div><br>

--bcaec51a7d5a07772504a5b85e1e--