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*

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*
>
>

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*
>>
>>
>

That is what I meant. Hive CLI can be invoked from a shell script. And
query can be changed to something like-

"INSERT OVERWRITE LOCAL DIRECTORY <PATH_TO_DIR> SELECT count(*) from
pds_table"

Thanks,
Vinod

On Wed, Jul 18, 2012 at 12:04 PM, Raihan Jamal <[EMAIL PROTECTED]>wrote:

> 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*
>>>
>>>
>>
>