I know by that way I can pipe the output to some txt file, but is there any way I can do within some sort of shell script so that If I need to schedule that shell script to run daily at some particular time, then it should work that way also and also I need to send that txt file as an attachment in an email.
*Raihan Jamal* On Tue, Jul 17, 2012 at 11:30 PM, Vinod Singh <[email protected]> wrote: > hive -e "SELECT count(*) from pds_table" > a.txt > > Thanks, > Vinod > > > On Wed, Jul 18, 2012 at 10:58 AM, Raihan Jamal <[email protected]>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* >> >> >
