教程:使用GDS从远端服务器导入数据 下载GDS工具包 1.登录DWS管理控制台。 2.在左侧导航栏中,单击“连接管理”。 3.在“gsql命令行客户端”的下拉列表中,选择对应版本的DWS 客户端。 请根据集群版本和安装客户端的操作系统,选择对应版本。 4. 单击“下载”。 准备数据源文件 数据文件“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,单击“保存”。 5.以root用户登录GDS服务器。 6.创建数据文件存放目录“/inputdata”。 mkdir p /inputdata 7.使用MobaXterm将数据源文件上传至上一步所创建的目录中。