Run simple HiveQL query using shell script?

[Raihan Jamal]

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*