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

标签：段长度 phoenix COLUMN TR 001 TABLE ORDER NAME

 

登录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);


 
       

标签：段长度,phoenix,COLUMN,TR,001,TABLE,ORDER,NAME
From： https://www.cnblogs.com/star521/p/17005820.html