hadoop1.0.1下hive0.8.1 的安装及其运行示例(升级版)

在一个版本中没有进行分区和数据插入的相关操作。

1.创建另一张表：

CREATE TABLE IF NOT EXISTS ?people_test2

? ? (

? ? name ? ?STRING,?

? ? age INT,

? ? address STRING

? ? )

? ? PARTITIONED BY (datestr STRING)

? ? ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'

? ? STORED AS TEXTFILE

? ? LOCATION '/user/ganliang/hive_data/people_test2';//这个路径后来改了，因为会覆盖掉/user/ganliang/hive_data

?

2.

INSERT OVERWRITE TABLE people_test2 PARTITION(datestr='20121125')

select * from people_test where address like '湖北%';

?

INSERT OVERWRITE TABLE people_test2 PARTITION(datestr='20121126')

select * from people_test where address ?not like '湖北%';

?

3.试试看

hive> select * from people_test2 where datestr=20121125 and name='ganliang';

Total MapReduce jobs = 1

Launching Job 1 out of 1

Number of reduce tasks is set to 0 since there's no reduce operator

Starting Job = job_201211251920_0005, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201211251920_0005

Kill Command = /home/hadoop/libexec/../bin/hadoop job ?-Dmapred.job.tracker=localhost:9001 -kill job_201211251920_0005

Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0

2012-11-25 20:59:20,828 Stage-1 map = 0%, ?reduce = 0%

2012-11-25 20:59:26,862 Stage-1 map = 100%, ?reduce = 0%, Cumulative CPU 1.58 sec

2012-11-25 20:59:27,867 Stage-1 map = 100%, ?reduce = 0%, Cumulative CPU 1.58 sec

2012-11-25 20:59:28,875 Stage-1 map = 100%, ?reduce = 0%, Cumulative CPU 1.58 sec

2012-11-25 20:59:29,884 Stage-1 map = 100%, ?reduce = 0%, Cumulative CPU 1.58 sec

2012-11-25 20:59:30,897 Stage-1 map = 100%, ?reduce = 0%, Cumulative CPU 1.58 sec

2012-11-25 20:59:31,906 Stage-1 map = 100%, ?reduce = 0%, Cumulative CPU 1.58 sec

2012-11-25 20:59:32,916 Stage-1 map = 100%, ?reduce = 100%, Cumulative CPU 1.58 sec

MapReduce Total cumulative CPU time: 1 seconds 580 msec

Ended Job = job_201211251920_0005

MapReduce Jobs Launched:?

Job 0: Map: 1 ? Accumulative CPU: 1.58 sec ? HDFS Read: 287 HDFS Write: 34 SUCESS

Total MapReduce CPU Time Spent: 1 seconds 580 msec

OK

ganliang25湖北咸宁20121125

Time taken: 19.696 seconds

hive>?