数据仓库DWS层-离线数仓-大数据

我会带着你远行 2022-11-30 04:18 294阅读 0赞

目标：统计当日、当周、当月活动的每个设备明细

  1. 每日活跃设备明细

    create external table dws_uv_detail_day
    (

    1. `mid_id` string COMMENT '设备唯一标识',
    2. `user_id` string COMMENT '用户标识', 
    3. `version_code` string COMMENT '程序版本号', 
    4. `version_name` string COMMENT '程序版本名', 
    5. `lang` string COMMENT '系统语言', 
    6. `source` string COMMENT '渠道号', 
    7. `os` string COMMENT '安卓系统版本', 
    8. `area` string COMMENT '区域', 
    9. `model` string COMMENT '手机型号', 
    10. `brand` string COMMENT '手机品牌', 
    11. `sdk_version` string COMMENT 'sdkVersion', 
    12. `gmail` string COMMENT 'gmail', 
    13. `height_width` string COMMENT '屏幕宽高',
    14. `app_time` string COMMENT '客户端日志产生时的时间',
    15. `network` string COMMENT '网络模式',
    16. `lng` string COMMENT '经度',
    17. `lat` string COMMENT '纬度'

    )
    partitioned by(dt string)
    stored as parquet
    location ‘/warehouse/gmall/dws/dws_uv_detail_day’;

    step2. 从启动日志表导入数据

    insert overwrite table dws_uv_detail_day
    partition(dt=’2020-08-19’)
    select 

    1. mid_id,
    2. concat_ws('|', collect_set(user_id)) user_id,
    3. concat_ws('|', collect_set(version_code)) version_code,
    4. concat_ws('|', collect_set(version_name)) version_name,
    5. concat_ws('|', collect_set(lang))lang,
    6. concat_ws('|', collect_set(source)) source,
    7. concat_ws('|', collect_set(os)) os,
    8. concat_ws('|', collect_set(area)) area, 
    9. concat_ws('|', collect_set(model)) model,
    10. concat_ws('|', collect_set(brand)) brand,
    11. concat_ws('|', collect_set(sdk_version)) sdk_version,
    12. concat_ws('|', collect_set(gmail)) gmail,
    13. concat_ws('|', collect_set(height_width)) height_width,
    14. concat_ws('|', collect_set(app_time)) app_time,
    15. concat_ws('|', collect_set(network)) network,
    16. concat_ws('|', collect_set(lng)) lng,
    17. concat_ws('|', collect_set(lat)) lat

    from dwd_start_log
    where dt=’2020-08-19’
    group by mid_id;

    step3. 验证导入数据是否正确

    SELECT * FROM dws_uv_detail_day WHERE dt=’2020-08-19’ LIMIT 2;

    mid_id|user_id|version_code|version_name|lang |source|os |area|model |brand |sdk_version |gmail |height_width|app_time |network|lng |lat |dt |
    ———|———-|——————|——————|——-|———|—————-|——|———————|—————|——————-|——————————————————-|——————|—————————————-|———-|—————-|—————-|—————|
    0 |0 |14|13 |1.3.6|1.0.0 |es|en|D |8.1.3|8.1.7|MX |Huawei-7|HTC-3|Huawei|HTC|V2.7.0|V2.8.0|4H34OQ8C@gmail.com|617U6H5X@gmail.com|640960 |1597830241221|1597785492032|WIFI|3G|-68.1|-53.0|-43.1|-47.2|2020-08-19|
    1 |1 |15 |1.3.0 |en |A |8.1.5 |MX |sumsung-0 |Sumsung |V2.6.6 |QQ4V37RD@gmail.com |750    1134 |1597827058186 |WIFI |-41.7 |-13.6 |2020-08-19|

  2. 每周活跃设备明细

    create external table dws_uv_detail_wk( 

    1. `mid_id` string COMMENT '设备唯一标识',
    2. `user_id` string COMMENT '用户标识', 
    3. `version_code` string COMMENT '程序版本号', 
    4. `version_name` string COMMENT '程序版本名', 
    5. `lang` string COMMENT '系统语言', 
    6. `source` string COMMENT '渠道号', 
    7. `os` string COMMENT '安卓系统版本', 
    8. `area` string COMMENT '区域', 
    9. `model` string COMMENT '手机型号', 
    10. `brand` string COMMENT '手机品牌', 
    11. `sdk_version` string COMMENT 'sdkVersion', 
    12. `gmail` string COMMENT 'gmail', 
    13. `height_width` string COMMENT '屏幕宽高',
    14. `app_time` string COMMENT '客户端日志产生时的时间',
    15. `network` string COMMENT '网络模式',
    16. `lng` string COMMENT '经度',
    17. `lat` string COMMENT '纬度',
    18. `monday_date` string COMMENT '周一日期',
    19. `sunday_date` string COMMENT  '周日日期'

    ) COMMENT ‘活跃用户按周明细’
    PARTITIONED BY (wk_dt string)
    stored as parquet
    location ‘/warehouse/gmall/dws/dws_uv_detail_wk/‘;

    step2. 从日活跃表导入数据

    ！！！这里一定要设置partition为nonstrict，否则会提示partition不是static

    set hive.exec.dynamic.partition.mode=nonstrict;

    insert overwrite table dws_uv_detail_wk partition(wk_dt)
    select 

    1. mid_id,
    2. concat_ws('|', collect_set(user_id)) user_id,
    3. concat_ws('|', collect_set(version_code)) version_code,
    4. concat_ws('|', collect_set(version_name)) version_name,
    5. concat_ws('|', collect_set(lang)) lang,
    6. concat_ws('|', collect_set(source)) source,
    7. concat_ws('|', collect_set(os)) os,
    8. concat_ws('|', collect_set(area)) area, 
    9. concat_ws('|', collect_set(model)) model,
    10. concat_ws('|', collect_set(brand)) brand,
    11. concat_ws('|', collect_set(sdk_version)) sdk_version,
    12. concat_ws('|', collect_set(gmail)) gmail,
    13. concat_ws('|', collect_set(height_width)) height_width,
    14. concat_ws('|', collect_set(app_time)) app_time,
    15. concat_ws('|', collect_set(network)) network,
    16. concat_ws('|', collect_set(lng)) lng,
    17. concat_ws('|', collect_set(lat)) lat,
    18. date_add(next_day('2020-08-19','MO'),-7),
    19. date_add(next_day('2020-08-19','MO'),-1),
    20. concat(date_add( next_day('2020-08-19','MO'),-7), '_' , date_add(next_day('2020-08-19','MO'),-1)

    )
    from dws_uv_detail_day
    where dt>=date_add(next_day(‘2020-08-19’,’MO’),-7) and dt<=date_add(next_day(‘2020-08-19’,’MO’),-1)
    group by mid_id;

    step3. 验证导入数据是否正确

    SELECT * FROM dws_uv_detail_wk LIMIT 2;

    mid_id|user_id|version_code|version_name|lang |source|os |area|model |brand |sdk_version |gmail |height_width|app_time |network|lng |lat |monday_date|sunday_date|wk_dt |
    ———|———-|——————|——————|——-|———|—————-|——|———————|—————|——————-|——————————————————-|——————|—————————————-|———-|—————-|—————-|—————-|—————-|——————————-|
    0 |0 |14|13 |1.3.6|1.0.0 |es|en|D |8.1.3|8.1.7|MX |Huawei-7|HTC-3|Huawei|HTC|V2.7.0|V2.8.0|4H34OQ8C@gmail.com|617U6H5X@gmail.com|640960 |1597830241221|1597785492032|WIFI|3G|-68.1|-53.0|-43.1|-47.2|2020-08-17 |2020-08-23 |2020-08-17_2020-08-23|
    1 |1 |15 |1.3.0 |en |A |8.1.5 |MX |sumsung-0 |Sumsung |V2.6.6 |QQ4V37RD@gmail.com |750    1134 |1597827058186 |WIFI |-41.7 |-13.6 |2020-08-17 |2020-08-23 |2020-08-17_2020-08-23|

    select count(*) from dws_uv_detail_wk;

    _c0|
    —-|
    708|

  3. 每月活跃设备明细

    create external table dws_uv_detail_mn( 

    1. `mid_id` string COMMENT '设备唯一标识',
    2. `user_id` string COMMENT '用户标识', 
    3. `version_code` string COMMENT '程序版本号', 
    4. `version_name` string COMMENT '程序版本名', 
    5. `lang` string COMMENT '系统语言', 
    6. `source` string COMMENT '渠道号', 
    7. `os` string COMMENT '安卓系统版本', 
    8. `area` string COMMENT '区域', 
    9. `model` string COMMENT '手机型号', 
    10. `brand` string COMMENT '手机品牌', 
    11. `sdk_version` string COMMENT 'sdkVersion', 
    12. `gmail` string COMMENT 'gmail', 
    13. `height_width` string COMMENT '屏幕宽高',
    14. `app_time` string COMMENT '客户端日志产生时的时间',
    15. `network` string COMMENT '网络模式',
    16. `lng` string COMMENT '经度',
    17. `lat` string COMMENT '纬度'

    ) COMMENT ‘活跃用户按月明细’
    PARTITIONED BY (mn string)
    stored as parquet
    location ‘/warehouse/gmall/dws/dws_uv_detail_mn/‘;

    step2. 从日活表导入数据

    ！！！一定要设置partition的mode

    set hive.exec.dynamic.partition.mode=nonstrict;

    insert overwrite table dws_uv_detail_mn partition(mn)
    select 

    1. mid_id,
    2. concat_ws('|', collect_set(user_id)) user_id,
    3. concat_ws('|', collect_set(version_code)) version_code,
    4. concat_ws('|', collect_set(version_name)) version_name,
    5. concat_ws('|', collect_set(lang)) lang,
    6. concat_ws('|', collect_set(source)) source,
    7. concat_ws('|', collect_set(os)) os,
    8. concat_ws('|', collect_set(area)) area, 
    9. concat_ws('|', collect_set(model)) model,
    10. concat_ws('|', collect_set(brand)) brand,
    11. concat_ws('|', collect_set(sdk_version)) sdk_version,
    12. concat_ws('|', collect_set(gmail)) gmail,
    13. concat_ws('|', collect_set(height_width)) height_width,
    14. concat_ws('|', collect_set(app_time)) app_time,
    15. concat_ws('|', collect_set(network)) network,
    16. concat_ws('|', collect_set(lng)) lng,
    17. concat_ws('|', collect_set(lat)) lat,
    18. date_format('2019-02-10','yyyy-MM')

    from dws_uv_detail_day
    where date_format(dt,’yyyy-MM’) = date_format(‘2019-02-10’,’yyyy-MM’)
    group by mid_id;

    step3. 从日活跃表导入数据

    SELECT * FROM dws_uv_detail_mn LIMIT 2;

    mid_id|user_id|version_code|version_name|lang |source|os |area|model |brand |sdk_version |gmail |height_width|app_time |network|lng |lat |mn |
    ———|———-|——————|——————|——-|———|—————-|——|———————|—————|——————-|——————————————————-|——————|—————————————-|———-|—————-|—————-|———-|
    0 |0 |14|13 |1.3.6|1.0.0 |es|en|D |8.1.3|8.1.7|MX |Huawei-7|HTC-3|Huawei|HTC|V2.7.0|V2.8.0|4H34OQ8C@gmail.com|617U6H5X@gmail.com|640960 |1597830241221|1597785492032|WIFI|3G|-68.1|-53.0|-43.1|-47.2|2020-08|
    1 |1 |15 |1.3.0 |en |A |8.1.5 |MX |sumsung-0 |Sumsung |V2.6.6 |QQ4V37RD@gmail.com |750    1134 |1597827058186 |WIFI |-41.7 |-13.6 |2020-08|

    select count(*) from dws_uv_detail_mn ;

    _c0|
    —-|
    708|

