Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> drop table: no err on nonexistant table?


Copy link to this message
-
drop table: no err on nonexistant table?
I'm wrapping hive in a web tool and would like to do some basic error-checking.  If an attempt is made to drop a table that doesn't exist, I would like to show an error message.  The problem is, hive doesn't seem to produce any sort of error when dropping a table that doesn't exists.  Furthermore, if hive is run on the command line (-e) it doesn't return an error status.  Therefore, I think the only way to detect such an error is to actually inspect the table list (show tables) and manually see if the drop attempt will find a corresponding table.

Can I get an error of some sort on this or is it not possible?

Thank you.

________________________________________________________________________________
Keith Wiley     [EMAIL PROTECTED]     keithwiley.com    music.keithwiley.com

"I do not feel obliged to believe that the same God who has endowed us with
sense, reason, and intellect has intended us to forgo their use."
                                           --  Galileo Galilei
________________________________________________________________________________
+
Keith Wiley 2012-08-06, 18:31
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB