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.