字符提取函数 get_json_object 、regexp_replace、add_months ；表字段update

• 1.Json 的支付提取

```sql
SELECT *,get_json_object(label_value_text,'$.BUS') as a
FROM sharein_di.edw_di_dna_user_label_1084
where get_json_object(label_value_text,'$.BUS') is not null
LIMIT 10000

 - 2.找主键

SELECT COUNT(distinct order_number),COUNT(1), COUNT(distinct id),count(insurance_ticket_id)
FROM dw_busdb.tbl_order_insurance
WHERE d = '2019-06-10'

 - 3.建表之后插入新字段

alter table report_cardb.report_isd_app_airport_process_monitor add columns (vid string comment '供应商ID')

 - 4、改变字段类型

ALTER TABLE source_cardb.sd_order_refund_bill_map CHANGE billno  billno  String;

 - 5、环比，获取去年日期

select add_months(now(),-12)

 - 6、字符串替换

select  regexp_replace('rdfghjgff_desk_dfghjk', '_desk', 'AAAAA')