(7-10)hive表视图、索引

最新推荐文章于 2023-02-25 21:29:01 发布

礼彬fly

最新推荐文章于 2023-02-25 21:29:01 发布

阅读量756

点赞数

分类专栏： Bigdatda-Hive 文章标签： 7-10hive表视图索引

本文链接：https://blog.csdn.net/baolibin528/article/details/45374285

版权

Bigdatda-Hive 专栏收录该内容

43 篇文章 0 订阅

订阅专栏

(7-10)hive表视图、索引

------------------------------------视图------------------------------------

//创建视图
hive> create view viem_table AS select t2.name from t2;
OK
Time taken: 1.556 seconds

//查看视图
hive> show tables;
OK
bucket_table
t1
t2
viem_table
Time taken: 0.199 seconds, Fetched: 4 row(s)
hive>

//删除视图
hive> drop view view_table;
OK
Time taken: 0.084 seconds
hive>



-----------------------------------索引----------------------------------------

//对t2表创建索引
hive> create index t2_index on table t2(name)as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' with deferred rebuild in table t2_index_table;
OK
Time taken: 4.319 seconds

//查看索引表
hive> show tables;
OK
bucket_table
t1
t2
t2_index_table
viem_table
Time taken: 0.053 seconds, Fetched: 5 row(s)
hive>


//重建索引，会跑一个mapreduce。
hive> alter index t2_index on t2 rebuild;
Query ID = root_20150429183939_1129195a-d5f8-4f83-a40b-a6dcdf173908
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks not specified. Estimated from input data size: 1
In 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_1430296708269_0002, Tracking URL = http://baozi:8088/proxy/application_1430296708269_0002/
Kill Command = /usr/local/hadoop/bin/hadoop job  -kill job_1430296708269_0002
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2015-04-29 18:39:45,924 Stage-1 map = 0%,  reduce = 0%
2015-04-29 18:40:47,044 Stage-1 map = 0%,  reduce = 0%
2015-04-29 18:40:50,732 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.42 sec
2015-04-29 18:41:46,749 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 5.78 sec
MapReduce Total cumulative CPU time: 5 seconds 780 msec
Ended Job = job_1430296708269_0002
Loading data to table default.t2_index_table partition (class=job1, city=bj)
Partition default.t2_index_table{class=job1, city=bj} stats: [numFiles=1, numRows=7, totalSize=557, rawDataSize=550]
MapReduce Jobs Launched:
Stage-Stage-1: Map: 1  Reduce: 1   Cumulative CPU: 5.78 sec   HDFS Read: 282 HDFS Write: 655 SUCCESS
Total MapReduce CPU Time Spent: 5 seconds 780 msec
OK
Time taken: 167.939 seconds
hive>


//查看t2表的索引
hive> show formatted index on t2;
OK
idx_name                tab_name                col_names               idx_tab_name            idx_type                comment       


t2_index                t2                      name                    t2_index_table          compact
Time taken: 0.242 seconds, Fetched: 4 row(s)


//删除索引
hive> drop index t2_index on t2;
OK
Time taken: 6.176 seconds
hive>