容器服务
eventId.metadata.namespace"as namespace,"eventId.involvedObject.name"as node_name,COUNT(*)as cnt from log GROUP by namespace,node_name 有数据匹配，cnt>0 标签自定义：namespace、node_name sls_app_ack_ccm_at_del_slb_fail ...
GetSkillGroupStatusTotal-获取热线报表下技能组状态...
{"minute_id":"-1","call_out_intervene_servicer_cnt":26,"call_out_servicer_cnt":35,"call_out_intervene_60s_cnt":155,"servicer_real_name":"-","call_in_sep_normal_cnt":0,"call_out_intervene_30s_cnt":235,"servicer_id":"-1",...
GetOnlineServiceVolume-获取在线监控下在线服务量
ready_cnt：直连 60s 接起量 online_60s_transfer_ready_cnt：转交 60s 接起量 online_over_out_cnt：技能组溢出量 online_over_in_cnt：技能组溢入量 online_sat_cnt：满意数 online_normal_cnt：一般数 online_unsat_cnt：不满意数 ...
零售电商数据建模
DataWorks智能数据建模产品内置了零售电子商务数据仓库行业模型模板，您可以一键导入模板，本文结合零售电子商务业务背景以及模型构建核心步骤来帮助您了解维度建模理论和智能数据建模产品。重要 DataWorks智能数据建模个人版6个月60元，...
DescribeAttackAnalysisData-查询攻击分析的数据
578},{\"crack_hour\":1662512400000,\"crack_cnt\":577},{\"crack_hour\":1662516000000,\"crack_cnt\":616},{\"crack_hour\":1662519600000,\"crack_cnt\":597},{\"crack_hour\":1662523200000,\"crack_cnt\":575},{\"crack_hour\":...
GetSkillGroupServiceStatus-获取在线报表下技能组...
10s_transfer_ready_cnt：10 秒接起量（转入）online_20s_direct_ready_cnt：20 秒接起量（直连）online_20s_transfer_ready_cnt：20 秒接起量（转入）online_30s_direct_ready_cnt：30 秒接起量（直连）online_30s_transfer_ready_cnt：30...
GetAgentServiceStatus-获取在线报表下坐席服务状态量
name：租户名称 online_direct_ready_cnt：用户直接接起的服务量（直连）online_transfer_ready_cnt：被转入的用户接起服务量 online_transfer_in_give_up_cnt：转交后用户放弃量（未接起量）online_transfer_out_cnt：转出的总量（建议...
FeatureStore Java SDK
cnt":0,"follow_cnt":8,"follower_cnt":0,"register_time":1695618449,"tags":"1",} {"user_id":100006646,"gender":"male","age":28,"city":"长春市""item_cnt":0,"follow_cnt":1,"follower_cnt":1,"register_time":1698213339,"tags":"1...
事件数据（Event）
raw_results":[{"cnt":"49","request_method":"GET"},{"cnt":"3","request_method":"DELETE"},{"cnt":"7","request_method":"POST"},{"cnt":"6","request_method":"PUT"}],"raw_result_count":4,"truncated":false,"dashboard_id":"",...
GetAgentDetailReport-获取热线报表下热线坐席详情...
sep_normal_cnt：呼出-热线评价一般量 call_out_sep_unsat_cnt：呼出-热线评价不满意量 call_out_unsep_cnt：呼出-热线参评但未评价量 call_in_unsep_cnt：呼入-热线参评但未评价量 call_in_sep_sat_cnt：呼入-热线评价满意量 call_in_sep_...
MapReduce API
d['cnt']=0>>>def inner(keys):>>>d['cnt']=0>>>def h(row,done):>>>d['cnt']+row.cnt>>>if done:>>>if row.word in d['white_list']:>>>d['cnt']+5>>>yield keys.word,d['cnt']>>>return h>>>return inner>>>>>>words_df.map_reduce...
在告警通知中引用日志内容
{"fire_results":[{"status":"401","ip":"127.0.0.1","cnt":"3"},{"status":"400","ip":"127.0.0.1","cnt":"7"},{"status":"501","ip":"127.0.0.1","cnt":"4"},{"status":"404","ip":"127.0.0.1","cnt":"4"},{"status":"402","ip":"127.0.0...
GetSkillGroupAgentStatusDetails-获取技能组服务状态...
capacity":7,"svc_rest_cnt":0,"current_speci_ability_num":0,"servicer_rest_cnt":122,"max_speci_ability_num":3,"svc_offline_cnt":0,"svc_no_client_cnt":3,"svc_ask_rest_servicer_num":0} 返回参数 Rows 参数说明：group_name：技能...
GetSeatInformation-获取在线监控下部门坐席服务能力...
capacity":7,"svc_rest_cnt":0,"current_speci_ability_num":0,"servicer_rest_cnt":122,"max_speci_ability_num":3,"svc_offline_cnt":0,"svc_no_client_cnt":3,"svc_ask_rest_servicer_num":0} 返回参数 Rows 参数说明：svc_no_client_...
GetSkillGroupServiceCapability-获取在线监控下技能...
svc_no_client_cnt：空闲座席数 svc_rest_cnt：小休座席数 svc_online_cnt：在线中的座席 svc_avai_capacity：当前空余服务能力 svc_ask_rest_servicer_num：申请小休的座席 svc_ask_offline_servicer_num：申请离线的座席 svc_offline_cnt...
GetHotlineAgentDetailReport
time_agent_rest>1s</hotline_time_agent_rest><servicerName>testAccount</servicerName><hotline_time_incall_avg>1.23</hotline_time_incall_avg><hotline_num_to_rest_cnt>4</hotline_num_to_rest_cnt><call_out_cnt>10</call_out_cnt>...
DescribeDomainReport
调用DescribeDomainReport获取域名Whois信息、数字证书、威胁类型、相关攻击团伙或安全事件信息 请确保在使用该接口前，已充分了解威胁情报产品的......<malicious_child_domain_cnt>4</malicious_child_domain_cnt></Basic><RequestId>55B99BBE...
如何实现一键转冷存
本文介绍一键转冷存的最佳实践。...如果 reserved_subparts_cnt 大于0，则按照子分区分表建立的时间顺序进行排序，保留时间最近的 reserved_subparts_cnt 个子分区表数据存储位置不变，其余子分区表及其索引数据转为OSS存储。
如何实现一键转冷存
本文介绍一键转冷存的最佳实践。...如果 reserved_subparts_cnt 大于0，则按照子分区分表建立的时间顺序进行排序，保留时间最近的 reserved_subparts_cnt 个子分区表数据存储位置不变，其余子分区表及其索引数据转为OSS存储。
DescribeCdnReportList-查询报表定制列表
data":[{"reportId":1,"deliver":{"report":{"title":"DomainPvUv","format":"chart","shape":"line","xAxis":"ds","yAxis":"cnt","legend":"cnt_type","header":["ds","cnt_type","cnt"]}}} RequestId string 请求 ID。04F0F334-1335-436...
查询执行器介绍
explain physical/*+TDDL:EXECUTOR_MODE=AP_LOCAL*/select a.k,count(*)cnt from sbtest1 a,sbtest1 b where a.id=b.k and a.id>1000 group by k having cnt>1300 order by cnt limit 5,10;返回执行计划信息如下：+-+|ExecutorMode:AP_...
开通操作日志功能
topic_:DMS_LOG_DELIVERY AND subModule:LOGIN|SELECT concat(cast(operUserId as varchar),'(',operUserName,')')user,COUNT(*)cnt FROM dmstest WHERE state='0' GROUP BY operUserId,operUserName ORDER BY cnt DESC LIMIT 10;...
告警输出数据结构
method","start_time":1686722499,"end_time":1686722799,"fire_result":{"cnt":"5","request_method":"POST"},"raw_results":[{"cnt":"25","request_method":"GET"},{"cnt":"2","request_method":"DELETE"},{"cnt":"5","request_method":...
DescribeDcdnReportList-查询所有定制报表列表
data":[{"reportId":2,"deliver":{"report":{"title":"DomainPvUv","format":"chart","shape":"line","xAxis":"ds","yAxis":"cnt","legend":"cnt_type","header":["ds","cnt_type","cnt"]}}} RequestId string 请求 ID。04F0F334-1335-436...
写入数据到分区表
步骤二：创建分区表 CREATE EXTERNAL TABLE dla(prod_name string,cnt bigint)PARTITIONED BY(y string,m string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION 'oss:/bucket-name/dla/'; 假设OSS...
维度建模
lgt_sign_ord_cnt lgt_sign_ord_cnt 物流签收订单数 物流签收订单数-计数（COUNT）0 笔 否 物流域/物流域_默认 lgt_ord_cnt lgt_ord_cnt 物流订单总数 物流订单总数-累加（SUM）0 笔 否 信用&风控域/评价 remark_ord_cnt remark order ...
TPC-H测试
customer_cnt|lineitem_cnt|nation_cnt|order_cnt|part_cnt|partsupp_cnt|region_cnt|supplier_cnt|+-+-+-+-+-+-+-+-+|15000000|600037902|25|150000000|20000000|80000000|5|1000000|+-+-+-+-+-+-+-+-+采集统计信息 通过命令行连接到 ...
混合负载HTAP的实践和优化
explain cost select a.k,count(*)cnt from sbtest1 a,sbtest1 b where a.id=b.k and a.id>1000 group by k having cnt>1300 order by cnt limit 5,10;TopN(sort="cnt ASC",offset=?2,fetch=?3):rowcount=1.0,cumulative cost=value=2....
在日志服务SLS中查询、分析DMS的操作日志
topic_:DMS_LOG_DELIVERY|SELECT concat(cast(operUserId as varchar),'(',operUserName,')')user,COUNT(*)cnt FROM dmstest WHERE state='0' and requestIp in('127.0.0.1')GROUP BY operUserId,operUserName ORDER BY cnt DESC LIMIT 10;...
TPC-H测试
customer_cnt|lineitem_cnt|nation_cnt|order_cnt|part_cnt|partsupp_cnt|region_cnt|supplier_cnt|+-+-+-+-+-+-+-+-+|15000000|600037902|25|150000000|20000000|80000000|5|1000000|+-+-+-+-+-+-+-+-+采集统计信息 通过命令行连接到 ...
旧版告警的模板变量
count(*)as cnt group by status","QueryUrl":"","RawResultCount":2,"RawResults":[{"_source_":"","_time_":"1621592292","cnt":"2","status":"403"},{"_source_":"","_time_":"1621592292","cnt":"1","status":"401"}],"RawResultsAsKv...
内容行业
100 share_cnt string 可选 一个月内分享次数 用户自填 不要求实时性，优先级可以放低 100 download_cnt string 可选 一个月内下载次数 用户自填 不要求实时性，优先级可以放低 100 tip_cnt string 可选 一个月内打赏数 用户自填 不要求...
实时分析海量MaxCompute数据
SELECT ca_city,count(*)AS cnt FROM customer,customer_address WHERE c_current_addr_sk=ca_address_sk AND ca_city IS NOT NULL GROUP BY ca_city HAVING count(*)>10 ORDER BY cnt DESC LIMIT 10;SQL4:查询首选客户出生于1980~1990年且...
新闻行业
用户自填 pv_cnt string 可选 一个月内曝光次数。用户自填 启动时，如果当前场景行为数据比较稀疏，可以将平台其他场景的行为统计数据放入这些字段，不要求实时性。模型稳定后，如果维护这些字段成本较高，可以低优先级处理。100000 click_...
多行数据合并为一行数据
本文为您介绍，如何使用SQL实现多行...SELECT class,SUM(CASE WHEN gender='M' THEN 1 ELSE 0 END)AS cnt_m,SUM(CASE WHEN gender='F' THEN 1 ELSE 0 END)AS cnt_f FROM students GROUP BY class;输出结果如下。class cnt_m cnt_f 1 2 2 2 1 1
DescribeIpReport
cnt>4</event_cnt>互联网</industry_name><gmt_last_attack>2021-02-23 08:01:11</gmt_last_attack></AttackPreferenceTop5><AttackPreferenceTop5><event_cnt>42</event_cnt>零售</industry_name><gmt_last_attack>2021-03-17 12:00:21...
alicloud_sddp_config
failed_cnt"value=10 } Argument Reference The following arguments are supported:code-(Optional,ForceNew)Abnormal Alarm General Configuration Module by Using the Encoding.Valid values:access_failed_cnt,access_permission_...
获取App列表
ACCESS_KEY_ID,ACCESS_KEY_SECRET)def list_apps():try:marker='' max_item=2 app_cnt=0 scope='Private' while 1:response=client.list_apps(scope,marker,max_item)marker=response.NextMarker app_cnt+len(response.Items)for app in ...
alicloud_sddp_configs
This data source provides the Sddp Configs of the current Alibaba Cloud user.->NOTE:Available in v1.133.0+.Example Usage Basic Usage resource"alicloud_sddp_config""default"{ code="access_failed_cnt"value=10 } data"alicloud...
边聚类系数
node1|node2|node1_edge_cnt|node2_edge_cnt|triangle_cnt|density|-|-|-|-|-|-|3|1|4|4|2|0.5|5|1|7|4|3|0.75|7|1|3|4|1|0.33333|1|2|4|4|2|0.5|4|2|4|4|2|0.5|2|3|4|4|3|0.75|5|3|7|4|3|0.75|3|4|4|4|2|0.5|8|4|3|4|1|0.33333|2|5|4|7|3|...
- 产品推荐
- 这些文档可能帮助您