hive表ddl导出_HIVE备份之批量导出所有的HIVE建表字段

来自：http://blog.csdn.net/sparkexpert/article/details/52836374

# cat exp-tbl.sh

#!/bin/bash

hive -e "show tables;" > tables.txt

cat tables.txt|while read eachline

do

hive -e "show create table $eachline" >>tablesDDL.txt

done

这个是最简洁的脚本.

CREATE TABLE `ontime`(

`year` int,

`quarter` tinyint,

`month` tinyint,

`dayofmonth` tinyint,

`dayofweek` tinyint,

`flightdate` string,

`uniquecarrier` string,

`airlineid` int,

`carrier` string,

`tailnum` string,

`flightnum` string,

`originairportid` int,

`originairportseqid` int,

`origincitymarketid` int,

`origin` string,

`origincityname