Re: Exit Status for Success and Failure in HiveQL queries

2012-08-15 Thread abhiTowson cal
hi Raihan, I was in the same situation before.See if this thing helps you. Hive command writes to a log file and you cat that file for the success pattern. Let me know if this will help you.Need any further help?? for log in $logdir1/*.hivelog; do cat $log | grep "success pattern" #&> /dev/nul

Re: Exit Status for Success and Failure in HiveQL queries

2012-08-15 Thread Raihan Jamal
Let me try that.. Thanks for the help. *Raihan Jamal* On Wed, Aug 15, 2012 at 5:10 PM, hadoop hive wrote: > Hey Jamal, >You can use bash shell script combined with hive query, in shell script > you can check for exit status. > E.g : > #!/bin/bash > hive -e "show tables;" > RET_VAL=$? > i

RE: Exit Status for Success and Failure in HiveQL queries

2012-08-15 Thread hadoop hive
Hey Jamal, You can use bash shell script combined with hive query, in shell script you can check for exit status. E.g :#!/bin/bashhive -e "show tables;"RET_VAL=$?if [ $RET_VAL -ne 0]; thenexit(1) - From: jamalrai...@gmail.com Date: Wed, 15 Aug 2012 17:03:14 -0700 Subject: Exit Status for