override SemanticException [Error 10001]

Question

I want to alter 1000s table in hive database, but some of their tables exits some doesn't. As I execute that .sql file, as soon as it found table not present, it exits from hive. so help me out to override or skip those queries whose table is not present in hive

Answer 1

Try this configuration parameter:

set hive.cli.errors.ignore=true;

After setting it to 'true', all commands in the script are executed, no matter how many failed.

See here: https://issues.apache.org/jira/browse/HIVE-1847