阿里云支持与服务
2016-12-28
6102浏览量
CREATE TABLE `sls_event` (
`time` int(11) NOT NULL DEFAULT '0',
`event_type` char(32) NOT NULL DEFAULT '',
`event_value` char(128) NOT NULL DEFAULT '',
`value` int(11) DEFAULT NULL,
PRIMARY KEY (`time`,`event_type`,`event_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sls_status` (
`time` int(11) NOT NULL DEFAULT '0',
`event_type` char(32) NOT NULL DEFAULT '',
`event_value` char(128) NOT NULL DEFAULT '',
`value` int(11) DEFAULT NULL,
PRIMARY KEY (`time`,`event_type`,`event_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE STREAM TABLE source_test_sls_galaxy (ip STRING, status INT, request STRING,refer STRING,user_agent STRING )
WITH ( type='loghub', endpoint='http://project_region.log.aliyuncs.com', accessId='!@#$',accessKey='@#$%', projectName='#$$%%', logstore='!@#$%' );
CREATE RESULT TABLE sls_event (
time INT,
event_type STRING,
event_value STRING,
value INT
) WITH (
type='mysql',
url='jdbc:mysql://@#$%:3306/@$$%',
username='@#$%',
password='@#$%',
tableName='sls_event'
);
CREATE RESULT TABLE sls_status (
time INT,
event_type STRING,
event_value STRING,
value INT
) WITH (
type='mysql',
url='jdbc:mysql://@#$%:3306/@$$%',
username='@#$%',
password='@#$%',
tableName='sls_event'
);
-- 3. 定义下计算逻辑
INSERT INTO sls_event select
prop_get('__time__') as time,
'pv' as event_type,
'get' as event_value,
COUNT(1) as value
FROM source_test_sls_galaxy
GROUP BY prop_get('__time__');
INSERT INTO sls_status select
prop_get('__time__') as time,
'status' as event_type,
status as event_value,
COUNT(1) as value
FROM source_test_sls_galaxy
GROUP BY prop_get('__time__'),status;
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
分享阿里云支持与服务团队最佳实践、经典案例与故障排查。