002.phoenix-添加表的索引，并激活索引

查看是否走索引
explain select id,tenant_id  ,orderid,localorderid,item_code  ,item_name  ,weight,quantity,price,total,sku_id,discountprice,payamount  from  ORDER_CENTER.TR_ORDER_ITEM where TENANT_ID='1323998749169585185'  and orderid in ( '1333369613318286427' ) ;


创建索引
1、建全局索引(异步)
--在phoenix数据库执行：
create index IDX_ORDERITEM_ORDERID_02 on ORDER_CENTER.TR_ORDER_ITEM (TENANT_ID,ORDERID,ID,LOCALORDERID,ITEM_TYPE,ITEM_ID,ITEM_CODE,ITEM_NAME,SKU_ID,CATEGORYID,QUANTITY,WEIGHT,PRICE,TOTAL,CREATEDTIME,PAYAMOUNT) async;
2、激活索引(异步)
--在命令行执行：
./hbase org.apache.phoenix.mapreduce.index.IndexTool --schema ORDER_CENTER  --data-table  TR_ORDER_ITEM --index-table IDX_ORDERITEM_ORDERID_01 --output-path IDX_ORDERITEM_ORDERID_01

字段显示完整的列
!set maxwidth 3000

查看所有的表 
!tables

查看表详情 
 !desc  tablename