Mydata
出自 qingwei personal wiki
日常環境
chrome下訪問
- 打開無痕瀏覽
- url中輸入 chrome://net-internals/#hsts， 選擇Domain Security Policy
- Delete domain security policies 中刪除： hz-mydata.alibaba.com, login.alibaba,com
DNS配置
11.160.117.191 data.alibaba.com
11.160.205.238 hz-mydata.alibaba.com
11.160.205.238 us-mydata.alibaba.com
11.163.84.60 alidata-bops.alibaba-inc.com
11.162.132.172 www2.alibaba.com
#alibaba
11.163.171.5 login.alibaba.com #enlogin
11.163.174.65 accounts.alibaba.com
#11.163.86.202 passport.alibaba.com
11.163.14.171 marketing.alibaba.com
127.0.0.1 i.alibaba.com
127.0.0.1 umidprod.stable.alibaba-inc.com
127.0.0.1 profile.alibaba.com
127.0.0.1 notification.alibaba.com
127.0.0.1 www.alibaba.com
127.0.0.1 page.1688.com
127.0.0.1 stat.gmonitor.aliimg.com
127.0.0.1 acookie.alibaba.com
127.0.0.1 page.china.alibaba.com
127.0.0.1 ynuf.alibaba.com
127.0.0.1 hzhermes.alibaba.com
127.0.0.1 checktoken.alibaba.com
127.0.0.1 checktoken2.alibaba.com
127.0.0.1 translate.google.com
127.0.0.1 cmap.alibaba.com
#登录
11.239.151.122 login.aliexpress.com # aone
#add by youzhao for host api test
127.0.0.1 www.func1.com
127.0.0.1 www.func2.com
# ENV_FUNC
# external hosts
# 11.22.33.44 alex_test_domain
10.125.10.175 sso.alibaba-inc.com
10.125.10.174 img.alitest.net
10.218.130.51 cun.taobao.org
10.218.137.155 i.cun.daily.taobao.net
10.189.227.143 cun.daily.taobao.net
10.101.73.189 g.tbcdn.cn
#10.101.73.189 g.alicdn.com
100.69.167.192 cunlist.daily.taobao.com
10.101.83.83 radar.aliyun.test
10.101.83.79 auth.alibaba.net
10.189.227.74 account.aliyun.test
#10.101.91.52 passport.daily.alibaba.com
10.101.86.70 aui.aliyun.test
10.101.83.84 portal.aliyun.test
10.125.1.239 radar.alibaba-inc.com
100.69.192.12 tcunmotion.taobao.org
10.218.133.185 poa.alibaba-inc.com
# meri日常环境
10.218.143.112 testmeri.alibabacorp.com
100.69.161.171 venice-test.alibaba.com
100.69.169.167 recluse.alitest.net
# ceres日常环境
100.69.170.245 ceresiner.alitest.com
100.69.170.245 cerespub.alitest.com
# Ants独立性环境
100.69.170.245 cg.zmxy.net
100.69.170.245 cg.mybank.net
100.69.170.245 cg.antsdaq.net
100.69.170.245 cg.alipay.net
100.69.170.245 cg.ant-financial.net
100.69.170.245 cg.koubei.net
# ceres需要的1688日常环境
42.156.238.99 login.1688.com
42.156.238.99 pass.pass.1688.com
42.156.238.99 trade.1688.com
42.156.238.99 order.1688.com
42.156.238.99 member.china.alibaba.com
42.156.238.99 member.1688.com
# 42.156.238.99 test.img.china.alibaba.com i00.c.aliimg.com i01.c.aliimg.com i02.c.aliimg.com i03.c.aliimg.com i04.c.aliimg.com i05.c.aliimg.com
42.156.238.99 go.1688.com
42.156.238.99 webpush.1688.com
112.124.132.140 gw.open.1688.com
42.156.238.99 portal.go.1688.com
42.156.238.99 foxtest001.go.1688.com
42.156.238.99 zhoulhtest001.go.1688.com
42.156.238.99 hxjtest1.go.1688.com
42.156.238.99 shenghua001.go.1688.com
42.156.238.99 open.go.1688.com
# rocky日常环境
11.239.186.181 property-daily.alibaba-inc.com
100.69.199.118 property-test.alibaba-inc.com
# 10.232.101.129 yunpan.alibaba-inc.com
# 10.218.139.10 a-work.alibaba-inc.com
db
新產品表
dwp_en_gm_vip_prod_eff_d
行業樹
create table `sc_alidata_[0000-0015].dwp_en_dm_vip_compcate_d_[[0000-0216]]` (
`id` bigint not null auto_increment comment '主键',
`stat_date` date comment '统计日期',
`admin_mbr_seq` bigint comment '会员SEQ',
`admin_mbr_id` varchar(100) comment '会员ID',
`comp_id` bigint comment '公司ID',
`cate_id` bigint comment '产品发布类目ID【关联维表icbucdm.dim_en_pcate_v】【关联键cate_id】',
`itm_cnt_std_009` bigint comment '历史截至当日商品数',
`rank_std_001` bigint comment '历史截止当日商品数排序',
`cate_desc` varchar(200) comment '行业描述',
primary key (id),
key `idx_admin_mbr_id` (stat_date,admin_mbr_seq)
) default charset=utf8mb4 comment='每个分区包含公司发布商品的行业指标';
相關的表:
dim_en_iview_cate (數據倉庫中) --> pub_en_iview_category_dimt0 (mysql表)
備註: pub_en_iview_category_dimt0 這個就是從icbucdm.dim_en_pcate_v 出來的
