大数据技术试验三

1、大数据技术原理与应用实验报告三题目：熟悉常用的HBase操作:高聪江班级：大数据1533学号：2015005677日期：2017.12.03实验环境：笔记本电脑Archlinux虚拟机HadoopHBaseJava3台2-7-101.1.61-8-0实验内容与完成情况：下载相关软件已完成安装虚拟机已完成配置环境变量已完成安装Hadoop已完成安装HBase已完城出现的问题：01虚拟机运行软件选择02虚拟机选择03虚拟机的分盘出现问题04虚拟机命令不被识别05HBase版本选择06HBase无法正常启动解决方案（列出遇到的问题和解决办法，列出没有解决的问题）01虚拟机运行软件选择02虚拟机选择0

2、3虚拟机的分盘出现问题04虚拟机命令不被识别05HBase版本选择06HBase无法正常启动使用了VirtualBox使用了Archlinux再分了一次，成功解决系统的环境变量出现问题，修改配置文件解决官所L个版本对照的表，根据自己的Hadoop版本选择后两个设置没有进行配置报告正文1 .实验内容与步骤本实验主要内容和步骤如下：1.1. 实验内容< .编程实现以下指定功能，并利用Hadoop提供的HBaseShell命令完成相同的任务.< 1>.列出HBase所有表的相关信息，如表名创建时间等.< 2>.在终端打印出指定表的所有记录数据.< 3>.向已

3、经创建好的表添加和删除指定的列族或列< 4>.清空指定表的所有记录数据.< 5>.统计表的行数.1.2. 实验步骤及实验结果1.<1>.列出HBase所有表的相关信息，如表名创建时间等.hbase(nain):001:0>listTABLEmalestlt23row(s)in0.1900seconds=>males",MtlMt2Mhbase(main):002:Q>q|<2>.在终端打印出指定表的所有记录数据leanatl1ROWCOLUIHtNItCEllrolcoluRn-f1Btipiestamp=Hl2131

4、Z311value=waluel1rewCs)tnsrccwidshb-ase(ntn);MJ:|<3>.向已经创建好的表添加和删除指定的列族或列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>.清空指定表的所有记录数据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>.统计表的行数hbase(Fiairi):06410*count'tl1row(s)in0.2600seconds->1ht>ase(Fiatn):O65:0>count1120row(s)in.0239seconds->Qhbase(matn):066i0>|2.对指定表进行操作，完成以下功能1>.创建表表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插入数据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导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弓hb<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',