RE: issue about hive command line

2013-12-02 Thread Garg, Rinku
Set your hive home  to $HIVE_HOME variable and execute the following command.

$HIVE_HOME/bin/hive -e  DDL

Thanks  Regards,
Rinku Garg - Global Commercial Services

From: ch huang [mailto:justlo...@gmail.com]
Sent: 02 December 2013 13:22
To: user@hive.apache.org
Subject: issue about hive command line

hi,maillist:
  i am write a bash script,what i want is run hive -e 'DDL'  in 
script, and i want judge if the hive DDL is success or fail,how can i do this ?

_
The information contained in this message is proprietary and/or confidential. 
If you are not the intended recipient, please: (i) delete the message and all 
copies; (ii) do not disclose, distribute or use the message in any manner; and 
(iii) notify the sender immediately. In addition, please be aware that any 
message addressed to our domain is subject to archiving and review by persons 
other than the intended recipient. Thank you.


Re: issue about hive command line

2013-12-02 Thread ch huang
i means how to judge if the hive DDL success or fail ,i figure it out by
myself ,i store the error output to a file ,then search FAIL text in the
file,if not, success,if get ,fail


On Mon, Dec 2, 2013 at 4:08 PM, Garg, Rinku rinku.g...@fisglobal.comwrote:

  Set your hive home  to $HIVE_HOME variable and execute the following
 command.



 $HIVE_HOME/bin/hive –e  DDL



 Thanks  Regards,

 *Rinku Garg *- Global Commercial Services

  *From:* ch huang [mailto:justlo...@gmail.com]
 *Sent:* 02 December 2013 13:22
 *To:* user@hive.apache.org
 *Subject:* issue about hive command line



 hi,maillist:

   i am write a bash script,what i want is run hive -e 'DDL' 
 in script, and i want judge if the hive DDL is success or fail,how can i do
 this ?
   _
 The information contained in this message is proprietary and/or
 confidential. If you are not the intended recipient, please: (i) delete the
 message and all copies; (ii) do not disclose, distribute or use the message
 in any manner; and (iii) notify the sender immediately. In addition, please
 be aware that any message addressed to our domain is subject to archiving
 and review by persons other than the intended recipient. Thank you.



Re: issue about hive command line

2013-12-02 Thread Nitin Pawar
try writing a wrong ddl and capture the command exit status with $?

if thats what you are looking for


On Mon, Dec 2, 2013 at 5:34 PM, ch huang justlo...@gmail.com wrote:

 i means how to judge if the hive DDL success or fail ,i figure it out by
 myself ,i store the error output to a file ,then search FAIL text in the
 file,if not, success,if get ,fail


 On Mon, Dec 2, 2013 at 4:08 PM, Garg, Rinku rinku.g...@fisglobal.comwrote:

  Set your hive home  to $HIVE_HOME variable and execute the following
 command.



 $HIVE_HOME/bin/hive –e  DDL



 Thanks  Regards,

 *Rinku Garg *- Global Commercial Services

  *From:* ch huang [mailto:justlo...@gmail.com]
 *Sent:* 02 December 2013 13:22
 *To:* user@hive.apache.org
 *Subject:* issue about hive command line



 hi,maillist:

   i am write a bash script,what i want is run hive -e 'DDL'
  in script, and i want judge if the hive DDL is success or fail,how can i
 do this ?
   _
 The information contained in this message is proprietary and/or
 confidential. If you are not the intended recipient, please: (i) delete the
 message and all copies; (ii) do not disclose, distribute or use the message
 in any manner; and (iii) notify the sender immediately. In addition, please
 be aware that any message addressed to our domain is subject to archiving
 and review by persons other than the intended recipient. Thank you.





-- 
Nitin Pawar


Re: issue about hive command line

2013-12-02 Thread ch huang
it's not worked ,when i write script,first way i used is what you suggested


On Mon, Dec 2, 2013 at 8:07 PM, Nitin Pawar nitinpawar...@gmail.com wrote:

 try writing a wrong ddl and capture the command exit status with $?

 if thats what you are looking for


 On Mon, Dec 2, 2013 at 5:34 PM, ch huang justlo...@gmail.com wrote:

 i means how to judge if the hive DDL success or fail ,i figure it out by
 myself ,i store the error output to a file ,then search FAIL text in the
 file,if not, success,if get ,fail


 On Mon, Dec 2, 2013 at 4:08 PM, Garg, Rinku rinku.g...@fisglobal.comwrote:

  Set your hive home  to $HIVE_HOME variable and execute the following
 command.



 $HIVE_HOME/bin/hive –e  DDL



 Thanks  Regards,

 *Rinku Garg *- Global Commercial Services

  *From:* ch huang [mailto:justlo...@gmail.com]
 *Sent:* 02 December 2013 13:22
 *To:* user@hive.apache.org
 *Subject:* issue about hive command line



 hi,maillist:

   i am write a bash script,what i want is run hive -e 'DDL'
  in script, and i want judge if the hive DDL is success or fail,how can i
 do this ?
   _
 The information contained in this message is proprietary and/or
 confidential. If you are not the intended recipient, please: (i) delete the
 message and all copies; (ii) do not disclose, distribute or use the message
 in any manner; and (iii) notify the sender immediately. In addition, please
 be aware that any message addressed to our domain is subject to archiving
 and review by persons other than the intended recipient. Thank you.





 --
 Nitin Pawar



RE: issue about hive command line

2013-12-02 Thread Sachin Sudarashana
Hi huang,

Redirect the output to a file on the local file system.
hive -e DDL  hive.log

You can then go through the hive.log file to figure out if the query was 
successful or not.

Thank you,
Sachin

-Original Message-
From: Garg, Rinku rinku.g...@fisglobal.com
Sent: ‎02-‎12-‎2013 13:39
To: user@hive.apache.org user@hive.apache.org
Subject: RE: issue about hive command line

Set your hive home  to $HIVE_HOME variable and execute the following command.
 
$HIVE_HOME/bin/hive –e  DDL
 
Thanks  Regards,
Rinku Garg - Global Commercial Services


From: ch huang [mailto:justlo...@gmail.com] 
Sent: 02 December 2013 13:22
To: user@hive.apache.org
Subject: issue about hive command line
 
hi,maillist:
  i am write a bash script,what i want is run hive -e 'DDL'  in 
script, and i want judge if the hive DDL is success or fail,how can i do this ? 
_
The information contained in this message is proprietary and/or confidential. 
If you are not the intended recipient, please: (i) delete the message and all 
copies; (ii) do not disclose, distribute or use the message in any manner; and 
(iii) notify the sender immediately. In addition, please be aware that any 
message addressed to our domain is subject to archiving and review by persons 
other than the intended recipient. Thank you.