hive导入数据

数据格式：

0 36167989451 马六 男 吉林 1854 6
1 37652086059 万五 男 湖北 1854 8
2 91948962006 高二 女 云南 1854 8
3 33953116795 段六 男 河北 1854 3
4 79358017862 郝九 女 宁夏 1854 2
5 08179033942 傅三 男 澳门 1854 6
6 23034620756 洪四 女 西藏 1854 4
7 92810331548 侯十 女 上海 1854 1
8 31618771379 戴二 男 江苏 3796 2
9 84604372530 雷十 女 陕西 1854 9
10 69195479872 廖八 男 山西 1854 3
11 05741805802 肖九 女 湖北 1854 1
12 15905291952 陆六 女 香港 1854 7

社区图的数据格式

（ 社区，社区边|社区边| ……   

　　9821,64110|103598|64110|103600|…… ）：

9820,62744|62745|62745|36690|62745|10882|62745|64107|62745|64109|36690|64107|10882|64107|10882|117007|10882|64109|64107|64109
9821,64110|103598|64110|103600
9822,64115|64116|64116|268163
9823,64118|64119|64118|64120|64118|64121|64119|64120|64119|64121|64120|64121
9824,64122|64123|64122|64124|64123|64124|64123|128721
9825,64125|64126
9826,49561|64127|49561|64128|49561|64129|64127|64128|64127|64129|64128|64129
9827,64132|64133|64132|64134|64133|64134
9828,64130|64137|64130|232545
9829,64153|293303|64153|293304
983,6481|208452|6481|6485|6481|6488|6481|72471|6481|6489|6481|208453
9830,131575|64154
9831,23326|64142|23326|36058|23326|64144|23326|35350|23326|64145|23326|64146|23326|64147|23326|64148|23326|64149|23326|7473|23326|64151|23326|64152|23326|64155|23326|64156|23326|64157|23326|64158|23326|64159|23326|64160|36058|64146|36058|64147|36058|64148|36058|64149|36058|7473|36058|64151|36058|64152|36058|74025|36058|74033|36058|64155|36058|64156|36058|64157|36058|64158|36058|64159|36058|64160|64146|64147|64146|64148|64146|64149|64146|7473|64146|64151|64146|64152|64146|74025|64146|64155|64146|64156|64146|64157|64146|64158|64146|64159|64146|64160|64147|64148|64147|64149|64147|7473|64147|64151|64147|64152|64147|64155|64147|64156|64147|64157|64147|64158|64147|64159|64147|64160|64148|64149|64148|7473|64148|64151|64148|64152|64148|219186|64148|64155|64148|64156|64148|64157|64148|64158|64148|64159|64148|64160|64149|7473|64149|64151|64149|64152|64149|230172|64149|64155|64149|64156|64149|64157|64149|64158|64149|64159|64149|230173|64149|64160|7473|64151|7473|64152|7473|243507|7473|64155|7473|64156|7473|64157|7473|64158|7473|64159|7473|64160|64151|64152|64151|64155|64151|64156|64151|64157|64151|64158|64151|64159|64151|64160|64152|64155|64152|64156|64152|64157|64152|64158|64152|64159|64152|64160|230172|64155|64155|64156|64155|64157|64155|64158|64155|64159|64155|64160|64156|64157|64156|64158|64156|64159|64156|64160|64157|64158|64157|64159|64157|64160|64158|64159|64158|64160|64159|64160
9832,64161|64162|64161|64164|64161|64167|64162|64164
9833,64165|157788|64165|157791|64165|193114|157788|157789|157788|157791
9834,64168|167125|64168|167128|64168|276824|64168|167129
9835,64171|64172
9836,19102|64170|19102|64175|19102|64177|19102|64178|19102|64180|19102|64182|19102|64183|64182|64183
9837,56356|64184|56356|64185|56356|64186|56356|64187|56356|22616|64185|64186|64185|64187|64185|22616|64186|64187|64186|22616|64187|22616

创建数据库：

  　load data local inpath '/home/hadoop/data_example_to_qiaokai-utf8.txt' into table node;

　　load data local inpath '/home/hadoop/tran.txt' into table community;

 

create table node(nodeid int,phonenum string,name string,sex string,province string,communityid int,emergy int)ROW FORMAT DELIMITED FIELDS TERMINATED BY  ' ' STORED AS TEXTFILE;

　　//创建一个复杂数据类型的文件
　　create table community(cid int,range array<int>)ROW FORMAT DELIMITED FIELDS TERMINATED BY ','COLLECTION ITEMS TERMINATED BY '|'STORED AS TEXTFILE;

加载数据：