hive创标_Hive创建索引

索引是标准的数据库技术，hive 0.7版本之后支持索引。1、先创建表： hive> create table user( id int, name string)

> ROW FORMAT DELIMITED

> FIELDS TERMINATED BY '\t'

> STORED AS TEXTFILE;

2、导入数据： hive> load data local inpath '/export1/tmp/wyp/row.txt'

> overwrite into table user;

3、创建索引之前测试 hive> select * from user where id =500000;

Total MapReduce jobs = 1

Launching Job 1 out of 1

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

Cannot run job locally: Input Size (= 356888890) is larger than

hive.exec.mode.local.auto.inputbytes.max (= 134217728)

Starting Job = job_1384246387966_0247, Tracking URL =

http://l-datalogm1.data.cn1:9981/proxy/application_1384246387966_0247/

Kill Command=/home/q/hadoop/bin/hadoop job -kill job_1384246387966_0247

Had