1,创建本地索引 create local index "IDX_E_voucher_union" on "Fvr_voucher"("cf"."fowner","cf"."fdate");
2. 创建全局索引 create index "IDX_E_voucher_union" on "Fvr_voucher"("cf"."fowner","cf"."fdate");
3.查看索引表 !tables
4.删除表 drop index "IDX_E_voucher_union" on "Fvr_voucher";
1.查HBase索引:
list
2。使Hbase索引失效:
disable "_LOCAL_IDX_E_voucher_union"
3.删除HBase索引:
drop "_LOCAL_IDX_E_voucher_union"
查询是否使用索引
EXPLAIN SELECT * FROM "Fvr_voucher" WHERE "fowner"='1' LIMIT 15
查询结果:
CLIENT 3-CHUNK PARALLEL 1-WAY FULL SCAN OVER Fvr_voucher (全部扫描,未使用索引)
CLIENT 3-CHUNK SERIAL 3-WAY RANGE SCAN OVER _LOCAL_IDX_E_voucher_union [-32764,1,'1'] (部分扫描,使用索引)