1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| 示例: create streaming iis_tj (date,time,s_sitename,s_computername,s_ip,cs_method,cs_uri_stem,cs_uri_query,s_port,cs_username,c_ip,cs_version,cs_user_agent,cs_cookie_,cs_referer,cs_host,sc_status,sc_substatus,sc_win32_status,sc_bytes,cs_bytes,time_taken) seprator as ' ';
insert into dmo:rt_web_resourcelog
select 'm10' as _, year(GMT_TIMEZONE,date+' '+time) as year, month(GMT_TIMEZONE,date+' '+time) as month, day(GMT_TIMEZONE,date+' '+time) as day, hour(GMT_TIMEZONE,date+' '+time) as hour, minute_window(GMT_TIMEZONE,date+' '+time,5) as minute, map_val(str_to_map(cs_uri_query,'&'),'ch') as appname, map_val(str_to_map(cs_uri_query,'&'),'pt') as page_type, map_val(str_to_map(cs_uri_query,'&'),'p75') as re_initiatorType, sum(map_val(str_to_map(cs_uri_query,'&'),'p73')) as sum_duration from iis_tj where "当前五分钟" group by year,month,day,hour,minute,appname,page_type,re_initiatorType;
|