1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE EXTERNAL TABLE za_[tbName.eContainer(Database).name/].[tbName.name/]
(
[for (col : DbColumn | tbName.columns)]
`[col.name/]` [computeHiveType(col)/],
[/for]
)
COMMENT 'Table [tbName.eContainer(Database).name.toUpper()/] [tbName.name.toUpper()/]'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
'/prod/ZA/[tbName.eContainer(Database).name/]/[tbName.name.toUpper()/]'; |