Or use a variant of the INSERT statement to write to a directory or a table.
On Wed, Mar 6, 2013 at 10:05 AM, Nitin Pawar <[EMAIL PROTECTED]>wrote:
> the results are not stored to any file .. they are available on console
> if you want to save to the results then write execute your query like hive
> -e "query" > file
> On Wed, Mar 6, 2013 at 9:32 PM, Sai Sai <[EMAIL PROTECTED]> wrote:
>> After we run a query in hive shell as:
>> Select * from myTable;
>> Are these results getting saved to any file apart from the
>> console/terminal display.
>> If so where is the location of the results.
> Nitin Pawar
*Dean Wampler, Ph.D.*