脚本：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)
