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 <nitinpawar...@gmail.com>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 <saigr...@yahoo.in> 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