Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of tombrown52@gmail.com
 designates 209.85.220.176 as permitted sender)
MIME-Version: 1.0
Date: Thu, 9 Aug 2012 15:32:11 -0600
Message-ID: 
 <CAHtRq2cHWh++7MiCey322V7M45T-dg15WmfshsLMeRXuhTzhWQ@mail.gmail.com>
Subject: Question about query result storage
From: Tom Brown <tombrown52@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Team,

I'm a new Hive user and I've just run my first large query (a few
hours). Unfortunately, I ran it from the CLI, and the output was
longer than my SSH client allowed for (scroll buffer) so I can't see
the first 1/2 of the result. (It also changes tabs to spaces so
properly aligning the columns of the result is difficult as well).

When a query is run through the CLI, is the result stored anywhere
(even temporarily)? I would love to not have to run the query again,
but will if I have to.

However, when I run the query again (from the CLI), I'm not sure how
to correctly store the results. Should I just pipe all output of the
CLI to a file and ignore the few hours of status updates? Can anyone
give any suggestions on what the most appropriate way to accomplish
this is?

Thanks in advance.

--Tom