活跃用户详情导入成功，接下来编写脚本

  1. #!/bin/bash
  3. # 定义变量方便修改
  4. APP=gmall
  5. hive=/opt/module/hive/bin/hive
  7. # 如果是输入的日期按照取输入日期；如果没输入日期取当前时间的前一天
  8. if [ -n "$1" ] ;then
  9.     do_date=$1
  10. else 
  11.     do_date=`date -d "-1 day" +%F`  
  12. fi 
  15. sql="
  16.   set hive.exec.dynamic.partition.mode=nonstrict;
  18.   insert overwrite table "$APP".dws_uv_detail_day partition(dt='$do_date')
  19.   select  
  20.     mid_id,
  21.     concat_ws('|', collect_set(user_id)) user_id,
  22.     concat_ws('|', collect_set(version_code)) version_code,
  23.     concat_ws('|', collect_set(version_name)) version_name,
  24.     concat_ws('|', collect_set(lang)) lang,
  25.     concat_ws('|', collect_set(source)) source,
  26.     concat_ws('|', collect_set(os)) os,
  27.     concat_ws('|', collect_set(area)) area, 
  28.     concat_ws('|', collect_set(model)) model,
  29.     concat_ws('|', collect_set(brand)) brand,
  30.     concat_ws('|', collect_set(sdk_version)) sdk_version,
  31.     concat_ws('|', collect_set(gmail)) gmail,
  32.     concat_ws('|', collect_set(height_width)) height_width,
  33.     concat_ws('|', collect_set(app_time)) app_time,
  34.     concat_ws('|', collect_set(network)) network,
  35.     concat_ws('|', collect_set(lng)) lng,
  36.     concat_ws('|', collect_set(lat)) lat
  37.   from "$APP".dwd_start_log
  38.   where dt='$do_date'  
  39.   group by mid_id;
  42.   insert overwrite table "$APP".dws_uv_detail_wk partition(wk_dt)
  43.   select  
  44.     mid_id,
  45.     concat_ws('|', collect_set(user_id)) user_id,
  46.     concat_ws('|', collect_set(version_code)) version_code,
  47.     concat_ws('|', collect_set(version_name)) version_name,
  48.     concat_ws('|', collect_set(lang)) lang,
  49.     concat_ws('|', collect_set(source)) source,
  50.     concat_ws('|', collect_set(os)) os,
  51.     concat_ws('|', collect_set(area)) area, 
  52.     concat_ws('|', collect_set(model)) model,
  53.     concat_ws('|', collect_set(brand)) brand,
  54.     concat_ws('|', collect_set(sdk_version)) sdk_version,
  55.     concat_ws('|', collect_set(gmail)) gmail,
  56.     concat_ws('|', collect_set(height_width)) height_width,
  57.     concat_ws('|', collect_set(app_time)) app_time,
  58.     concat_ws('|', collect_set(network)) network,
  59.     concat_ws('|', collect_set(lng)) lng,
  60.     concat_ws('|', collect_set(lat)) lat,
  61.     date_add(next_day('$do_date','MO'),-7),
  62.     date_add(next_day('$do_date','MO'),-1),
  63.     concat(date_add( next_day('$do_date','MO'),-7), '_' , date_add(next_day('$do_date','MO'),-1) 
  64.   )
  65.   from "$APP".dws_uv_detail_day
  66.   where dt>=date_add(next_day('$do_date','MO'),-7) and dt<=date_add(next_day('$do_date','MO'),-1) 
  67.   group by mid_id; 
  70.   insert overwrite table "$APP".dws_uv_detail_mn partition(mn)
  71.   select
  72.     mid_id,
  73.     concat_ws('|', collect_set(user_id)) user_id,
  74.     concat_ws('|', collect_set(version_code)) version_code,
  75.     concat_ws('|', collect_set(version_name)) version_name,
  76.     concat_ws('|', collect_set(lang))lang,
  77.     concat_ws('|', collect_set(source)) source,
  78.     concat_ws('|', collect_set(os)) os,
  79.     concat_ws('|', collect_set(area)) area, 
  80.     concat_ws('|', collect_set(model)) model,
  81.     concat_ws('|', collect_set(brand)) brand,
  82.     concat_ws('|', collect_set(sdk_version)) sdk_version,
  83.     concat_ws('|', collect_set(gmail)) gmail,
  84.     concat_ws('|', collect_set(height_width)) height_width,
  85.     concat_ws('|', collect_set(app_time)) app_time,
  86.     concat_ws('|', collect_set(network)) network,
  87.     concat_ws('|', collect_set(lng)) lng,
  88.     concat_ws('|', collect_set(lat)) lat,
  89.     date_format('$do_date','yyyy-MM')
  90.   from "$APP".dws_uv_detail_day
  91.   where date_format(dt,'yyyy-MM') = date_format('$do_date','yyyy-MM')   
  92.   group by mid_id;
  93. "
  95. $hive -e "$sql"

