大數(shù)據(jù)技術(shù)試驗三

1、大數(shù)據(jù)技術(shù)原理與應(yīng)用實驗報告三題目：熟悉常用的HBase操作:高聰江班級：大數(shù)據(jù)1533學(xué)號：2015005677日期：2017.12.03實驗環(huán)境：筆記本電腦Archlinux虛擬機HadoopHBaseJava3臺2-7-101.1.61-8-0實驗內(nèi)容與完成情況：下載相關(guān)軟件已完成安裝虛擬機已完成配置環(huán)境變量已完成安裝Hadoop已完成安裝HBase已完城出現(xiàn)的問題：01虛擬機運行軟件選擇02虛擬機選擇03虛擬機的分盤出現(xiàn)問題04虛擬機命令不被識別05HBase版本選擇06HBase無法正常啟動解決方案（列出遇到的問題和解決辦法，列出沒有解決的問題）01虛擬機運行軟件選擇02虛擬機選擇0

2、3虛擬機的分盤出現(xiàn)問題04虛擬機命令不被識別05HBase版本選擇06HBase無法正常啟動使用了VirtualBox使用了Archlinux再分了一次，成功解決系統(tǒng)的環(huán)境變量出現(xiàn)問題，修改配置文件解決官所L個版本對照的表，根據(jù)自己的Hadoop版本選擇后兩個設(shè)置沒有進行配置報告正文1 .實驗內(nèi)容與步驟本實驗主要內(nèi)容和步驟如下：1.1. 實驗內(nèi)容< .編程實現(xiàn)以下指定功能，并利用Hadoop提供的HBaseShell命令完成相同的任務(wù).< 1>.列出HBase所有表的相關(guān)信息，如表名創(chuàng)建時間等.< 2>.在終端打印出指定表的所有記錄數(shù)據(jù).< 3>.向已

3、經(jīng)創(chuàng)建好的表添加和刪除指定的列族或列< 4>.清空指定表的所有記錄數(shù)據(jù).< 5>.統(tǒng)計表的行數(shù).1.2. 實驗步驟及實驗結(jié)果1.<1>.列出HBase所有表的相關(guān)信息，如表名創(chuàng)建時間等.hbase(nain):001:0>listTABLEmalestlt23row(s)in0.1900seconds=>males",MtlMt2Mhbase(main):002:Q>q|<2>.在終端打印出指定表的所有記錄數(shù)據(jù)leanatl1ROWCOLUIHtNItCEllrolcoluRn-f1Btipiestamp=Hl2131

