hive -e "SELECT count(*) from pds_table" > a.txt Thanks, Vinod
On Wed, Jul 18, 2012 at 10:58 AM, Raihan Jamal <jamalrai...@gmail.com>wrote: > I am new to Unix Shell Scripting world. I wanted to run a simple > *HiveQL*query from the Unix Shell script and output the result in a .txt file > and > then send that .txt file as an attachment in an email. > > SQL Query and piping the output to a txt file is below: > > SELECT count(*) from pds_table > a.txt; > > How can I do this from a shell script and send the output to a txt file > and then send that txt file as an attachment in an email. > > > *Raihan Jamal* > >
