MapReduce服务 MRS-加载数据到Hive表中:样例数据

时间：2025-02-12 14:58:47

MapReduce服务 MRS

样例数据

表employees_info的数据如下：

1,Wang,R,8000.01,person&personal^Btype&income^Btax&0.05,Country1:City1,20143,Tom,D,12000.02,person&personal^Btype&income^Btax&0.09,Country2:City2,20144,Jack,D,24000.03,person&personal^Btype&income^Btax&0.05,Country3:City3,20146,Linda,D,36000.04,person&personal^Btype&income^Btax&0.05,Country4:City4,20148,Zhang,R,9000.05,person&personal^Btype&income^Btax&0.05,Country5:City5,2014

表employees_contact的数据如下：

1,135 XXXX XXXX,xxxx@xx.com3,159 XXXX XXXX,xxxxx@xx.com.cn4,186 XXXX XXXX,xxxx@xx.org6,189 XXXX XXXX,xxxx@xxx.cn8,134 XXXX XXXX,xxxx@xxxx.cn

表employees_info_extended的数据如下：

1,Wang,135 XXXX XXXX,xxxx@xx.com,R,8000.01,person&personal^Btype&income^Btax&0.05,Country1:City1,20143,Tom,159 XXXX XXXX,xxxxx@xx.com.cn,D,12000.02,person&personal^Btype&income^Btax&0.09,Country2:City2,20144,Jack,186 XXXX XXXX,xxxx@xx.org,D,24000.03,person&personal^Btype&income^Btax&0.05,Country3:City3,20146,Linda,189 XXXX XXXX,xxxx@xxx.cn,D,36000.04,person&personal^Btype&income^Btax&0.05,Country4:City4,20148,Zhang,134 XXXX XXXX,xxxx@xxxx.cn,R,9000.05,person&personal^Btype&income^Btax&0.05,Country5:City5,2014

上一篇：MapReduce服务 MRS-加载数据到Hive表中:样例代码

下一篇：MapReduce服务 MRS-配置Hive Python3样例工程:操作步骤