教程:从OBS导入数据到集群 本章节主要介绍从OBS导入数据到集群的最佳实践。 教程指引 说明 l ACCESSKEY和SECRETACCESSKEY 用户访问OBS的AK和SK,请根据实际替换。获取访问密钥的具体步骤,请参见“ Key ID(AK)和 Secret Access Key(SK)” 本教程旨在通过演示将样例数据上传OBS,及将OBS的数据导入进DWS上的目标表中,让您快速掌握如何从OBS导入数据到DWS集群的完整过程。 在本教程中,您将: 生成CSV格式的数据文件。 创建一个与DWS集群在同一区域的OBS存储桶,然后将数据文件上传到该存储桶。 创建外表,用于引流OBS存储桶中的数据到DWS集群。 启动DWS并创建数据库表后,将OBS上的数据导入到表中。 根据错误表中的提示诊断加载错误并更正这些错误。 估计时间:30分钟 准备数据源文件 数据文件“productinfo0.csv” 100,XHDKA,20170901,A,2017 Shirt Women,red,M,328,20170904,715,good! 205,KDKEB,20170901,A,2017 Tshirt Women,pink,L,584,20170905,40,very good! 300,JODLX,20170901,A,2017 Tshirt men,red,XL,15,20170903,502,Bad. 310,QQPXR,20170902,B,2017 jacket women,red,L,411,20170905,436,It's nice. 150,ABEFC,20170903,B,2017 Jeans Women,blue,M,123,20170906,120,good. 数据文件“productinfo1.csv” 200,BCQPE,20170904,B,2017 casual pants men,black,L,997,20170910,301,good quality. 250,EABED,20170910,A,2017 dress women,black,S,841,20170915,299,This dress fits well. 108,CDXKF,20170911,A,2017 dress women,red,M,85,20170914,22,It's really amazing to buy. 450,MMCEH,20170911,A,2017 jacket women,white,M,114,20170914,22,very good. 260,OCDAG,20170912,B,2017 woolen coat women,red,L,2004,20170915,826,Very comfortable. 数据文件“productinfo2.csv” 980,"ZKDSJ",20170913,"B","2017 Women's Cotton Clothing","red","M",112,,, 98,"FKQBI",20170915,"B","2017 new shoes men","red","M",4345,20170918,5473 50,"DMQYK",20170921,"A","2017 pants men","red","37",28,20170925,58,"good","good","good" 80,"GKLWl",20170922,"A","2017 Jeans Men","red","39",58,20170925,72,"Very comfortable." 30,"HWECL",20170923,"A","2017 shoes women","red","M",403,20170926,607,"good!" 40,"IQPDM",20170924,"B","2017 new pants Women","red","M",35,20170927,52,"very good." 50,"LPECN",20170925,"B","2017 dress Women","red","M",29,20170928,47,"not good at all." 60,"NQABO",20170926,"B","2017 jacket women","red","S",69,20170929,70,"It's beautiful." 70,"HWNBP",20170927,"B","2017 jacket women","red","L",30,20170930,55,"I like it so much" 80,"JKHUQ",20170929,"C","2017 Tshirt","red","M",90,20171002,82,"very good." 1.新建文本文档并使用本地编辑工具(例如Visual Studio Code)打开后,将示例数据拷贝进文本文档中。 2.选择“格式>以UTF8无BOM格式编码”。 3.选择“文件>另存为”。 4.在弹出的对话框中输入文件名后,将文件后缀设为.csv,单击“保存”。