1.首先创建表create table user( id int, name string, address string)ROW FORMAT DELIMITEDFIELDS TERMINATED BY ','STORED AS TEXTFILE;2.创建索引create index user_index on table user(id)as'org.apache.hadoop.hive.ql.index.compact.CompactIndexHan.
1.首先创建表create table user( id int, name string, address string)ROW FORMAT DELIMITEDFIELDS TERMINATED BY ','STORED AS TEXTFILE;2.创建索引create index user_index on table user(id)as 'org.apache.hadoop.hiv