每日新增设备

  1. create external table dws_new_mid_day
  2. (
  3.     `mid_id` string COMMENT '设备唯一标识',
  4.     `user_id` string COMMENT '用户标识', 
  5.     `version_code` string COMMENT '程序版本号', 
  6.     `version_name` string COMMENT '程序版本名', 
  7.     `lang` string COMMENT '系统语言', 
  8.     `source` string COMMENT '渠道号', 
  9.     `os` string COMMENT '安卓系统版本', 
  10.     `area` string COMMENT '区域', 
  11.     `model` string COMMENT '手机型号', 
  12.     `brand` string COMMENT '手机品牌', 
  13.     `sdk_version` string COMMENT 'sdkVersion', 
  14.     `gmail` string COMMENT 'gmail', 
  15.     `height_width` string COMMENT '屏幕宽高',
  16.     `app_time` string COMMENT '客户端日志产生时的时间',
  17.     `network` string COMMENT '网络模式',
  18.     `lng` string COMMENT '经度',
  19.     `lat` string COMMENT '纬度',
  20.     `create_date`  string  comment '创建时间' 
  21. )  COMMENT '每日新增设备信息'
  22. stored as parquet
  23. location '/warehouse/gmall/dws/dws_new_mid_day/';
  25. #step2. 从每日用户活跃表导入数据
  26. insert into table dws_new_mid_day
  27. select  
  28.     ud.mid_id,
  29.     ud.user_id , 
  30.     ud.version_code , 
  31.     ud.version_name , 
  32.     ud.lang , 
  33.     ud.source, 
  34.     ud.os, 
  35.     ud.area, 
  36.     ud.model, 
  37.     ud.brand, 
  38.     ud.sdk_version, 
  39.     ud.gmail, 
  40.     ud.height_width,
  41.     ud.app_time,
  42.     ud.network,
  43.     ud.lng,
  44.     ud.lat,
  45.     '2020-08-19'
  46. from dws_uv_detail_day ud left join dws_new_mid_day nm on ud.mid_id=nm.mid_id
  47. where ud.dt='2020-08-19' and nm.mid_id is null;
  49. #step3. 验证导入数据是否正确
  50. SELECT * FROM dws_new_mid_day LIMIT 2;
  52. mid_id|user_id|version_code|version_name|lang |source|os         |area|model         |brand     |sdk_version  |gmail                                |height_width|app_time                   |network|lng        |lat        |create_date|
  53. ------|-------|------------|------------|-----|------|-----------|----|--------------|----------|-------------|-------------------------------------|------------|---------------------------|-------|-----------|-----------|-----------|
  54. 0     |0      |14|13       |1.3.6|1.0.0 |es|en|D     |8.1.3|8.1.7|MX  |Huawei-7|HTC-3|Huawei|HTC|V2.7.0|V2.8.0|4H34OQ8C@gmail.com|617U6H5X@gmail.com|640*960     |1597830241221|1597785492032|WIFI|3G|-68.1|-53.0|-43.1|-47.2|2020-08-19 |
  55. 1     |1      |15          |1.3.0       |en   |A     |8.1.5      |MX  |sumsung-0     |Sumsung   |V2.6.6       |QQ4V37RD@gmail.com                   |750*1134    |1597827058186              |WIFI   |-41.7      |-13.6      |2020-08-19 |

