1、hbase新增字段
新增字段
ALTER TABLE LAW.AIRDAY ADD COU_CALC DECIMAL(25);
---此操作默认decimal_digat为0 DECIMAL
(precision,scale) precision 表示精度, 也就是有效数字, 也可以说是整数部分加小数部分的位数; scale 表示保留小数的位数
ALTER TABLE LAW.AIRDAY ADD MONITOR_ZS_AVG_VALUE DECIMAL(25,10);
删除字段(一般都起作用的,万一出现多加个主键的时候,就需要从catalog表里进行del(删除元数据meta表的字段操作))
ALTER TABLE LAW.AIRHOUR DROP COLUMN COU_CALC;
ALTER TABLE LAW.AIRHOUR DROP CONSTRAINT AIRHOUR_PK;
删除表
DELETE from SYSTEM.CATALOG where TABLE_NAME = ‘USER_DETAILS’;
删除meta表里的字段
DELETE from SYSTEM.CATALOG where TABLE_NAME = 'AIRDAY' AND COLUMN_NAME ='MONITOR_ZS_AVG_VALUE' AND TABLE_SCHEM ='LAW';
注意点====表中的列怎么加描述,如果加描述的时候,会多增加一个主键,导致报错
1、修改hbase字段、属性、长度
upsert into SYSTEM.CATALOG (TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,COLUMN_SIZE) values('','LAW','AIRDAY','AVG_FLOW','0',25);
upsert into SYSTEM.CATALOG (TENANT_ID,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,COLUMN_FAMILY,DECIMAL_DIGITS) values('','LAW','AIRDAY','MONITOR_ZS_AVG_VALUE','0',10);
2、修改行数据
upsert into LAW.WATERHOUR (STATION_CODE ,MONITOR_TIME ,POLLUTION_CODE ,STANDARD )
values ('2c95808b73b3c15d0173b73d4e680007','2020080300','011',120);
SELECT * FROM LAW.WATERHOUR WHERE STATION_CODE ='2c95808b73b3c15d0173b73d4e680007' AND MONITOR_TIME ='2020080300' AND POLLUTION_CODE ='011';
upsert into AIR.HOURDATA(MONITOR_TIME,CODE,AREA_NAME,STREET_NAME,
NAME, AREA_CODE, STREET_CODE, STATION_TYPE, CONTROL_LEVEL,
LONGITUDE, LATITUDE, PM25, PM10, O3, SO2, NO2, CO, AQI,
MAIN_FACTOR,QUALITY_LEVEL)
values (#{monitorTime},#{code},#{areaName},#{streetName},#{name},#{areaCode},#{streetCode},#{stationType},
#{controlLevel},#{longitude},#{latitude},#{pm25},#{pm10},#{o3},
#{so2},#{no2},#{co},#{aqi},#{mainFactor},#{qualityLevel})