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.