create table TBL_FACT_SYMBIAN_PACKET(PROVICE_FK INT,DATE_FK INT,MODEL_FK INT,COUNTRY_FK INT,NETWORK_FK INT,OSLAG_FK INT,OS_FK INT,NQ_SOFTWARE_VER INT,SUBCOOP_FK INT,NQ_SOFTWARE_TYPE_FK INT,SCANTYPE_FK INT,SCANID STRING,NAME STRING,SECURITY STRING,CA_ISSUER STRING,CA_SUBJECT STRING,HAS_NOTE STRING,VIRUS_NAME STRING
)partitioned BY(dt STRING) row format delimited fields terminated by '\t'
STORED AS textfile
load data local inpath '/home/boss/symbian_pkgs_20110529.log.hive' overwrite into table TBL_FACT_SYMBIAN_PACKET partition(dt='2011-05-29');
1 创建索引
create index index_model_fk on table TBL_FACT_SYMBIAN_PACKET(model_fk) AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD ;
2. 更新数据
ALTER INDEX index_model_fk ON TBL_FACT_SYMBIAN_PACKET REBUILD;
3. 删除索引
drop index index_model_fk on tbl_fact_symbian_packet;
4. 查看索引
show index on tbl_fact_symbian_packet;
)partitioned BY(dt STRING) row format delimited fields terminated by '\t'
STORED AS textfile
load data local inpath '/home/boss/symbian_pkgs_20110529.log.hive' overwrite into table TBL_FACT_SYMBIAN_PACKET partition(dt='2011-05-29');
1 创建索引
create index index_model_fk on table TBL_FACT_SYMBIAN_PACKET(model_fk) AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD ;
2. 更新数据
ALTER INDEX index_model_fk ON TBL_FACT_SYMBIAN_PACKET REBUILD;
3. 删除索引
drop index index_model_fk on tbl_fact_symbian_packet;
4. 查看索引
show index on tbl_fact_symbian_packet;