Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Run simple HiveQL query using shell script?


Copy link to this message
-
Re: Run simple HiveQL query using shell script?
Raihan Jamal 2012-07-18, 06:34
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*
>>
>>
>