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.
Thanks
Sai

the results are not stored to any file .. they are available on console only

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.
> Thanks
> Sai
>

--
Nitin Pawar

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
> only
>
> 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.
>> Thanks
>> Sai
>>
>
>
>
> --
> Nitin Pawar
>

--
*Dean Wampler, Ph.D.*
thinkbiganalytics.com
+1-312-339-1330