開放數(shù)據(jù)處理服務(wù)ODPS學(xué)生實(shí)驗(yàn)手冊(cè)5

開放數(shù)據(jù)辦理服務(wù)ODPS學(xué)生實(shí)驗(yàn)手冊(cè)Copyright?2014，阿里巴巴版權(quán)全部目錄一、實(shí)驗(yàn)準(zhǔn)備21.1實(shí)驗(yàn)?zāi)康?1.2實(shí)驗(yàn)環(huán)境準(zhǔn)備2二、實(shí)驗(yàn)內(nèi)容22.1實(shí)驗(yàn)1盤問(wèn)數(shù)據(jù)22.2實(shí)驗(yàn)2覆蓋更新32.3實(shí)驗(yàn)3追加更新3三、實(shí)驗(yàn)小結(jié)33.1實(shí)驗(yàn)1盤問(wèn)數(shù)據(jù)33.2實(shí)驗(yàn)2覆蓋更新33.3實(shí)驗(yàn)3追加更新4阿里云上云培訓(xùn)一、實(shí)驗(yàn)準(zhǔn)備1.1實(shí)驗(yàn)?zāi)康哪軌蚴炀毷褂每蛻舳瞬僮鱋DPS數(shù)據(jù),包括盤問(wèn)、增加、更新。1.2實(shí)驗(yàn)環(huán)境準(zhǔn)備1，已經(jīng)開通開放數(shù)據(jù)辦理服務(wù)ODPS2,已經(jīng)安裝部署ODPS客戶端3,經(jīng)過(guò)ODPS客戶端連接到項(xiàng)目二、實(shí)驗(yàn)內(nèi)容2.1實(shí)驗(yàn)1盤問(wèn)數(shù)據(jù)步驟一:創(chuàng)辦表createtablet_people(idint,namestring);步驟二:導(dǎo)入數(shù)據(jù)tunneluploadE:\aliyun\ODPS-test\people.csvt_peple;重復(fù)執(zhí)行一次步驟三:盤問(wèn)全部數(shù)據(jù)select*fromt_people;步驟四:使用groupby盤問(wèn),selectcount(*)fromt_peoplegroupbyidhavingcount(*)>0;將執(zhí)行結(jié)果截屏填入實(shí)驗(yàn)小結(jié)步驟五:使用join盤問(wèn),selectt1.*fromt_peoplet1joint_peoplet2ont1.id=t2.id;將執(zhí)行結(jié)果截屏填入實(shí)驗(yàn)小結(jié)ODPS2阿里云上云培訓(xùn)2.2實(shí)驗(yàn)2追加更新步驟一:創(chuàng)辦表createtablet_people_new(idint,namestring);步驟二:導(dǎo)入數(shù)據(jù)tunneluploadE:\aliyun\ODPS-test\men.csvt_people_new;步驟三:查察數(shù)據(jù)readt_people_new;步驟四:追加更新數(shù)據(jù)insertintotablet_peopleselect*fromt_people_new;步驟五:查察數(shù)據(jù)readt_people;將執(zhí)行結(jié)果截屏填入實(shí)驗(yàn)小結(jié)2.3實(shí)驗(yàn)3覆蓋更新步驟一:追加更新數(shù)據(jù)insertoverwritetablet_peopleselect*fromt_people_new;步驟二：查察數(shù)據(jù)readt_people;將執(zhí)行結(jié)果截屏填入實(shí)驗(yàn)小結(jié)三、實(shí)驗(yàn)小結(jié)3.1實(shí)驗(yàn)1盤問(wèn)數(shù)據(jù)<此處可填寫你實(shí)驗(yàn)過(guò)程中遇到的問(wèn)題、解決過(guò)程以及實(shí)驗(yàn)結(jié)果>3.2實(shí)驗(yàn)2追加更新<此處可填寫你實(shí)驗(yàn)過(guò)程中遇到的問(wèn)題、解決過(guò)程以及實(shí)驗(yàn)結(jié)果>ODP