2. CREATE  TABLE `dim_nat_code`(
    3.   `nat_id` string COMMENT '编码', 
    4.   `nat_name` string COMMENT '国家或地区')
    5. COMMENT '国家或地区码表'
    6. ROW FORMAT SERDE 
    7.   'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' 
    8. WITH SERDEPROPERTIES ( 
    9.   'field.delim'='\t', 
    10.   'serialization.format'='\t') 
    11. STORED AS INPUTFORMAT 
    12.   'org.apache.hadoop.mapred.TextInputFormat' 
    13. OUTPUTFORMAT 
    14.   'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
    15. LOCATION
    16.   'hdfs://mycluster/warehouse/travel/ods/ODS_NAT_CODE'
    17. TBLPROPERTIES (
    18.   'bucketing_version'='2', 
    19.   'transient_lastDdlTime'='1630152666')
    20.   ;
    22.  insert into  dim_native_code (nat_id,nat_name) values (852, '中国香港')     
    23. ;insert into  dim_native_code (nat_id,nat_name) values (853, '中国澳门')     
    24. ;insert into  dim_native_code (nat_id,nat_name) values (886, '中国台湾')     
    25. ;insert into  dim_native_code (nat_id,nat_name) values (100, '美国')
    26. ;insert into  dim_native_code (nat_id,nat_name) values (100, '加拿大')  
    27. ;insert into  dim_native_code (nat_id,nat_name) values (100, '圣基茨和尼维斯')
    28. ;insert into  dim_native_code (nat_id,nat_name) values (100, '圣文森特')
    29. ;insert into  dim_native_code (nat_id,nat_name) values (100, '特克斯和凯特斯群岛') 
    30. ;insert into  dim_native_code (nat_id,nat_name) values (100, '英属维尔京群岛')   
    31. ;insert into  dim_native_code (nat_id,nat_name) values (124, '巴巴多斯岛')   
    32. ;insert into  dim_native_code (nat_id,nat_name) values (126, '安圭拉岛')    
    33. ;insert into  dim_native_code (nat_id,nat_name) values (126, '安提瓜岛巴布达岛')   
    34. ;insert into  dim_native_code (nat_id,nat_name) values (134, '开曼群岛')   
    35. ;insert into  dim_native_code (nat_id,nat_name) values (147, '格林纳达')
    36. ;insert into  dim_native_code (nat_id,nat_name) values (166, '蒙特塞拉特岛')
    37. ;insert into  dim_native_code (nat_id,nat_name) values (167, '关岛')
    38. ;insert into  dim_native_code (nat_id,nat_name) values (175, '圣卢西亚')    
    39. ;insert into  dim_native_code (nat_id,nat_name) values (180, '多米尼加共和国')    
    40. ;insert into  dim_native_code (nat_id,nat_name) values (186, '特立尼达和多巴哥'
    41. ;insert into  dim_native_code (nat_id,nat_name) values (187, '牙买加')
    42. ;insert into  dim_native_code (nat_id,nat_name) values (193, '波多黎各')    
    43. ;insert into  dim_native_code (nat_id,nat_name) values (20 , '埃及')     
    44. ;insert into  dim_native_code (nat_id,nat_name) values (212, '摩洛哥')     
    45. ;insert into  dim_native_code (nat_id,nat_name) values (213, '阿尔及利亚')     
    46. ;insert into  dim_native_code (nat_id,nat_name) values (216, '突尼斯')     
    47. ;insert into  dim_native_code (nat_id,nat_name) values (218, '利比亚')     
    48. ;insert into  dim_native_code (nat_id,nat_name) values (220, '冈比亚')     
    49. ;insert into  dim_native_code (nat_id,nat_name) values (221, '塞内加尔')     
    50. ;insert into  dim_native_code (nat_id,nat_name) values (222, '毛里塔尼亚')     
    51. ;insert into  dim_native_code (nat_id,nat_name) values (223, '马里')     
    52. ;insert into  dim_native_code (nat_id,nat_name) values (224, '几内亚')     
    53. ;insert into  dim_native_code (nat_id,nat_name) values (225, '科特迪瓦')     
    54. ;insert into  dim_native_code (nat_id,nat_name) values (226, '布基纳法索')     
    55. ;insert into  dim_native_code (nat_id,nat_name) values (227, '尼日尔')     
    56. ;insert into  dim_native_code (nat_id,nat_name) values (228, '多哥')     
    57. ;insert into  dim_native_code (nat_id,nat_name) values (229, '贝宁')     
    58. ;insert into  dim_native_code (nat_id,nat_name) values (230, '毛里求斯')     
    59. ;insert into  dim_native_code (nat_id,nat_name) values (231, '利比里亚')     
    60. ;insert into  dim_native_code (nat_id,nat_name) values (232, '塞拉利昂')     
    61. ;insert into  dim_native_code (nat_id,nat_name) values (233, '加纳')     
    62. ;insert into  dim_native_code (nat_id,nat_name) values (234, '尼日利亚')     
    63. ;insert into  dim_native_code (nat_id,nat_name) values (235, '乍得')     
    64. ;insert into  dim_native_code (nat_id,nat_name) values (236, '中非')     
    65. ;insert into  dim_native_code (nat_id,nat_name) values (237, '喀麦隆')     
    66. ;insert into  dim_native_code (nat_id,nat_name) values (238, '佛得角')     
    67. ;insert into  dim_native_code (nat_id,nat_name) values (242, '刚果')    
    68. ;insert into  dim_native_code (nat_id,nat_name) values (244, '安哥拉')     
    69. ;insert into  dim_native_code (nat_id,nat_name) values (245, '几内亚比绍')     
    70. ;insert into  dim_native_code (nat_id,nat_name) values (248, '塞舌尔')     
    71. ;insert into  dim_native_code (nat_id,nat_name) values (249, '苏丹')     
    72. ;insert into  dim_native_code (nat_id,nat_name) values (250, '卢旺达')     
    73. ;insert into  dim_native_code (nat_id,nat_name) values (251, '埃塞俄比亚')     
    74. ;insert into  dim_native_code (nat_id,nat_name) values (253, '吉布提')     
    75. ;insert into  dim_native_code (nat_id,nat_name) values (254, '肯尼亚')     
    76. ;insert into  dim_native_code (nat_id,nat_name) values (255, '坦桑尼亚')     
    77. ;insert into  dim_native_code (nat_id,nat_name) values (256, '乌干达')     
    78. ;insert into  dim_native_code (nat_id,nat_name) values (257, '布隆迪')     
    79. ;insert into  dim_native_code (nat_id,nat_name) values (258, '莫桑比克')     
    80. ;insert into  dim_native_code (nat_id,nat_name) values (260, '赞比亚')     
    81. ;insert into  dim_native_code (nat_id,nat_name) values (261, '马达加斯加')     
    82. ;insert into  dim_native_code (nat_id,nat_name) values (262, '留尼旺岛')
    83. ;insert into  dim_native_code (nat_id,nat_name) values (263, '津巴布韦')     
    84. ;insert into  dim_native_code (nat_id,nat_name) values (265, '马拉维')     
    85. ;insert into  dim_native_code (nat_id,nat_name) values (266, '莱索托')     
    86. ;insert into  dim_native_code (nat_id,nat_name) values (267, '博茨瓦纳')     
    87. ;insert into  dim_native_code (nat_id,nat_name) values (269, '科摩罗')
    88. ;insert into  dim_native_code (nat_id,nat_name) values (27 , '南非')     
    89. ;insert into  dim_native_code (nat_id,nat_name) values (298, '法罗群岛')     
    90. ;insert into  dim_native_code (nat_id,nat_name) values (299, '格陵兰岛')     
    91. ;insert into  dim_native_code (nat_id,nat_name) values (30 , '希腊')     
    92. ;insert into  dim_native_code (nat_id,nat_name) values (31 , '荷兰')     
    93. ;insert into  dim_native_code (nat_id,nat_name) values (32 , '比利时')     
    94. ;insert into  dim_native_code (nat_id,nat_name) values (33 , '法属安的列斯群岛')     
    95. ;insert into  dim_native_code (nat_id,nat_name) values (34 , '西班牙')     
    96. ;insert into  dim_native_code (nat_id,nat_name) values (350, '直布罗陀')     
    97. ;insert into  dim_native_code (nat_id,nat_name) values (351, '葡萄牙')     
    98. ;insert into  dim_native_code (nat_id,nat_name) values (352, '卢森堡')     
    99. ;insert into  dim_native_code (nat_id,nat_name) values (353, '爱尔兰')     
    100. ;insert into  dim_native_code (nat_id,nat_name) values (354, '冰岛')     
    101. ;insert into  dim_native_code (nat_id,nat_name) values (355, '阿尔巴尼亚')     
    102. ;insert into  dim_native_code (nat_id,nat_name) values (356, '马耳他')     
    103. ;insert into  dim_native_code (nat_id,nat_name) values (357, '塞浦路斯')     
    104. ;insert into  dim_native_code (nat_id,nat_name) values (358, '芬兰')     
    105. ;insert into  dim_native_code (nat_id,nat_name) values (359, '保加利亚')     
    106. ;insert into  dim_native_code (nat_id,nat_name) values (36 , '匈牙利')     
    107. ;insert into  dim_native_code (nat_id,nat_name) values (370, '立陶宛')     
    108. ;insert into  dim_native_code (nat_id,nat_name) values (371, '拉脱维亚')     
    109. ;insert into  dim_native_code (nat_id,nat_name) values (372, '爱沙尼亚')     
    110. ;insert into  dim_native_code (nat_id,nat_name) values (373, '摩尔多瓦')     
    111. ;insert into  dim_native_code (nat_id,nat_name) values (374, '亚美尼亚')     
    112. ;insert into  dim_native_code (nat_id,nat_name) values (375, '白俄罗斯')     
    113. ;insert into  dim_native_code (nat_id,nat_name) values (376, '安道尔')     
    114. ;insert into  dim_native_code (nat_id,nat_name) values (377, '摩纳哥')     
    115. ;insert into  dim_native_code (nat_id,nat_name) values (378, '圣马力诺')     
    116. ;insert into  dim_native_code (nat_id,nat_name) values (387, '波斯尼亚和黑塞哥维那')     
    117. ;insert into  dim_native_code (nat_id,nat_name) values (389, '马其顿')     
    118. ;insert into  dim_native_code (nat_id,nat_name) values (39 , '意大利')     
    119. ;insert into  dim_native_code (nat_id,nat_name) values (40 , '罗马尼亚')     
    120. ;insert into  dim_native_code (nat_id,nat_name) values (41 , '瑞士')     
    121. ;insert into  dim_native_code (nat_id,nat_name) values (420, '捷克')     
    122. ;insert into  dim_native_code (nat_id,nat_name) values (421, '斯洛伐克')     
    123. ;insert into  dim_native_code (nat_id,nat_name) values (423, '列支敦士登')     
    124. ;insert into  dim_native_code (nat_id,nat_name) values (43 , '奥地利')     
    125. ;insert into  dim_native_code (nat_id,nat_name) values (44 , '英国')     
    126. ;insert into  dim_native_code (nat_id,nat_name) values (45 , '丹麦')     
    127. ;insert into  dim_native_code (nat_id,nat_name) values (46 , '瑞典')     
    128. ;insert into  dim_native_code (nat_id,nat_name) values (47 , '挪威')     
    129. ;insert into  dim_native_code (nat_id,nat_name) values (48 , '波兰')     
    130. ;insert into  dim_native_code (nat_id,nat_name) values (49 , '德国')     
    131. ;insert into  dim_native_code (nat_id,nat_name) values (501, '伯利兹')     
    132. ;insert into  dim_native_code (nat_id,nat_name) values (502, '危地马拉')     
    133. ;insert into  dim_native_code (nat_id,nat_name) values (503, '萨尔瓦多')     
    134. ;insert into  dim_native_code (nat_id,nat_name) values (504, '洪都拉斯')     
    135. ;insert into  dim_native_code (nat_id,nat_name) values (505, '尼加拉瓜')     
    136. ;insert into  dim_native_code (nat_id,nat_name) values (506, '哥斯达黎加')     
    137. ;insert into  dim_native_code (nat_id,nat_name) values (507, '巴拿马')     
    138. ;insert into  dim_native_code (nat_id,nat_name) values (51 , '秘鲁')     
    139. ;insert into  dim_native_code (nat_id,nat_name) values (52 , '墨西哥')     
    140. ;insert into  dim_native_code (nat_id,nat_name) values (53 , '古巴')     
    141. ;insert into  dim_native_code (nat_id,nat_name) values (54 , '阿根廷')     
    142. ;insert into  dim_native_code (nat_id,nat_name) values (55 , '巴西')     
    143. ;insert into  dim_native_code (nat_id,nat_name) values (56 , '智利')     
    144. ;insert into  dim_native_code (nat_id,nat_name) values (57 , '哥伦比亚')     
    145. ;insert into  dim_native_code (nat_id,nat_name) values (58 , '委内瑞拉')     
    146. ;insert into  dim_native_code (nat_id,nat_name) values (591, '玻利维亚')     
    147. ;insert into  dim_native_code (nat_id,nat_name) values (592, '圭亚那')     
    148. ;insert into  dim_native_code (nat_id,nat_name) values (593, '厄瓜多尔')     
    149. ;insert into  dim_native_code (nat_id,nat_name) values (595, '巴拉圭')     
    150. ;insert into  dim_native_code (nat_id,nat_name) values (596, '马提尼克(法)')     
    151. ;insert into  dim_native_code (nat_id,nat_name) values (597, '苏里南')     
    152. ;insert into  dim_native_code (nat_id,nat_name) values (598, '乌拉圭')     
    153. ;insert into  dim_native_code (nat_id,nat_name) values (599, '荷属安的列斯群岛')     
    154. ;insert into  dim_native_code (nat_id,nat_name) values (60 , '马来西亚')     
    155. ;insert into  dim_native_code (nat_id,nat_name) values (61 , '澳大利亚')     
    156. ;insert into  dim_native_code (nat_id,nat_name) values (62 , '印度尼西亚')     
    157. ;insert into  dim_native_code (nat_id,nat_name) values (63 , '菲律宾')     
    158. ;insert into  dim_native_code (nat_id,nat_name) values (64 , '新西兰')     
    159. ;insert into  dim_native_code (nat_id,nat_name) values (65 , '新加坡')     
    160. ;insert into  dim_native_code (nat_id,nat_name) values (66 , '泰国')     
    161. ;insert into  dim_native_code (nat_id,nat_name) values (673, '文莱')     
    162. ;insert into  dim_native_code (nat_id,nat_name) values (675, '巴布亚新几内亚')     
    163. ;insert into  dim_native_code (nat_id,nat_name) values (676, '汤加')     
    164. ;insert into  dim_native_code (nat_id,nat_name) values (679, '斐济')     
    165. ;insert into  dim_native_code (nat_id,nat_name) values (680, '帕劳')     
    166. ;insert into  dim_native_code (nat_id,nat_name) values (687, '新喀里多尼亚')     
    167. ;insert into  dim_native_code (nat_id,nat_name) values (689, '法属波利尼西亚')     
    168. ;insert into  dim_native_code (nat_id,nat_name) values (7  , '俄罗斯')     
    169. ;insert into  dim_native_code (nat_id,nat_name) values (81 , '日本')     
    170. ;insert into  dim_native_code (nat_id,nat_name) values (82 , '韩国')     
    171. ;insert into  dim_native_code (nat_id,nat_name) values (84 , '越南')     
    172. ;insert into  dim_native_code (nat_id,nat_name) values (855, '柬埔寨')     
    173. ;insert into  dim_native_code (nat_id,nat_name) values (856, '老挝')     
    174. ;insert into  dim_native_code (nat_id,nat_name) values (880, '孟加拉国')     
    175. ;insert into  dim_native_code (nat_id,nat_name) values (90 , '土耳其')     
    176. ;insert into  dim_native_code (nat_id,nat_name) values (91 , '印度')     
    177. ;insert into  dim_native_code (nat_id,nat_name) values (92 , '巴基斯坦')     
    178. ;insert into  dim_native_code (nat_id,nat_name) values (93 , '阿富汗')     
    179. ;insert into  dim_native_code (nat_id,nat_name) values (94 , '斯里兰卡')     
    180. ;insert into  dim_native_code (nat_id,nat_name) values (95 , '缅甸')     
    181. ;insert into  dim_native_code (nat_id,nat_name) values (960, '马尔代夫')     
    182. ;insert into  dim_native_code (nat_id,nat_name) values (961, '黎巴嫩')     
    183. ;insert into  dim_native_code (nat_id,nat_name) values (962, '约旦')     
    184. ;insert into  dim_native_code (nat_id,nat_name) values (963, '叙利亚')     
    185. ;insert into  dim_native_code (nat_id,nat_name) values (964, '伊拉克')     
    186. ;insert into  dim_native_code (nat_id,nat_name) values (965, '科威特')     
    187. ;insert into  dim_native_code (nat_id,nat_name) values (966, '沙特阿拉伯')     
    188. ;insert into  dim_native_code (nat_id,nat_name) values (967, '也门')     
    189. ;insert into  dim_native_code (nat_id,nat_name) values (968, '阿曼')     
    190. ;insert into  dim_native_code (nat_id,nat_name) values (970, '巴勒斯坦')     
    191. ;insert into  dim_native_code (nat_id,nat_name) values (971, '阿拉伯联合酋长国')     
    192. ;insert into  dim_native_code (nat_id,nat_name) values (972, '以色列')     
    193. ;insert into  dim_native_code (nat_id,nat_name) values (973, '巴林')     
    194. ;insert into  dim_native_code (nat_id,nat_name) values (974, '卡塔尔')     
    195. ;insert into  dim_native_code (nat_id,nat_name) values (975, '不丹')     
    196. ;insert into  dim_native_code (nat_id,nat_name) values (976, '蒙古')     
    197. ;insert into  dim_native_code (nat_id,nat_name) values (977, '尼泊尔')     
    198. ;insert into  dim_native_code (nat_id,nat_name) values (98 , '伊朗')     
    199. ;insert into  dim_native_code (nat_id,nat_name) values (992, '塔吉克斯坦')     
    200. ;insert into  dim_native_code (nat_id,nat_name) values (993, '土库曼斯坦')     
    201. ;insert into  dim_native_code (nat_id,nat_name) values (994, '阿塞拜疆')     
    202. ;insert into  dim_native_code (nat_id,nat_name) values (995, '格鲁吉亚')     
    203. ;insert into  dim_native_code (nat_id,nat_name) values (996, '吉尔吉斯斯坦')     
    204. ;insert into  dim_native_code (nat_id,nat_name) values (998, '乌兹别克斯坦')     
    205. ;insert into  dim_native_code (nat_id,nat_name) values (380, '乌克兰')     
    206. ;insert into  dim_native_code (nat_id,nat_name) values (381, '塞尔维亚')     
    207. ;insert into  dim_native_code (nat_id,nat_name) values (382, '黑山')     
    208. ;insert into  dim_native_code (nat_id,nat_name) values (385, '克罗地亚')     
    209. ;insert into  dim_native_code (nat_id,nat_name) values (386, '斯洛文尼亚')