Hive视图和索引

1、视图可以是任何结果集的数据，创建一个视图可以方便数据的查询，创建视图的语法如下：
CREATE VIEW [IF NOT EXISTS] view_name [(column_name [COMMENT column_comment],…)]
[COMMENT table_comment] AS SELECT …
创建emp_45000视图，满足salary大于45000的结果集。
CREATE VIEW emp_45000 AS SELECT * FROM emp WHERE salary>45000;
创建视图之后查询视图结果如下：

删除视图：
DROP VIEW emp_45000;

2、索引是在表上特定列创建一个指针，基本语法如下：
CREATE INDEX index_name
ON TABLE base_table_name (col_name, …)
AS ‘index.handler.class.name’
[WITH DEFERRED REBUILD]
[IDXPROPERTIES (property_name=property_value, …)]
[IN TABLE index_table_name]
[PARTITIONED BY (col_name, …)]
[
[ ROW FORMAT …] STORED AS …
| STORED BY …
]
[LOCATION hdfs_path]
[TBLPROPERTIES (…)]

创建名为index_salary的索引：
CREATE INDEX index_salary ON TABLE emp(salary)
AS ‘org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler’
WITH DEFERRED REBUILD;
查看索引：
show index index_salary;

删除索引：
DROP INDEX ON
删除刚刚创建的索引：
DROP INDEX index_salary ON employee;