关键字：
.
搜索
名称：
代码：
<<
=
;
"
'
<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": "11156", "text": "联通每天曝光的用户数 749 4619 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"Select count(1) as rank From ( select phone_number,count(1) as rank from report.tb_qrqm_recommend_info where opera_day='20210408' AND touch_type = 100011 AND show_position = 10011 group by phone_number ) a; "},{ "key": "11161", "text": "用户信息表 app注册用户", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"desc summary_layer.tb_hold_2i_label;"},{ "key": "11162", "text": "用户信息表，非app注册用户 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"desc summary_layer.tb_hold_n2i_label;"},{ "key": "11164", "text": "联通 每天 曝光用户数 749w 这个是数据读取次数 不是曝光 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"Select count(1) as rank From ( select phone_number,count(1) as rank from report.tb_qrqm_recommend_info where opera_day='20210408' AND touch_type = 100011 AND show_position = 10011 group by phone_number ) a; "},{ "key": "11180", "text": "创建 user_view_click 表 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"insert into ai_learning_project.user_view_click partition(opera_day='$time') select a.phone_number,b.rank as click,a.rank as view,b.rank/a.rank as rate From (select phone_number,count(1) as rank from report.tb_qrqm_recommend_info where opera_day='$time' AND touch_type = 100011 AND show_position = 10011 group by phone_number) a Left outer join ( select phone_number,count(1) as rank from report.t_dw_qrqm_click_order_info where act_code = '首页-TAB-业务' AND opera_type = '点击' AND opera_day='$time' group by phone_number ) b On (a.phone_number=b.phone_number) ;"},{ "key": "11181", "text": "扣除黑名单 曝光数大于100的用户 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"select * From (select * From ai_learning_project.user_view_click where opera_day='20210408' ) a join (select phone_number From xiangdan.summary_blacklist_202103) b on (a.phone_number =b.phone_number) where a.view>100 AND b.phone_number is null limit 100;"},{ "key": "11182", "text": "曝光数据 扣除黑名单用户 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"select a.* From (select * From ai_learning_project.user_view_click where opera_day='$time' ) a Left outer join (select phone_number From xiangdan.summary_blacklist_202103) b on (a.phone_number =b.phone_number) where b.phone_number is null limit 300;"},{ "key": "11191", "text": "创建 user_item_view_click 表 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"use ai_learning_project; insert into user_item_view_click partition(opera_day='20210408') select a.phone_number,a.goods_id,a.rank as view,b.rank as click,b.rank/a.rank as rate From (select phone_number,goods_id,count(1) as rank from report.tb_qrqm_recommend_info where opera_day='20210408' AND touch_type = 100011 AND show_position = 10011 group by phone_number,goods_id) a Left outer join ( select phone_number,goods_id,count(1) as rank from report.t_dw_qrqm_click_order_info where act_code = '首页-TAB-业务' AND opera_type = '点击' AND opera_day='20210408' group by phone_number,goods_id ) b On (a.phone_number=b.phone_number AND a.goods_id=b.goods_id) ;"},{ "key": "11192", "text": "额度不同的用户喜欢的商品类型 偏好", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"select fee_type,type_chwl,sum(view),sum(click),round(sum(click)/sum(view),4) From (select a.phone_number,b.type_chwl, case when c.k003612 <30 then '小于30' when (c.k003612>=30 and c.k003612 < 60) then '30-60' when (c.k003612>=60 and c.k003612 < 100) then '60-100' when (c.k003612>=100 and c.k003612 < 150) then '100-150' when (c.k003612>=150 and c.k003612 < 300) then '150-300' else '大于300' end fee_type , a.view,a.click From (select * From ai_learning_project.user_item_view_click Where opera_day='20210408') a Left join report.tb_recommend_goods b on a.goods_id=b.goods_id Left join (select phone_number,k003612 From summary_layer.tb_hold_2i_label union all select phone_number,k003612 From summary_layer.tb_hold_n2i_label) c on a.phone_number = c.phone_number ) ut group by fee_type,type_chwl; "},{ "key": "11193", "text": "联通商品的分类查询 ", "figure":"Circle", "color":"white", "Executor":"", "x":0,"y":0,"end_time":-1356.9, "finished":0,"time_end":"2021-08-15 12:10:41", "content":"select type_chwl,count(1) as rank From report.tb_recommend_goods group by type_chwl;"} ], "linkDataArray": [ ]}