关键字:
.
搜索
名称:
代码:
<<
=
;
"
'
<table>
</table>
积木:
类型
普通积木
单项选择
文本框
类型:
类型
变量
列格式
代码
包含代码
注释
表格模板
表格数据
代码模板
代码参数
js_code
颜色:
选择颜色
淡红色
淡绿色
淡蓝色
白色
红色
黄色
橙色
绿色
宽度:
宽度
100
150
200
250
300
400
500
600
key:
删除
保存
名称:
保存文件:
编译文件:
转化:
SCP:
参数:
url:
项目:
选择项目
打开项目
打开收藏夹
包ID:
语言:
选择类型
v3_php
v3_js
v3_python
v3_java
v3_csharp
v3_c
v3_cpp
v3_shell
v3_csharp
v3_sql
v3_macro
v3_tools
v3_csharp_ui
v3_html_ui
目标语言:
选择类型
php
js
python
java
csharp
c
cpp
shell
csharp
sql
宏ID:
选择宏
.
保存
源码:
保存
用户名:
密码:
登录
属性
编辑
任务模式
分类便条
过滤器:
选择
{ "class": "go.GraphLinksModel", "nodeDataArray": [ { "key": "3459", "text": "查询数据 6点 视频 特点", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1008, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"Select itemid,count(1) as rank From common.pt_20120904 Where from_unixtime(visittime,\'H\')=6 Group By itemid Order By rank desc Limit 100;"},{ "key": "3528", "text": "查询数据 点击 排行", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1008, "finished":0,"time_end":"2021-08-15 12:10:41", "content":" Select * from ( select refitemid,count(1) as rank from clicklog_20120910 group by refitemid) a Order by a.rank desc limit 100; "},{ "key": "4138", "text": "统计 点击", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1008, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"select date(BeginTime),sum(clickcount)/sum(showcount) from ClickRate where config_id = 559 group by date(BeginTime);"},{ "key": "4342", "text": "查询数据", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1008, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"土豆现在使用的算法 select * from ClickRate where BeginTime>'2013-1-8' and Config_id=559; 统计子id是563 小流量是S0034 select * from ClickRate where BeginTime>'2013-1-8' and Config_id=563; select * from ClickRate where BeginTime>'2013-1-8' and Config_id=572;"},{ "key": "5622", "text": "查询数据", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1008, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"select count(1) FROM CF019_output Where row_number=20 ; 3108745 (311W) select count(1) FROM CF019_output Where row_number=1 ; 28766367 (2876W)"},{ "key": "5688", "text": "查询数据 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1008, "finished":0,"time_end":"2021-08-15 12:10:41", "content":":url:点击率差,超过1000查看 http://10.103.23.151/funnyscript/view_hive_table.php?id=1538 :color:blue:统计用户厌恶的视频种类"} ], "linkDataArray": [ ]}