4、Z311value=waluel1rewCs)tnsrccwidshb-ase(ntn);MJ:|<3>.向已經(jīng)創(chuàng)建好的表添加和刪除指定的列族或列A>.添加列hbase(Hatni)!:Ml:B*createhsi/stere!afme.)tnMcomk=>Hbase;:Taihle-sihbasefriatft):5&2:listTABLE卜ales£1tl12krw(5>tnQ.azioMxand事L>("Hates"?Wjyput'sr¥1wary1»'score;HMh'

5、;pB9?*erGw(s)tnS.15Z0xsnd*hb>3se(natn)：a&4i：Qi>scan*51'ftGHCOLUFtN+CELLrtarycolumns&coreiMaith,tt5tanpalS14872S4M!96,values1rwC$(nq.qzboseco-n<dsB>.刪除列hba&e(nain):Bi3raw(t)th0.9210delete'si','Maryb,scorerMathseconds與3力'si1COLUMN+CELLsecondshbdsefridLn);OOt

6、i;ROhlBrow(s)in0.0070<4>.清空指定表的所有記錄數(shù)據(jù)tctn"trMWmLUFWHZELLrow)colurRtl=flzcl,*.ttm式-R0=14213il”lJiIrow(i)wliKQfldlhb35e(nsin)rOOR:0>truncatpRtl'Truncating't1table(itnaytakeawhtle);-Disablingtable-，-TruncatingHble0row(s)in35599secondshbasc(noiri):509：e>scan'tl'ROHCOLUMN

7、+CELL0w(4)inQr3230seconds<5>.統(tǒng)計表的行數(shù)hbase(Fiairi):06410*count'tl1row(s)in0.2600seconds->1ht>ase(Fiatn):O65:0>count1120row(s)in.0239seconds->Qhbase(matn):066i0>|2.對指定表進行操作，完成以下功能1>.創(chuàng)建表表StudenthbaseCnain)create'Student*rfS_No1,15_NanerJS_Sex1,1S_AgeGrow(s)in1*4+40Seconds

8、=>HbasettlabYe-Studenthbdse(naln):#02:0>ListTABLEStudentn占Si5row(s)inG-07SOseconds->"Student","nales",'slp,rlMt2'表coursehLdhe(natn)reate'caurse"'Cc1TRcName'F1c_credtt6口in1.2349seconds=>Hbase:TabLe-Coursehba£e(F)atn):oi9：o>listTABLECuur

9、itStudentnaUs51tit26。彳(s)in0.010Gseconds>>"course","Student"nsUs",'sl,'l"tl"tz"LL一_K_Z_J_N,_rrrA11表SChbase(matn):020：e>create1SC*SC_SnohSC_Cno1/SC_Score'6row(s)tn1,2300second£=>HbaseiHable-schbase(nain):02i:0>listTABLECourseSCSt

10、udentmalessitlt21row(s>infl.014aseconds=>'Course','SC","Student"t"nales",'sf,"t1","t2"2插入數(shù)據(jù)Student表第一行hbdehi>Ln);005:4Orow(5)tn31S0hbm“(matn)9row(sJin自hbase(rdLn):005;>9raw<s)LnB.B12OhbdM'(rith)：006：O>0rowtinq.606hbas

11、etr3in):&e7：eRUHsaoiSBO1ENH1row<j)tn0.0270putHStudentsMl*/S_Nd',2&L5M1'second?put1studfrbt1j'seal'/5Nanr1,secondsput1Student',"sCSl1,HS_Sex,rnalestcondsput'studthfj'sest'/sAehpT2iseconds導(dǎo)canTStudent'C0LUMN4CeLIc0lLnn=S_Age:,ttnestanp-lS14ar4H4582Bh

12、vallie=2Jc0luRH*5_NaFe：FtLnestjfip>1514874822132,colun=4_No:atlFi«stanp=lS148748D2234tvalue-201SGOlC0lUHri"S_SeM:,忖3lesecondsStudent表第二行hbase<rtn)；o&&：o>put*Stwdent1p'soe；'/1nrow(s)1n0.014Gsecondsht>asp(n;iln)1009:0?0row(s)InB.0040putTstudpnt'sae?','

13、5_NagH臺ry'secondsht>ds?(natn)：sie：0>put'Student1/5062'/5_Sexrt'fenale'Qrow<5)In曰secondshbase(natn):enput,student'/sM>2,s_A9t,/221flraw(s)tn屯.舊33白secondshtf,ise<ntn):fil?:scan'student"ROHCOLUrtNtCELLseei£Olumn=S_r、i:,tlntstdnp=15li18T48158?e,value=

14、23soei81umn=S二Narwr.CIqestanp=151W4822112*valu?？Zhangsanseeicolunn=$2No:/tlHestanp=1514&78ft2234,value=2®15WHsMicolunn=S_Sex;,tltie£tarip-l514B74B34097,valu=njleseesCOlufln«S_Aj)e：,te£tdHg>"1514B7S0102B2,5flSZCGlunn-S_Ndnt;+tinestdnp-l5l1BT4984759,value-MdrsoezcoXunn-

