create table b asselect * from table a;
create table b as
select * from table a;
请在此基础上添加检查条件如果表a有记录，那么应该创建表b如果表a没有记录，则不应创建表b
xdnvmnnf1#
可以有条件地使脚本失败
--this will generate HiveException with message ASSERT_TRUE(): assertion failed--it the table is empty and the script will exitselect assert_true(count(*)>0) from a;--If previous statement executed successfullycreate table b asselect * from table a;
--this will generate HiveException with message ASSERT_TRUE(): assertion failed
--it the table is empty and the script will exit
select assert_true(count(*)>0) from a;
--If previous statement executed successfully
另一种方法是使用 java_method("java.lang.System", "exit", 1) :
java_method("java.lang.System", "exit", 1)
select "Checking source is not empty ...";select java_method("java.lang.System", "exit", 1) --Exit from(select count(*) cnt from a)s where cnt=0; --select only if count=0select "Creating the table b ...";--Put create table here
select "Checking source is not empty ...";
select java_method("java.lang.System", "exit", 1) --Exit
from
(
select count(*) cnt
from a
)s where cnt=0; --select only if count=0
select "Creating the table b ...";
--Put create table here
1条答案
按热度按时间xdnvmnnf1#
可以有条件地使脚本失败
另一种方法是使用
java_method("java.lang.System", "exit", 1):