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` string, 
  `originstate` string, 
  `originstatefips` string, 
  `originstatename` string, 
  `originwac` int, 
  `destairportid` int, 
  `destairportseqid` int, 
  `destcitymarketid` int, 
  `dest` string, 
  `destcityname` string, 
  `deststate` string, 
  `deststatefips` string, 
  `deststatename` string, 
  `destwac` int, 
  `crsdeptime` int, 
  `deptime` string, 
  `depdelay` string, 
  `depdelayminutes` string, 
  `depdel15` string, 
  `departuredelaygroups` string, 
  `deptimeblk` string, 
  `taxiout` string, 
  `wheelsoff` string, 
  `wheelson` string, 
  `taxiin` string, 
  `crsarrtime` string, 
  `arrtime` string, 
  `arrdelay` string, 
  `arrdelayminutes` string, 
  `arrdel15` string, 
  `arrivaldelaygroups` string, 
  `arrtimeblk` string, 
  `cancelled` tinyint, 
  `cancellationcode` string, 
  `diverted` tinyint, 
  `crselapsedtime` string, 
  `actualelapsedtime` string, 
  `airtime` string, 
  `flights` string, 
  `distance` string, 
  `distancegroup` tinyint, 
  `carrierdelay` string, 
  `weatherdelay` string, 
  `nasdelay` string, 
  `securitydelay` string, 
  `lateaircraftdelay` string, 
  `firstdeptime` string, 
  `totaladdgtime` string, 
  `longestaddgtime` string, 
  `divairportlandings` string, 
  `divreacheddest` string, 
  `divactualelapsedtime` string, 
  `divarrdelay` string, 
  `divdistance` string, 
  `div1airport` string, 
  `div1airportid` string, 
  `div1airportseqid` string, 
  `div1wheelson` string, 
  `div1totalgtime` string, 
  `div1longestgtime` string, 
  `div1wheelsoff` string, 
  `div1tailnum` string, 
  `div2airport` string, 
  `div2airportid` string, 
  `div2airportseqid` string, 
  `div2wheelson` string, 
  `div2totalgtime` string, 
  `div2longestgtime` string, 
  `div2wheelsoff` string, 
  `div2tailnum` string, 
  `div3airport` string, 
  `div3airportid` string, 
  `div3airportseqid` string, 
  `div3wheelson` string, 
  `div3totalgtime` string, 
  `div3longestgtime` string, 
  `div3wheelsoff` string, 
  `div3tailnum` string, 
  `div4airport` string, 
  `div4airportid` string, 
  `div4airportseqid` string, 
  `div4wheelson` string, 
  `div4totalgtime` string, 
  `div4longestgtime` string, 
  `div4wheelsoff` string, 
  `div4tailnum` string, 
  `div5airport` string, 
  `div5airportid` string, 
  `div5airportseqid` string, 
  `div5wheelson` string, 
  `div5totalgtime` string, 
  `div5longestgtime` string, 
  `div5wheelsoff` string, 
  `div5tailnum` string)
COMMENT 'Imported by sqoop on 2017/01/06 01:37:02'
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
WITH SERDEPROPERTIES ( 
  'field.delim'=',', 
  'line.delim'='\n', 
  'serialization.format'=',') 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'hdfs://localhost:9000/user/hive/warehouse/ontime'
TBLPROPERTIES (
  'numFiles'='4', 
  'numRows'='0', 
  'rawDataSize'='0', 
  'totalSize'='1978552775', 
  'transient_lastDdlTime'='1483695515')