hive> create index [index_studentid] on table student_3(studentid)> as ‘org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler‘> with deferred rebuild> IN TABLE index_table_student_3;OKTime taken: 12.219 secondshive>

hive> alter index index_studentid on student_3 rebuild;WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. tez, spark) or using Hive 1.X releases.Query ID = root_20161226235345_5b3fcc2b-7f90-4b10-861f-31cbaed8eb73Total jobs = 1Launching Job 1 out of 1Number of reduce tasks not specified. Estimated from input data size: 1In order to change the average load for a reducer (in bytes):set hive.exec.reducers.bytes.per.reducer=<number>In order to limit the maximum number of reducers:set hive.exec.reducers.max=<number>In order to set a constant number of reducers:set mapreduce.job.reduces=<number>Starting Job = job_1482824475750_0001, Tracking URL = http://hadoop-node4.com:8088/proxy/application_1482824475750_0001/Kill Command = /usr/local/development/hadoop-2.6.4/bin/hadoop job -kill job_1482824475750_0001Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 12016-12-26 23:55:40,317 Stage-1 map = 0%, reduce = 0%2016-12-26 23:56:40,757 Stage-1 map = 0%, reduce = 0%2016-12-26 23:56:48,768 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 2.08 sec2016-12-26 23:57:34,981 Stage-1 map = 100%, reduce = 67%, Cumulative CPU 3.66 sec2016-12-26 23:57:40,716 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 4.68 secMapReduce Total cumulative CPU time: 4 seconds 680 msecEnded Job = job_1482824475750_0001Loading data to table default.index_table_student_3MapReduce Jobs Launched:Stage-Stage-1: Map: 1 Reduce: 1 Cumulative CPU: 4.68 sec HDFS Read: 10282 HDFS Write: 537 SUCCESSTotal MapReduce CPU Time Spent: 4 seconds 680 msecOKTime taken: 280.693 seconds

hive> select*from index_table_student_3;OK1 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/student_3/sutdent.txt [0]2 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/student_3/sutdent.txt [28]3 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/student_3/sutdent.txt [56]4 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/student_3/sutdent.txt [85]5 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/student_3/sutdent.txt [113]6 hdfs://hadoop-node4.com:8020/opt/hive/warehouse/student_3/sutdent.txt [143]Time taken: 2.055 seconds, Fetched: 6 row(s)hive>