Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
K
kb
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 2
    • Issues 2
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • granite
  • kb
  • Wiki
    • Lake
  • pdd_find_goods

pdd_find_goods · Changes

Page history
update: 拼多多搜索商品数据入库和表结构 authored Aug 27, 2021 by 李子健's avatar 李子健
Hide whitespace changes
Inline Side-by-side
Showing with 8 additions and 9 deletions
+8 -9
  • lake/pdd_find_goods.md lake/pdd_find_goods.md +8 -9
  • No files found.
lake/pdd_find_goods.md
View page @ e179db4c
......@@ -122,15 +122,14 @@ CREATE TABLE if not exists bdp_pdd.`pdd_find_goods` (
| search_key | varchar | 搜索关键词 |
| goods_url | varchar | 商品链接 |
| mall_url | varchar | 店铺链接 |
| icon_url | varchar | 图标链接 |
| thumb_url | varchar | APP下载链接 |
| hd_url | varchar | APP官方主页 |
| hd_thumb_url | varchar | APP状态,0: 初始(未采集详情) 1:正常 9:APP已下线 |
| tag_style | varchar | APP标签(多个标签用“,”隔开) |
| event_type | varchar | 收录时间 |
| activity_type | varchar | 最后更新时间 |
| tag | varchar | 使用标记,10废弃使用 |
| hd_thumb_wm | varchar | 是否是历史数据,1历史数据 |
| thumb_url | varchar | |
| hd_url | varchar | |
| hd_thumb_url | varchar | |
| tag_style | varchar | |
| event_type | varchar | |
| activity_type | varchar | |
| tag | varchar | |
| hd_thumb_wm | varchar | |
| is_app | varchar | |
| list_type | varchar | |
| image_wm | varchar | |
......
Clone repository
  • README
  • basic_guidelines
  • basic_guidelines
    • basic_guidelines
    • dev_guide
    • project_build
    • 开发流程
  • best_practice
  • best_practice
    • AlterTable
    • RDS
    • azkaban
    • create_table
    • design
    • elasticsearch
    • elasticsearch
      • ES运维
    • logstash
View All Pages