覆盖SemanticException [错误10001] [英] override SemanticException [Error 10001]

问题描述

我想更改hive数据库中的1000s表，但是它们的某些表退出而有些则没有.当我执行该.sql文件时，一旦发现表不存在，它就会从配置单元中退出.因此，请帮助我覆盖或跳过那些不在蜂巢中存在其表的查询

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

推荐答案

尝试使用此配置参数:

set hive.cli.errors.ignore=true;

将其设置为"true"后，无论有多少失败，脚本中的所有命令都将执行.

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

请参阅此处: https://issues.apache.org/jira/browse/HIVE-1847

这篇关于覆盖SemanticException [错误10001]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！