Home > database >  Hive how SQL query table one source_channel (=1, for example) in the id for the first time access ti
Hive how SQL query table one source_channel (=1, for example) in the id for the first time access ti

Time:01-29

Select count (t.u ser_id)
The from (
The select user_id,
Count (distinct user_id) as c,
Min (start_mills) as ms,
Collect_set (source_channel) [0] as sc
The from b2cdc. P0_log_page
Where the date & gt;=20201201 and the date & lt;=20201231
Group by user_id
) t
Where t.s c=4

Is that a channel access id number for the first time, then the time can't write
  • Related