15、s_No：,tirestanp-151487490T7iz,vdlue-2S150«Z5呢Eelufin=3一5E"口/imtnp=1514BT4磬普Gl,vaiu=feHaleZrow(s)tn0,0170secondsStudent表第三行hbas«(Fitc)010弼”)tne.BS3Sput'Student',飛8肺,'2610003*seconds；hbase(n«ln>：Sl«l：9»putstudent'J的吐J$_NaejLlsl'0row(sin4.095。seconds

16、hb寫wfEmin)r015:0>put1Student'/sO03'.TSSex''Fiale10口wg)in0.0646enc弓h(huán)b<ise(Fain)：aie：0?put1Student,'s6B3*,1S_Age1/24'0ro*f31In0.0036secondshbase(naln):ei7：t)»scan1Etudenr'ROWCOLUHNCELLsoei8luM=S_MU：,tine式anp=15148HB4如2g.Vdlue=23£001colunn=S_Mdne:,ttnetlarip-

17、1514674822132»vdlue=Zhangans&BlcolLRn=SNo：,tlme£tanp_1S14B74flO2234,vaLu2ai50Gl我門COlunn-sZsex：,射4834&97,valuc-flales002coluHnaSAge;,.tinest«np=l514BT501S2fl2,vdlue=Z2SO32rolunn»£_Nnn(?:.ttnetarip«i5i4ST48d7S*value-kjrys&ezslurnih與二崛：，timestanp-1514874967732,

18、vMuIa15白蛇sOS2CQlvnn>S_Sex:,tinestanp-l514874999361,valutrnalrSO03colunn-S_ABe:.tlrestjnct-15HS751207741value-24sas3rolumn=S_Hftne：ftine爺ta，p=15t4B75100911a*mlu呼二Li寫iseemcolunn=s_Ho:(tinestanp=i5i4a75O89036value=；0i5903S033colunn=5Sex:rtinestanp=151487511IfiBOtvalue-wale3row(5JIn0.0370secondsCours

19、e表第一行hbasefmatn):901:0put1Course'/ceei1,'1236019row(s)tn0.2800secondshbase(main):OO3:0>put1Course1/cel1,'C-Name1,'Math0row(s)tnG.&0S0secondshbdse(niatn):004:0>put'Course','c691'1C_CreditT/2.00row(s)in6.9668secondshbase(Tiain):90S70>scan'Course"RO

20、WCOLJMM+CELLC001caldnn=C_Credt:tttnestanp=lS14&755394B9,value=2cBOlcalumn=C_Nane:ttinestanp=l514875S66112,value=NathcOQlcolunn=C_No:,tinestanp=15148754&1619,value=123B611rc?w(s)tn0.0520secondshbd&e(Hdtn):0rcw(s)in巾.333臺hb«&e(n«in):0070rowfs)in0.5S8OhhaRF(rnain):白白Ei：白t6row(

21、s)inC«964dhtjase(natr):065：9>ROWceeicoeicaei“睚cG022rowjs)ine.白15尊Course表第二行：put+Course1/cM2'4C_N0*p12362H古號tundsputbourse1,-,1C_Nane,'ComputerSciencelecondsput'Course'/CM?'/CCrtJit'rcnnd5can(course'COLUHH+CELLcolurin=C_Credtt:FCtestdnp=151487559469,vaTue=2colunn-C

22、_Nane:fllpestdnp=1514675SM112,vdlueKdthCOluin=C_Nc;,tLneLanp=15148754O1019pvalue-123fl&lcolunn=C_Credtt;ptiHe&tdnp«151487569343,valuers.0coltmn-C_Ndnte：ttiFe&tnp-L514B75655195tvalueaCoptiterSctencecolunnCN。：,tlrestanp15W875635325,value123052secondsCourse表第三行：hbase(nain)：ei4:0>Grow(s)in0.00&0hbaseCnainl:015:0>&row(s)tn0.0040hbase(nain):O16:9>6row(s)tnQ.0050put'Course','cOOJ',