flink 实时计算案例一

–
create table xxxx
(
log_time bigint
,ord_id bigint
,biz_type int
,status int
,city_id int
,city_name varchar
,start_charge_time timestamp(3)
,end_charge_time timestamp(3)
,cancel_source varchar
,car_type int
,risk_type int
,is_normal int
,call_time string
,ansr_time timestamp(3)
,finish_time timestamp(3)
,cancel_time timestamp(3)
,start_lat varchar
,start_lng varchar
,gmt_create varchar
,gmt_modify varchar
,start_charge_lat double
,start_charge_lng double
,end_charge_lat double
,end_charge_lng double
,start_inside_mid_sh int
,end_inside_mid_sh int
,time_pt as CAST(TO_TIMESTAMP(log_time) as TIMESTAMP(3))
,WATERMARK FOR time_pt AS time_pt - INTERVAL ‘60’ SECOND
)