001.phoenix-修改表的字段长度

 

登录phoenix

cd /usr/hdp/2.6.5.0-292/phoenix/bin

./sqlline-thin.py

查看表结构

!tables

!describe order_center.tr_order

 

查询系统表设置

select TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,COLUMN_SIZE
from SYSTEM.CATALOG where TABLE_SCHEM = 'ORDER_CENTER' and  TABLE_NAME ='TR_ORDER' ;

 ORDER_CENTER  | TR_ORDER    | ORDERCHANNEL                | 0                            | 32           |
 

修改系统表

upsert into SYSTEM.CATALOG (TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,COLUMN_SIZE) values('','ORDER_CENTER','TR_ORDER','ORDERCHANNEL','0',64);