Hive 中,有表 t_view_log,数据如下:
uid |
url |
dt |
u001 |
www.taobao.com |
2023-11-11 |
u002 |
www.taobao.com |
2023-11-11 |
u001 |
www.taobao.com |
2023-11-11 |
u002 |
www.taobao.com |
2023-11-11 |
u003 |
www.tmall.com |
2023-11-10 |
u003 |
www.taobao.com |
2023-11-11 |