爱华网afan@ubuntu:/usr/local/hadoop/hive$ cat test.txt
12,23,23,34what,are,this
34,45,34,23,12who,am,i,are
afan@ubuntu:/usr/local/hadoop/hive$ hive
Hive historyfile=/tmp/afan/hive_job_log_afan_201105240353_929616223.txt
hive> drop table t_afan_test;
OK
Time taken: 3.288 seconds
hive> create table t_afan_test
> (
> info1array<int>,
> info2array<string>
> )
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY 't'
> COLLECTION ITEMS TERMINATED BY ','
> ;
OK
Time taken: 0.58 seconds
hive> LOAD DATA LOCAL INPATH 'test.txt' OVERWRITEINTO TABLE t_afan_test;
Copying data from file:/usr/local/hadoop/hive/test.txt
Copying file: file:/usr/local/hadoop/hive/test.txt
Loading data to table default.t_afan_test
Deleted hdfs://localhost:9000/user/hive/warehouse/t_afan_test
OK
Time taken: 0.742 seconds
hive> select * from t_afan_test;
OK
[12,23,23,34]["what","are","this"]
[34,45,34,23,12]["who","am","i","are"]
Time taken: 0.429 seconds
hive> select size(info1), size(info2) fromt_afan_test;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduceoperator
Starting Job = job_201105240347_0001, Tracking URL =http://localhost:50030/jobdetails.jsp?jobid=job_201105240347_0001
Kill Command = /usr/local/hadoop/bin/../bin/hadoopjob -Dmapred.job.tracker=localhost:9001 -killjob_201105240347_0001
2011-05-24 03:55:49,564 Stage-1 map = 0%, reduce= 0%
2011-05-24 03:55:52,597 Stage-1 map = 50%, reduce= 0%
2011-05-24 03:55:55,653 Stage-1 map = 100%,reduce = 0%
Ended Job = job_201105240347_0001
OK
4 3
5 4
Time taken: 20.171 seconds
hive> select info1[2], info2[0] fromt_afan_test;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduceoperator
Starting Job = job_201105240347_0002, Tracking URL =http://localhost:50030/jobdetails.jsp?jobid=job_201105240347_0002
Kill Command = /usr/local/hadoop/bin/../bin/hadoopjob -Dmapred.job.tracker=localhost:9001 -killjob_201105240347_0002
2011-05-24 03:56:37,513 Stage-1 map = 0%, reduce= 0%
2011-05-24 03:56:40,543 Stage-1 map = 100%,reduce = 0%
2011-05-24 03:56:43,611 Stage-1 map = 100%,reduce = 100%
Ended Job = job_201105240347_0002
OK
23 what
34 who
Time taken: 10.88 seconds
