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 SELECT count(*) from
pds_table"
Thanks,
Vinod
On Wed, Jul 18, 2012 at 12:04 PM, Raihan Jamal wrote:
> I know by that way I can pipe the output to som
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
hive -e "SELECT count(*) from pds_table" > a.txt
Thanks,
Vinod
On Wed, Jul 18, 2012 at 10:58 AM, Raihan Jamal 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 f
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.