create database skewtest
Go
use skewtest
Go
create table skew (id bigint, acct string) skewed by (acct) on ('CC','CH')
Go
create index skew_indx on table skew (id) as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD
Go


CREATE VIEW `skewview2`
AS 
SELECT * FROM skew
Go

show create table skew 
Go

show create table skewview2 
Go