Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- test_admin@automation-test:~$ python3 pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
- age_segment event item_id item_topic item_type source_id \
- event_id
- 2931262 18-25 show 1793260 Красота native 8388799
- 2931277 18-25 show 7465641 Культура native 5837959
- 2931285 18-25 show 406073 История url 2335872
- 2931247 26-30 show 752665 Путешествия native 6963489
- 2931278 26-30 click 6843081 Юмор url 5427748
- source_topic source_type dt user_id
- event_id
- 2931262 История publisher 2019-09-24 18:27:37 2185026
- 2931277 История publisher 2019-09-24 18:27:37 6845238
- 2931285 Сад и дача domain 2019-09-24 18:27:38 5244363
- 2931247 Здоровье publisher 2019-09-24 18:27:37 7553074
- 2931278 Семейные отношения domain 2019-09-24 18:27:38 1317585
- visits
- item_topic source_topic age_segment dt
- Деньги Авто 18-25 2019-09-24 18:32:00 3
- 2019-09-24 18:35:00 1
- 2019-09-24 18:54:00 4
- 2019-09-24 18:55:00 17
- 2019-09-24 18:56:00 27
- unique_users
- dt item_topic event age_segment
- 2019-09-24 18:28:00 Деньги click 18-25 1
- 31-35 1
- 36-40 1
- show 18-25 13
- 26-30 1
- test_admin@automation-test:~$ sudo su postgres
- postgres@automation-test:/home/test_admin$ psql
- psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
- Type "help" for help.
- postgres=# \c zen
- You are now connected to database "zen" as user "postgres".
- zen=# \dt
- List of relations
- Schema | Name | Type | Owner
- --------+-----------------+-------+----------
- public | dash_engagement | table | postgres
- public | dash_visits | table | postgres
- public | log_raw | table | postgres
- (3 rows)
- zen=# SELECT * FROM dash_visits;
- record_id | item_topic | source_topic | age_segment | dt | visits
- -----------+------------+--------------+-------------+----+--------
- 1 | | | | | 3
- 2 | | | | | 1
- 3 | | | | | 4
- 4 | | | | | 17
- 5 | | | | | 27
- 6 | | | | | 22
- 7 | | | | | 24
- 8 | | | | | 20
- 9 | | | | | 5
- 10 | | | | | 1
- 11 | | | | | 1
- 12 | | | | | 1
- 13 | | | | | 1
- 14 | | | | | 4
- 15 | | | | | 13
- 16 | | | | | 18
- 17 | | | | | 15
- 18 | | | | | 13
- 19 | | | | | 13
- 20 | | | | | 5
- 21 | | | | | 1
- zen=# SELECT * FROM dash_engagement;
- record_id | dt | item_topic | event | age_segment | unique_users
- -----------+----+------------+-------+-------------+--------------
- 1 | | | | | 1
- 2 | | | | | 1
- 3 | | | | | 1
- 4 | | | | | 13
- 5 | | | | | 1
- 6 | | | | | 1
- 7 | | | | | 4
- 8 | | | | | 2
- 9 | | | | | 2
- 10 | | | | | 2
- 11 | | | | | 13
- 12 | | | | | 9
- 13 | | | | | 1
- 14 | | | | | 3
- 15 | | | | | 1
- 16 | | | | | 1
- 17 | | | | | 1
- 18 | | | | | 4
- 19 | | | | | 3
- 20 | | | | | 6
- 21 | | | | | 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement