Hive写sql脚本删除指定表

脚本：drop_all_table.sql

drop table to_client_song_play_operate_req_d;
drop table to_song_info_d;
drop table tw_singer_rsi_d;
drop table tw_song_baseinfo_d;
drop table tw_song_ftur_d;
drop table tw_song_rsi_d;

执行脚本

[root@node4 ~]# hive -f ./drop_all_table.sql 

Logging initialized using configuration in jar:file:/opt/hive-1.2.1/lib/hive-common-1.2.1.jar!/hive-log4j.properties
OK
Time taken: 3.101 seconds
OK
Time taken: 0.185 seconds
OK
Time taken: 0.313 seconds
OK
Time taken: 0.35 seconds
OK
Time taken: 0.302 seconds
OK
Time taken: 0.386 seconds

查看对比

hive> show tables;
OK
browser
event_logs
hbasetbl
stats_view_depth
stats_view_depth_tmp
tmp_order
to_client_song_play_operate_req_d
to_song_info_d
tw_singer_rsi_d
tw_song_baseinfo_d
tw_song_ftur_d
tw_song_rsi_d
Time taken: 0.054 seconds, Fetched: 12 row(s)
hive> select * from TW_SONG_baseINFO_D limit 10;
FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'TW_SONG_baseINFO_D'
hive> show tables;
OK
browser
event_logs
hbasetbl
stats_view_depth
stats_view_depth_tmp
tmp_order
Time taken: 0.033 seconds, Fetched: 6 row(s)