Hive批量生成DDL脚本

获取表名称，进入hive

hive> show tables;

OK
c02_clickstat_fatdt2
c02_clickstat_fatdt3
c02_clickstat_fatdt4
member
page_view
student
t_order
t_order2
tab_chenlun
tab_mysql
u_data
v_c02_clickstat_fatdt2
v_t_order
Time taken: 1.795 seconds, Fetched: 13 row(s)

将表名copy赋值给变量list

[root@hadoop bin]# list='c02_clickstat_fatdt2
> c02_clickstat_fatdt3
> c02_clickstat_fatdt4
> member
> page_view
> student
> t_order
> t_order2
> tab_chenlun
> tab_mysql
> u_data
> v_c02_clickstat_fatdt2
> v_t_order'

然后在Linux命令行敲入for循环：

for i in $list ;do
hive -S -e "show create table $i"
done

至于保存在哪儿，根据个人爱好而定。