日新增详情表导入脚本

  1. #!/bin/bash
  2. APP=gmall
  3. hive=$HIVE_HOME/bin/hive
  5. if [ -n "$1" ];then
  6.         do_date=$1
  7. else
  8.         do_date=`date -d "-1 day" +%F`
  9. fi
  12. sql="
  13.         INSERT INTO TABLE "$APP".dws_new_mid_day
  14.         SELECT
  15.                 ud.mid_id,
  16.                 ud.user_id,
  17.                 ud.version_code,
  18.                 ud.version_name,
  19.                 ud.lang,
  20.                 ud.source,
  21.                 ud.os,
  22.                 ud.area,
  23.                 ud.model,
  24.                 ud.brand,
  25.                 ud.sdk_version,
  26.                 ud.gmail,
  27.                 ud.height_width,
  28.                 ud.app_time,
  29.                 ud.network,
  30.                 ud.lng,
  31.                 ud.lat,
  32.                 '$do_date'
  33.         FROM "$APP".dws_uv_detail_day ud
  34.                 LEFT JOIN "$APP".dws_new_mid_day nm on ud.mid_id=nm.mid_id
  35.         WHERE ud.dt='$do_date' and nm.mid_id is null;
  36. "
  38. $hive -e "$sql"

最后是每日留存明细表

  1. create external table dws_user_retention_day 
  2. (
  3. `mid_id` string COMMENT '设备唯一标识',
  4. `user_id` string COMMENT '用户标识', 
  5. `version_code` string COMMENT '程序版本号', 
  6. `version_name` string COMMENT '程序版本名', 
  7. `lang` string COMMENT '系统语言', 
  8. `source` string COMMENT '渠道号', 
  9. `os` string COMMENT '安卓系统版本', 
  10. `area` string COMMENT '区域', 
  11. `model` string COMMENT '手机型号', 
  12. `brand` string COMMENT '手机品牌', 
  13. `sdk_version` string COMMENT 'sdkVersion', 
  14. `gmail` string COMMENT 'gmail', 
  15. `height_width` string COMMENT '屏幕宽高',
  16. `app_time` string COMMENT '客户端日志产生时的时间',
  17. `network` string COMMENT '网络模式',
  18. `lng` string COMMENT '经度',
  19. `lat` string COMMENT '纬度',
  20. `create_date`    string  comment '设备新增时间',
  21. `retention_day`  int comment '截止当前日期留存天数'
  22. )  COMMENT '每日用户留存情况'
  23. PARTITIONED BY (`dt` string)
  24. stored as parquet
  25. location '/warehouse/gmall/dws/dws_user_retention_day/';
  27. #step2. 从用户每日详情表导入数据，如果用户留存表里没有新的用户详情，则发现一个新增用户
  28. insert overwrite table dws_user_retention_day
  29. partition(dt="2020-08-19")
  30. select
  31.     nm.mid_id,
  32.     nm.user_id,
  33.     nm.version_code,
  34.     nm.version_name,
  35.     nm.lang,
  36.     nm.source,
  37.     nm.os,
  38.     nm.area,
  39.     nm.model,
  40.     nm.brand,
  41.     nm.sdk_version,
  42.     nm.gmail,
  43.     nm.height_width,
  44.     nm.app_time,
  45.     nm.network,
  46.     nm.lng,
  47.     nm.lat,
  48.     nm.create_date,
  49.     1 retention_day 
  50. from dws_uv_detail_day ud join dws_new_mid_day nm  on ud.mid_id =nm.mid_id 
  51. where ud.dt='2020-08-19' and nm.create_date=date_add('2020-08-19',-1)
  53. union all
  54. select  
  55.     nm.mid_id,
  56.     nm.user_id , 
  57.     nm.version_code , 
  58.     nm.version_name , 
  59.     nm.lang , 
  60.     nm.source, 
  61.     nm.os, 
  62.     nm.area, 
  63.     nm.model, 
  64.     nm.brand, 
  65.     nm.sdk_version, 
  66.     nm.gmail, 
  67.     nm.height_width,
  68.     nm.app_time,
  69.     nm.network,
  70.     nm.lng,
  71.     nm.lat,
  72.     nm.create_date,
  73.     2 retention_day 
  74. from  dws_uv_detail_day ud join dws_new_mid_day nm   on ud.mid_id =nm.mid_id 
  75. where ud.dt='2020-08-19' and nm.create_date=date_add('2020-08-19',-2)
  77. union all
  78. select  
  79.     nm.mid_id,
  80.     nm.user_id , 
  81.     nm.version_code , 
  82.     nm.version_name , 
  83.     nm.lang , 
  84.     nm.source, 
  85.     nm.os, 
  86.     nm.area, 
  87.     nm.model, 
  88.     nm.brand, 
  89.     nm.sdk_version, 
  90.     nm.gmail, 
  91.     nm.height_width,
  92.     nm.app_time,
  93.     nm.network,
  94.     nm.lng,
  95.     nm.lat,
  96.     nm.create_date,
  97.     3 retention_day 
  98. from  dws_uv_detail_day ud join dws_new_mid_day nm   on ud.mid_id =nm.mid_id 
  99. where ud.dt='2020-08-19' and nm.create_date=date_add('2020-08-19',-3);
  103. create external table ads_user_retention_day_count 
  104. (
  105. `create_date` string comment '设备新增日期',
  106. `retention_day` int comment '截止当前日期留存天数',
  107. `retention_count` bigint comment '留存数量'
  108. )  COMMENT '每日用户留存情况'
  109. row format delimited fields terminated by '\t'
  110. location '/warehouse/gmall/ads/ads_user_retention_day_count/';

发表评论

表情：
评论列表 （有 0 条评论，294人围观）

还没有评论，来说两句吧...

相关阅读