· 5 years ago · Feb 23, 2020, 06:24 PM
1avsaliy@MSK-6N0NWF2:~$ sudo apt update
2[sudo] password for avsaliy:
3Sorry, try again.
4[sudo] password for avsaliy:
5Hit:1 http://archive.ubuntu.com/ubuntu bionic InRelease
6Get:2 http://archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]
7Get:3 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]
8Get:4 http://archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]
9Get:5 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages [869 kB]
10Get:6 http://archive.ubuntu.com/ubuntu bionic-updates/main Translation-en [302 kB]
11Get:7 http://archive.ubuntu.com/ubuntu bionic-updates/restricted amd64 Packages [32.9 kB]
12Get:8 http://archive.ubuntu.com/ubuntu bionic-updates/restricted Translation-en [8468 B]
13Get:9 http://archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages [1055 kB]
14Get:10 http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages [650 kB]
15Get:11 http://security.ubuntu.com/ubuntu bionic-security/main Translation-en [211 kB]
16Get:12 http://security.ubuntu.com/ubuntu bionic-security/restricted amd64 Packages [23.8 kB]
17Get:13 http://security.ubuntu.com/ubuntu bionic-security/restricted Translation-en [6528 B]
18Get:14 http://security.ubuntu.com/ubuntu bionic-security/universe amd64 Packages [648 kB]
19Get:15 http://archive.ubuntu.com/ubuntu bionic-updates/universe Translation-en [327 kB]
20Get:16 http://security.ubuntu.com/ubuntu bionic-security/universe Translation-en [218 kB]
21Get:17 http://security.ubuntu.com/ubuntu bionic-security/multiverse amd64 Packages [6552 B]
22Get:18 http://security.ubuntu.com/ubuntu bionic-security/multiverse Translation-en [2668 B]
23Fetched 4613 kB in 4s (1157 kB/s)
24Reading package lists... Done
25Building dependency tree
26Reading state information... Done
27142 packages can be upgraded. Run 'apt list --upgradable' to see them.
28avsaliy@MSK-6N0NWF2:~$ sudo apt install postgresql postgresql-contrib
29Reading package lists... Done
30Building dependency tree
31Reading state information... Done
32postgresql is already the newest version (10+190ubuntu0.1).
33postgresql-contrib is already the newest version (10+190ubuntu0.1).
34The following package was automatically installed and is no longer required:
35 libfreetype6
36Use 'sudo apt autoremove' to remove it.
370 upgraded, 0 newly installed, 0 to remove and 142 not upgraded.
38avsaliy@MSK-6N0NWF2:~$ sudo service postgresql start
39 * Starting PostgreSQL 10 database server [ OK ]
40avsaliy@MSK-6N0NWF2:~$ service postgresql status
4110/main (port 5433): online
42avsaliy@MSK-6N0NWF2:~$ sudo su postgres
43postgres@MSK-6N0NWF2:/home/avsaliy$ createdb zen --encoding='utf-8'
44createdb: database creation failed: ERROR: database "zen" already exists
45postgres@MSK-6N0NWF2:/home/avsaliy$ psql
46psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
47Type "help" for help.
48
49postgres=# \c zen
50You are now connected to database "zen" as user "postgres".
51zen=# CREATE USER my_user WITH ENCRYPTED PASSWORD 'my_user_password';
52ERROR: role "my_user" already exists
53zen=# \q
54postgres@MSK-6N0NWF2:/home/avsaliy$ pg_restore -d zen /mnt/c/Users/avsaliy/Downloads/zen.dump
55pg_restore: [archiver (db)] Error while PROCESSING TOC:
56pg_restore: [archiver (db)] Error from TOC entry 197; 1259 40990 TABLE log_raw postgres
57pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw" already exists
58 Command was: CREATE TABLE public.log_raw (
59 event_id integer NOT NULL,
60 age_segment character varying(128),
61 event character varying(128),
62 item_id bigint,
63 item_topic character varying(128),
64 item_type character varying(128),
65 source_id bigint,
66 source_topic character varying(128),
67 source_type character varying(128),
68 ts bigint,
69 user_id bigint
70);
71
72
73
74pg_restore: [archiver (db)] Error from TOC entry 196; 1259 40988 SEQUENCE log_raw_event_id_seq postgres
75pg_restore: [archiver (db)] could not execute query: ERROR: relation "log_raw_event_id_seq" already exists
76 Command was: CREATE SEQUENCE public.log_raw_event_id_seq
77 AS integer
78 START WITH 1
79 INCREMENT BY 1
80 NO MINVALUE
81 NO MAXVALUE
82 CACHE 1;
83
84
85
86pg_restore: [archiver (db)] Error from TOC entry 2876; 0 40990 TABLE DATA log_raw postgres
87pg_restore: [archiver (db)] COPY failed for table "log_raw": ERROR: duplicate key value violates unique constraint "log_raw_pkey"
88DETAIL: Key (event_id)=(2931262) already exists.
89CONTEXT: COPY log_raw, line 1
90pg_restore: [archiver (db)] Error from TOC entry 2753; 2606 40998 CONSTRAINT log_raw log_raw_pkey postgres
91pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "log_raw" are not allowed
92 Command was: ALTER TABLE ONLY public.log_raw
93 ADD CONSTRAINT log_raw_pkey PRIMARY KEY (event_id);
94
95
96
97WARNING: errors ignored on restore: 4
98postgres@MSK-6N0NWF2:/home/avsaliy$ psql
99psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
100Type "help" for help.
101
102postgres=# \c zen
103You are now connected to database "zen" as user "postgres".
104zen=# \dt
105 List of relations
106 Schema | Name | Type | Owner
107--------+---------+-------+----------
108 public | log_raw | table | postgres
109(1 row)
110
111zen=# select count(*) from log_raw;
112 count
113--------
114 322391
115(1 row)
116
117zen=# select count(*)
118zen-# from (select distinct age_segment,
119zen(# item_topic,
120zen(# source_topic,
121zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
122zen(# from log_raw
123zen(# );
124ERROR: subquery in FROM must have an alias
125LINE 2: from (select distinct age_segment,
126 ^
127HINT: For example, FROM (SELECT ...) [AS] foo.
128zen=# select count(*)
129zen-# from (select distinct age_segment,
130zen(# item_topic,
131zen(# source_topic,
132zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
133zen(# from log_raw
134zen(# )
135zen-#
136zen-# select count(*)
137zen-# from (select distinct age_segment,
138zen(# item_topic,
139zen(# source_topic,
140zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
141zen(# from log_raw
142zen(# )
143zen-# select count(*)
144zen-# from (select distinct age_segment,
145zen(# item_topic,
146zen(# source_topic,
147zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
148zen(# from log_raw
149zen(# );
150ERROR: subquery in FROM must have an alias
151LINE 2: from (select distinct age_segment,
152 ^
153HINT: For example, FROM (SELECT ...) [AS] foo.
154zen=# select count(*)
155zen-# from (select distinct age_segment,
156zen(# item_topic,
157zen(# source_topic,
158zen(# date_trunc('minute', to_timestamp(ts / 1000)) as dt
159zen(# from log_raw
160zen(# ) as t;
161 count
162-------
163 31828
164(1 row)
165
166zen=# CREATE TABLE dash_engagement(record_id serial PRIMARY KEY,
167zen(# dt TIMESTAMP,
168zen(# item_topic VARCHAR(1024),
169zen(# event VARCHAR (32),
170zen(# age_segment VARCHAR(128),
171zen(# unique_users BIGINT);
172CREATE TABLE
173zen=# select * from dash_engagement
174zen-# select * from dash_engagement;
175ERROR: syntax error at or near "select"
176LINE 2: select * from dash_engagement;
177 ^
178zen=# GRANT ALL PRIVILEGES ON TABLE dash_engagement TO my_user;
179GRANT
180zen=# GRANT USAGE, SELECT ON SEQUENCE dash_engagement_record_id_seq TO my_user;
181GRANT
182zen=# select * from dash_engagement;
183 record_id | dt | item_topic | event | age_segment | unique_users
184-----------+----+------------+-------+-------------+--------------
185(0 rows)
186
187zen=# CREATE TABLE dash_visits(
188zen(# record_id serial PRIMARY KEY,
189zen(# item_topic VARCHAR(1024),
190zen(# source_topic VARCHAR(1024),
191zen(# age_segment VARCHAR(128),
192zen(# dt TIMESTAMP,
193zen(# visits INT
194zen(# );
195CREATE TABLE
196zen=# GRANT ALL PRIVILEGES ON TABLE dash_visits TO my_user;
197GRANT
198zen=# GRANT USAGE, SELECT ON SEQUENCE dash_visits_record_id_seq TO my_user;
199GRANT
200zen=# select * from dash_visits
201zen-# select * from dash_visits;
202ERROR: syntax error at or near "select"
203LINE 2: select * from dash_visits;
204 ^
205zen=# select * from dash_visits;
206 record_id | item_topic | source_topic | age_segment | dt | visits
207-----------+------------+--------------+-------------+----+--------
208(0 rows)
209
210zen=# sudo su postgres
211zen-# psql
212zen-# sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/zen_pipeline.py
213zen-# /dt
214zen-# psql /dt
215zen-# \q
216postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/zen_pipeline.py
217[sudo] password for postgres:
218Sorry, try again.
219[sudo] password for postgres:
220Sorry, try again.
221[sudo] password for postgres:
222sudo: 3 incorrect password attempts
223postgres@MSK-6N0NWF2:/home/avsaliy$ psql /dt
224psql: FATAL: database "/dt" does not exist
225postgres@MSK-6N0NWF2:/home/avsaliy$ /dt
226bash: /dt: No such file or directory
227postgres@MSK-6N0NWF2:/home/avsaliy$ psql \dt
228psql: FATAL: database "dt" does not exist
229postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/zen_pipeline.py
230[sudo] password for postgres:
231Sorry, try again.
232[sudo] password for postgres:
233Sorry, try again.
234[sudo] password for postgres:
235sudo: 3 incorrect password attempts
236postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/zen_pipeline.py
237[sudo] password for postgres:
238Sorry, try again.
239[sudo] password for postgres:
240Sorry, try again.
241[sudo] password for postgres:
242sudo: 3 incorrect password attempts
243postgres@MSK-6N0NWF2:/home/avsaliy$ sudo su postgres
244[sudo] password for postgres:
245Sorry, try again.
246[sudo] password for postgres:
247Sorry, try again.
248[sudo] password for postgres:
249sudo: 3 incorrect password attempts
250postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/
251[sudo] password for postgres:
252Sorry, try again.
253[sudo] password for postgres:
254Sorry, try again.
255[sudo] password for postgres:
256sudo: 3 incorrect password attempts
257postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/
258[sudo] password for postgres:
259Sorry, try again.
260[sudo] password for postgres:
261
262Sorry, try again.
263[sudo] password for postgres:
264
265sudo: 3 incorrect password attempts
266postgres@MSK-6N0NWF2:/home/avsaliy$
267postgres@MSK-6N0NWF2:/home/avsaliy$ exit
268exit
269avsaliy@MSK-6N0NWF2:~$ sudo su postgres
270[sudo] password for avsaliy:
271postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/
272[sudo] password for postgres:
273Sorry, try again.
274[sudo] password for postgres:
275Sorry, try again.
276[sudo] password for postgres:
277sudo: 3 incorrect password attempts
278postgres@MSK-6N0NWF2:/home/avsaliy$ /usr/bin/psql -d template1
279psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
280Type "help" for help.
281
282template1=# alter user postgres with password postgres
283template1-# \c postgres
284You are now connected to database "postgres" as user "postgres".
285postgres-# \password postgres
286Enter new password:
287Enter it again:
288postgres-# /home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/
289postgres-# exit
290postgres-# exit
291postgres-# \q
292postgres@MSK-6N0NWF2:/home/avsaliy$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/
293[sudo] password for postgres:
294Sorry, try again.
295[sudo] password for postgres:
296Sorry, try again.
297[sudo] password for postgres:
298sudo: 3 incorrect password attempts
299postgres@MSK-6N0NWF2:/home/avsaliy$ \q
300
301Command 'q' not found, but can be installed with:
302
303apt install python-q-text-as-data
304apt install python3-q-text-as-data
305
306Ask your administrator to install one of them.
307
308postgres@MSK-6N0NWF2:/home/avsaliy$ exit
309exit
310avsaliy@MSK-6N0NWF2:~$ sudo cp C:/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/
311cp: cannot stat 'C:/Users/avsaliy/Documents/zen_pipeline.py': No such file or directory
312avsaliy@MSK-6N0NWF2:~$ sudo cp /mnt/c/Users/avsaliy/Documents/zen_pipeline.py /home/test_user/code/zen_pipeline.py
313cp: cannot create regular file '/home/test_user/code/zen_pipeline.py': No such file or directory
314avsaliy@MSK-6N0NWF2:~$ mkdir /home/test_user/code/
315mkdir: cannot create directory ‘/home/test_user/code/’: No such file or directory
316avsaliy@MSK-6N0NWF2:~$ mkdir /home/test_user/
317mkdir: cannot create directory ‘/home/test_user/’: Permission denied
318avsaliy@MSK-6N0NWF2:~$ python /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
319
320Command 'python' not found, but can be installed with:
321
322sudo apt install python3
323sudo apt install python
324sudo apt install python-minimal
325
326You also have python3 installed, you can run 'python3' instead.
327
328avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
329 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 16
330 fullCmdArguments = sys.argv
331 ^
332IndentationError: unexpected indent
333avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
334 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 22
335 getopt.error as err:
336 ^
337SyntaxError: invalid syntax
338avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
339 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 22
340 getopt.error as err: print (str(err))
341 ^
342SyntaxError: invalid syntax
343avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
344 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 22
345 getopt.error as err
346 ^
347SyntaxError: invalid syntax
348avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
349 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
350 query = ''' SELECT *,
351 ^
352IndentationError: unexpected indent
353avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
354 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
355 query = ''' SELECT event_id,
356 ^
357IndentationError: unexpected indent
358avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
359 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
360 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(unix_timestamp_field / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
361 ^
362IndentationError: unexpected indent
363avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
364 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
365 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
366 ^
367IndentationError: unexpected indent
368avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
369 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
370 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
371 ^
372IndentationError: unexpected indent
373avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
374 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
375 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP('timestamp' / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
376 ^
377IndentationError: unexpected indent
378avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
379 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
380 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP("timestamp" / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
381 ^
382IndentationError: unexpected indent
383avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
384 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
385 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
386 ^
387IndentationError: unexpected indent
388avsaliy@MSK-6N0NWF2:~$ \c zen
389c: command not found
390avsaliy@MSK-6N0NWF2:~$ psql
391psql: FATAL: role "avsaliy" does not exist
392avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
393 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
394 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
395 ^
396IndentationError: unexpected indent
397avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py
398 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
399 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
400 ^
401IndentationError: unexpected indent
402avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='18:00:00 2019-09-24' --end_dt='19:00:00 2019-09-24'
403 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
404 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
405 ^
406IndentationError: unexpected indent
407avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='18:00:00 2019-09-24' --end_dt='19:00:00 2019-09-24'
408 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
409 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
410 ^
411IndentationError: unexpected indent
412avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
413 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
414 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
415 ^
416IndentationError: unexpected indent
417avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
418 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
419 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
420 ^
421IndentationError: unexpected indent
422avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24' --end_dt='2019-09-25'
423 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
424 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
425 ^
426IndentationError: unexpected indent
427avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24' --end_dt='2019-09-25'
428 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
429 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
430 ^
431IndentationError: unexpected indent
432avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
433 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
434 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
435 ^
436IndentationError: unexpected indent
437avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
438 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
439 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
440 ^
441IndentationError: unexpected indent
442avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
443 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
444 query = ''' SELECT event_id,age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt FROM log_raw
445 ^
446IndentationError: unexpected indent
447avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
448 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
449 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, user_id,
450 ^
451IndentationError: unexpected indent
452avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
453 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
454 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt , user_id
455 ^
456IndentationError: unexpected indent
457avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
458 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
459 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, TO_TIMESTAMP(timestamp / 1000) AT TIME ZONE 'Etc/UTC' AS dt , user_id
460 ^
461IndentationError: unexpected indent
462avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
463 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
464 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt , user_id
465 ^
466IndentationError: unexpected indent
467avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00'::timestamp --end_dt='2019-09-24 19:00:00'::timestamp
468 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
469 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt , user_id
470 ^
471IndentationError: unexpected indent
472avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00'::timestamp and --end_dt='2019-09-24 19:00:00'::timestamp
473 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 48
474 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type, TO_TIMESTAMP(ts / 1000) AT TIME ZONE 'Etc/UTC' AS dt , user_id
475 ^
476IndentationError: unexpected indent
477avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00'::timestamp and --end_dt='2019-09-24 19:00:00'::timestamp
478 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 47
479 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type,
480 ^
481IndentationError: unindent does not match any outer indentation level
482avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00'::timestamp and --end_dt='2019-09-24 19:00:00'::timestamp
483 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 47
484 query = ''' SELECT event_id, age_segment, event, item_id, item_topic, item_type, source_id, source_topic, source_type,
485 ^
486IndentationError: unindent does not match any outer indentation level
487avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00'::timestamp and --end_dt='2019-09-24 19:00:00'::timestamp
488Traceback (most recent call last):
489 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
490 import pandas as pd
491ModuleNotFoundError: No module named 'pandas'
492avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00'::timestamp and --end_dt='2019-09-24 19:00:00'::timestamp
493Traceback (most recent call last):
494 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
495 import pandas as pd
496ModuleNotFoundError: No module named 'pandas'
497avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
498Traceback (most recent call last):
499 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
500 import pandas as pd
501ModuleNotFoundError: No module named 'pandas'
502avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
503Traceback (most recent call last):
504 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
505 import pandas as pd
506ModuleNotFoundError: No module named 'pandas'
507avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
508Traceback (most recent call last):
509 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
510 import pandas as pd
511ModuleNotFoundError: No module named 'pandas'
512avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
513Traceback (most recent call last):
514 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
515 import pandas as pd
516ModuleNotFoundError: No module named 'pandas'
517avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
518Traceback (most recent call last):
519 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
520 import pandas as pd
521ModuleNotFoundError: No module named 'pandas'
522avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
523Traceback (most recent call last):
524 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
525 import pandas as pd
526ModuleNotFoundError: No module named 'pandas'
527avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
528Traceback (most recent call last):
529 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
530 import pandas as pd
531ModuleNotFoundError: No module named 'pandas'
532avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
533Traceback (most recent call last):
534 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 7, in <module>
535 import pandas as pd
536ModuleNotFoundError: No module named 'pandas'
537avsaliy@MSK-6N0NWF2:~$ sudo pip3 install pandas
538[sudo] password for avsaliy:
539sudo: pip3: command not found
540avsaliy@MSK-6N0NWF2:~$ sudo apt update
541Get:1 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]
542Hit:2 http://archive.ubuntu.com/ubuntu bionic InRelease
543Get:3 http://archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]
544Get:4 http://archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]
545Get:5 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages [871 kB]
546Get:6 http://archive.ubuntu.com/ubuntu bionic-updates/main Translation-en [303 kB]
547Get:7 http://archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages [1053 kB]
548Get:8 http://archive.ubuntu.com/ubuntu bionic-updates/universe Translation-en [326 kB]
549Fetched 2804 kB in 16s (177 kB/s)
550Reading package lists... Done
551Building dependency tree
552Reading state information... Done
553142 packages can be upgraded. Run 'apt list --upgradable' to see them.
554avsaliy@MSK-6N0NWF2:~$ sudo apt install python3-pip
555Reading package lists... Done
556Building dependency tree
557Reading state information... Done
558The following package was automatically installed and is no longer required:
559 libfreetype6
560Use 'sudo apt autoremove' to remove it.
561The following additional packages will be installed:
562 binutils binutils-common binutils-x86-64-linux-gnu build-essential cpp cpp-7 dh-python dpkg-dev fakeroot g++ g++-7 gcc gcc-7 gcc-7-base
563 gcc-8-base libalgorithm-diff-perl libalgorithm-diff-xs-perl libalgorithm-merge-perl libasan4 libatomic1 libbinutils libc-dev-bin
564 libc6-dev libcc1-0 libcilkrts5 libdpkg-perl libexpat1 libexpat1-dev libfakeroot libfile-fcntllock-perl libgcc-7-dev libgcc1 libgomp1
565 libisl19 libitm1 liblsan0 libmpc3 libmpx2 libpython3-dev libpython3.6 libpython3.6-dev libpython3.6-minimal libpython3.6-stdlib
566 libquadmath0 libssl1.1 libstdc++-7-dev libstdc++6 libtsan0 libubsan0 linux-libc-dev make manpages-dev python-pip-whl python3-crypto
567 python3-dev python3-distutils python3-keyring python3-keyrings.alt python3-lib2to3 python3-secretstorage python3-setuptools python3-wheel
568 python3-xdg python3.6 python3.6-dev python3.6-minimal
569Suggested packages:
570 binutils-doc cpp-doc gcc-7-locales debian-keyring g++-multilib g++-7-multilib gcc-7-doc libstdc++6-7-dbg gcc-multilib autoconf automake
571 libtool flex bison gdb gcc-doc gcc-7-multilib libgcc1-dbg libgomp1-dbg libitm1-dbg libatomic1-dbg libasan4-dbg liblsan0-dbg libtsan0-dbg
572 libubsan0-dbg libcilkrts5-dbg libmpx2-dbg libquadmath0-dbg glibc-doc bzr libstdc++-7-doc make-doc python-crypto-doc gnome-keyring
573 libkf5wallet-bin gir1.2-gnomekeyring-1.0 python-secretstorage-doc python-setuptools-doc python3.6-venv python3.6-doc binfmt-support
574The following NEW packages will be installed:
575 binutils binutils-common binutils-x86-64-linux-gnu build-essential cpp cpp-7 dh-python dpkg-dev fakeroot g++ g++-7 gcc gcc-7 gcc-7-base
576 libalgorithm-diff-perl libalgorithm-diff-xs-perl libalgorithm-merge-perl libasan4 libatomic1 libbinutils libc-dev-bin libc6-dev libcc1-0
577 libcilkrts5 libdpkg-perl libexpat1-dev libfakeroot libfile-fcntllock-perl libgcc-7-dev libgomp1 libisl19 libitm1 liblsan0 libmpc3 libmpx2
578 libpython3-dev libpython3.6-dev libquadmath0 libstdc++-7-dev libtsan0 libubsan0 linux-libc-dev make manpages-dev python-pip-whl
579 python3-crypto python3-dev python3-distutils python3-keyring python3-keyrings.alt python3-lib2to3 python3-pip python3-secretstorage
580 python3-setuptools python3-wheel python3-xdg python3.6-dev
581The following packages will be upgraded:
582 gcc-8-base libexpat1 libgcc1 libpython3.6 libpython3.6-minimal libpython3.6-stdlib libssl1.1 libstdc++6 python3.6 python3.6-minimal
58310 upgraded, 57 newly installed, 0 to remove and 132 not upgraded.
584Need to get 92.6 MB of archives.
585After this operation, 249 MB of additional disk space will be used.
586Do you want to continue? [Y/n] Y
587Get:1 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libexpat1 amd64 2.2.5-3ubuntu0.2 [80.5 kB]
588Get:2 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython3.6 amd64 3.6.9-1~18.04 [1414 kB]
589Get:3 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libssl1.1 amd64 1.1.1-1ubuntu2.1~18.04.5 [1300 kB]
590Get:4 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3.6 amd64 3.6.9-1~18.04 [203 kB]
591Get:5 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3.6-minimal amd64 3.6.9-1~18.04 [1610 kB]
592Get:6 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython3.6-stdlib amd64 3.6.9-1~18.04 [1709 kB]
593Get:7 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython3.6-minimal amd64 3.6.9-1~18.04 [533 kB]
594Get:8 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 gcc-8-base amd64 8.3.0-6ubuntu1~18.04.1 [18.7 kB]
595Get:9 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libstdc++6 amd64 8.3.0-6ubuntu1~18.04.1 [400 kB]
596Get:10 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libgcc1 amd64 1:8.3.0-6ubuntu1~18.04.1 [40.7 kB]
597Get:11 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 binutils-common amd64 2.30-21ubuntu1~18.04.2 [193 kB]
598Get:12 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libbinutils amd64 2.30-21ubuntu1~18.04.2 [503 kB]
599Get:13 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 binutils-x86-64-linux-gnu amd64 2.30-21ubuntu1~18.04.2 [1856 kB]
600Get:14 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 binutils amd64 2.30-21ubuntu1~18.04.2 [3396 B]
601Get:15 http://archive.ubuntu.com/ubuntu bionic/main amd64 libc-dev-bin amd64 2.27-3ubuntu1 [71.8 kB]
602Get:16 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 linux-libc-dev amd64 4.15.0-88.88 [1022 kB]
603Get:17 http://archive.ubuntu.com/ubuntu bionic/main amd64 libc6-dev amd64 2.27-3ubuntu1 [2587 kB]
604Get:18 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 gcc-7-base amd64 7.4.0-1ubuntu1~18.04.1 [18.9 kB]
605Get:19 http://archive.ubuntu.com/ubuntu bionic/main amd64 libisl19 amd64 0.19-1 [551 kB]
606Get:20 http://archive.ubuntu.com/ubuntu bionic/main amd64 libmpc3 amd64 1.1.0-1 [40.8 kB]
607Get:21 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 cpp-7 amd64 7.4.0-1ubuntu1~18.04.1 [6742 kB]
608Get:22 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 cpp amd64 4:7.4.0-1ubuntu2.3 [27.7 kB]
609Get:23 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libcc1-0 amd64 8.3.0-6ubuntu1~18.04.1 [47.4 kB]
610Get:24 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libgomp1 amd64 8.3.0-6ubuntu1~18.04.1 [76.4 kB]
611Get:25 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libitm1 amd64 8.3.0-6ubuntu1~18.04.1 [28.0 kB]
612Get:26 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libatomic1 amd64 8.3.0-6ubuntu1~18.04.1 [9184 B]
613Get:27 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libasan4 amd64 7.4.0-1ubuntu1~18.04.1 [359 kB]
614Get:28 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 liblsan0 amd64 8.3.0-6ubuntu1~18.04.1 [133 kB]
615Get:29 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libtsan0 amd64 8.3.0-6ubuntu1~18.04.1 [288 kB]
616Get:30 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libubsan0 amd64 7.4.0-1ubuntu1~18.04.1 [126 kB]
617Get:31 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libcilkrts5 amd64 7.4.0-1ubuntu1~18.04.1 [42.5 kB]
618Get:32 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libmpx2 amd64 8.3.0-6ubuntu1~18.04.1 [11.6 kB]
619Get:33 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libquadmath0 amd64 8.3.0-6ubuntu1~18.04.1 [133 kB]
620Get:34 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libgcc-7-dev amd64 7.4.0-1ubuntu1~18.04.1 [2381 kB]
621Get:35 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 gcc-7 amd64 7.4.0-1ubuntu1~18.04.1 [7463 kB]
622Get:36 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 gcc amd64 4:7.4.0-1ubuntu2.3 [5184 B]
623Get:37 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libstdc++-7-dev amd64 7.4.0-1ubuntu1~18.04.1 [1468 kB]
624Get:38 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 g++-7 amd64 7.4.0-1ubuntu1~18.04.1 [7574 kB]
625Get:39 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 g++ amd64 4:7.4.0-1ubuntu2.3 [1568 B]
626Get:40 http://archive.ubuntu.com/ubuntu bionic/main amd64 make amd64 4.1-9.1ubuntu1 [154 kB]
627Get:41 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libdpkg-perl all 1.19.0.5ubuntu2.3 [211 kB]
628Get:42 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 dpkg-dev all 1.19.0.5ubuntu2.3 [607 kB]
629Get:43 http://archive.ubuntu.com/ubuntu bionic/main amd64 build-essential amd64 12.4ubuntu1 [4758 B]
630Get:44 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3-lib2to3 all 3.6.9-1~18.04 [77.4 kB]
631Get:45 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3-distutils all 3.6.9-1~18.04 [144 kB]
632Get:46 http://archive.ubuntu.com/ubuntu bionic/main amd64 dh-python all 3.20180325ubuntu2 [89.2 kB]
633Get:47 http://archive.ubuntu.com/ubuntu bionic/main amd64 libfakeroot amd64 1.22-2ubuntu1 [25.9 kB]
634Get:48 http://archive.ubuntu.com/ubuntu bionic/main amd64 fakeroot amd64 1.22-2ubuntu1 [62.3 kB]
635Get:49 http://archive.ubuntu.com/ubuntu bionic/main amd64 libalgorithm-diff-perl all 1.19.03-1 [47.6 kB]
636Get:50 http://archive.ubuntu.com/ubuntu bionic/main amd64 libalgorithm-diff-xs-perl amd64 0.04-5 [11.1 kB]
637Get:51 http://archive.ubuntu.com/ubuntu bionic/main amd64 libalgorithm-merge-perl all 0.08-3 [12.0 kB]
638Get:52 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libexpat1-dev amd64 2.2.5-3ubuntu0.2 [122 kB]
639Get:53 http://archive.ubuntu.com/ubuntu bionic/main amd64 libfile-fcntllock-perl amd64 0.22-3build2 [33.2 kB]
640Get:54 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython3.6-dev amd64 3.6.9-1~18.04 [44.8 MB]
641Get:55 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 libpython3-dev amd64 3.6.7-1~18.04 [7328 B]
642Get:56 http://archive.ubuntu.com/ubuntu bionic/main amd64 manpages-dev all 4.15-1 [2217 kB]
643Get:57 http://archive.ubuntu.com/ubuntu bionic-updates/universe amd64 python-pip-whl all 9.0.1-2.3~ubuntu1.18.04.1 [1653 kB]
644Get:58 http://archive.ubuntu.com/ubuntu bionic/main amd64 python3-crypto amd64 2.6.1-8ubuntu2 [244 kB]
645Get:59 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3.6-dev amd64 3.6.9-1~18.04 [508 kB]
646Get:60 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3-dev amd64 3.6.7-1~18.04 [1288 B]
647Get:61 http://archive.ubuntu.com/ubuntu bionic/main amd64 python3-secretstorage all 2.3.1-2 [12.1 kB]
648Get:62 http://archive.ubuntu.com/ubuntu bionic/main amd64 python3-keyring all 10.6.0-1 [26.7 kB]
649Get:63 http://archive.ubuntu.com/ubuntu bionic/main amd64 python3-keyrings.alt all 3.0-1 [16.6 kB]
650Get:64 http://archive.ubuntu.com/ubuntu bionic-updates/universe amd64 python3-pip all 9.0.1-2.3~ubuntu1.18.04.1 [114 kB]
651Get:65 http://archive.ubuntu.com/ubuntu bionic/main amd64 python3-setuptools all 39.0.1-2 [248 kB]
652Get:66 http://archive.ubuntu.com/ubuntu bionic/universe amd64 python3-wheel all 0.30.0-0.2 [36.5 kB]
653Get:67 http://archive.ubuntu.com/ubuntu bionic/main amd64 python3-xdg all 0.25-4ubuntu1 [31.4 kB]
654Fetched 92.6 MB in 45s (2044 kB/s)
655Extracting templates from packages: 100%
656Preconfiguring packages ...
657(Reading database ... 29462 files and directories currently installed.)
658Preparing to unpack .../0-libexpat1_2.2.5-3ubuntu0.2_amd64.deb ...
659Unpacking libexpat1:amd64 (2.2.5-3ubuntu0.2) over (2.2.5-3) ...
660Preparing to unpack .../1-libpython3.6_3.6.9-1~18.04_amd64.deb ...
661Unpacking libpython3.6:amd64 (3.6.9-1~18.04) over (3.6.7-1~18.04) ...
662Preparing to unpack .../2-libssl1.1_1.1.1-1ubuntu2.1~18.04.5_amd64.deb ...
663Unpacking libssl1.1:amd64 (1.1.1-1ubuntu2.1~18.04.5) over (1.1.0g-2ubuntu4.3) ...
664Preparing to unpack .../3-python3.6_3.6.9-1~18.04_amd64.deb ...
665Unpacking python3.6 (3.6.9-1~18.04) over (3.6.7-1~18.04) ...
666Preparing to unpack .../4-python3.6-minimal_3.6.9-1~18.04_amd64.deb ...
667Unpacking python3.6-minimal (3.6.9-1~18.04) over (3.6.7-1~18.04) ...
668Preparing to unpack .../5-libpython3.6-stdlib_3.6.9-1~18.04_amd64.deb ...
669Unpacking libpython3.6-stdlib:amd64 (3.6.9-1~18.04) over (3.6.7-1~18.04) ...
670
671Progress: [ 2%] [##.....................................................................................................................]
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688Progress: [ 4%] [####...................................................................................................................]
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710Progress: [ 5%] [######.................................................................................................................] Preparing to unpack .../6-libpython3.6-minimal_3.6.9-1~18.04_amd64.deb ...
711Unpacking libpython3.6-minimal:amd64 (3.6.9-1~18.04) over (3.6.7-1~18.04) ...
712Preparing to unpack .../7-gcc-8-base_8.3.0-6ubuntu1~18.04.1_amd64.deb ...................................................................]
713Unpacking gcc-8-base:amd64 (8.3.0-6ubuntu1~18.04.1) over (8.3.0-6ubuntu1~18.04) ...
714Setting up gcc-8-base:amd64 (8.3.0-6ubuntu1~18.04.1) ....................................................................................]
715(Reading database ... 29463 files and directories currently installed.)
716Preparing to unpack .../libstdc++6_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
717Unpacking libstdc++6:amd64 (8.3.0-6ubuntu1~18.04.1) over (8.3.0-6ubuntu1~18.04) .........................................................]
718Setting up libstdc++6:amd64 (8.3.0-6ubuntu1~18.04.1) ...
719(Reading database ... 29463 files and directories currently installed.)..................................................................]
720Preparing to unpack .../libgcc1_1%3a8.3.0-6ubuntu1~18.04.1_amd64.deb ...
721Unpacking libgcc1:amd64 (1:8.3.0-6ubuntu1~18.04.1) over (1:8.3.0-6ubuntu1~18.04) ...
722Setting up libgcc1:amd64 (1:8.3.0-6ubuntu1~18.04.1) .....................................................................................]
723Selecting previously unselected package binutils-common:amd64.
724(Reading database ... 29463 files and directories currently installed.)
725Preparing to unpack .../00-binutils-common_2.30-21ubuntu1~18.04.2_amd64.deb ...
726Unpacking binutils-common:amd64 (2.30-21ubuntu1~18.04.2) ................................................................................]
727Selecting previously unselected package libbinutils:amd64.
728Preparing to unpack .../01-libbinutils_2.30-21ubuntu1~18.04.2_amd64.deb ...
729Unpacking libbinutils:amd64 (2.30-21ubuntu1~18.04.2) ...
730Selecting previously unselected package binutils-x86-64-linux-gnu........................................................................]
731Preparing to unpack .../02-binutils-x86-64-linux-gnu_2.30-21ubuntu1~18.04.2_amd64.deb ...
732Unpacking binutils-x86-64-linux-gnu (2.30-21ubuntu1~18.04.2) ...
733Selecting previously unselected package binutils.........................................................................................]
734Preparing to unpack .../03-binutils_2.30-21ubuntu1~18.04.2_amd64.deb ...
735Unpacking binutils (2.30-21ubuntu1~18.04.2) ...
736Selecting previously unselected package libc-dev-bin.....................................................................................]
737Preparing to unpack .../04-libc-dev-bin_2.27-3ubuntu1_amd64.deb ...
738Unpacking libc-dev-bin (2.27-3ubuntu1) ...
739Selecting previously unselected package linux-libc-dev:amd64.............................................................................]
740Preparing to unpack .../05-linux-libc-dev_4.15.0-88.88_amd64.deb ...
741Unpacking linux-libc-dev:amd64 (4.15.0-88.88) ...
742Selecting previously unselected package libc6-dev:amd64..................................................................................]
743Preparing to unpack .../06-libc6-dev_2.27-3ubuntu1_amd64.deb ...
744Unpacking libc6-dev:amd64 (2.27-3ubuntu1) ...
745Selecting previously unselected package gcc-7-base:amd64.
746Preparing to unpack .../07-gcc-7-base_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
747Unpacking gcc-7-base:amd64 (7.4.0-1ubuntu1~18.04.1) .....................................................................................]
748Selecting previously unselected package libisl19:amd64.
749Preparing to unpack .../08-libisl19_0.19-1_amd64.deb ...
750Unpacking libisl19:amd64 (0.19-1) ...##..................................................................................................]
751Selecting previously unselected package libmpc3:amd64.
752Preparing to unpack .../09-libmpc3_1.1.0-1_amd64.deb ...
753Unpacking libmpc3:amd64 (1.1.0-1) ...###.................................................................................................]
754Selecting previously unselected package cpp-7.
755Preparing to unpack .../10-cpp-7_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
756Unpacking cpp-7 (7.4.0-1ubuntu1~18.04.1) ...
757Selecting previously unselected package cpp..............................................................................................]
758Preparing to unpack .../11-cpp_4%3a7.4.0-1ubuntu2.3_amd64.deb ...
759Unpacking cpp (4:7.4.0-1ubuntu2.3) ...
760Selecting previously unselected package libcc1-0:amd64...................................................................................]
761Preparing to unpack .../12-libcc1-0_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
762Unpacking libcc1-0:amd64 (8.3.0-6ubuntu1~18.04.1) ...
763Selecting previously unselected package libgomp1:amd64...................................................................................]
764Preparing to unpack .../13-libgomp1_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
765Unpacking libgomp1:amd64 (8.3.0-6ubuntu1~18.04.1) ...
766Selecting previously unselected package libitm1:amd64....................................................................................]
767Preparing to unpack .../14-libitm1_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
768Unpacking libitm1:amd64 (8.3.0-6ubuntu1~18.04.1) ...
769Selecting previously unselected package libatomic1:amd64.................................................................................]
770Preparing to unpack .../15-libatomic1_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
771Unpacking libatomic1:amd64 (8.3.0-6ubuntu1~18.04.1) ...
772Selecting previously unselected package libasan4:amd64...................................................................................]
773Preparing to unpack .../16-libasan4_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
774Unpacking libasan4:amd64 (7.4.0-1ubuntu1~18.04.1) ...
775Selecting previously unselected package liblsan0:amd64.
776Preparing to unpack .../17-liblsan0_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
777Unpacking liblsan0:amd64 (8.3.0-6ubuntu1~18.04.1) .......................................................................................]
778Selecting previously unselected package libtsan0:amd64.
779Preparing to unpack .../18-libtsan0_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
780Unpacking libtsan0:amd64 (8.3.0-6ubuntu1~18.04.1) .......................................................................................]
781Selecting previously unselected package libubsan0:amd64.
782Preparing to unpack .../19-libubsan0_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
783Unpacking libubsan0:amd64 (7.4.0-1ubuntu1~18.04.1) ...
784Selecting previously unselected package libcilkrts5:amd64................................................................................]
785Preparing to unpack .../20-libcilkrts5_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
786Unpacking libcilkrts5:amd64 (7.4.0-1ubuntu1~18.04.1) ...
787Selecting previously unselected package libmpx2:amd64....................................................................................]
788Preparing to unpack .../21-libmpx2_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
789Unpacking libmpx2:amd64 (8.3.0-6ubuntu1~18.04.1) ...
790Selecting previously unselected package libquadmath0:amd64...............................................................................]
791Preparing to unpack .../22-libquadmath0_8.3.0-6ubuntu1~18.04.1_amd64.deb ...
792Unpacking libquadmath0:amd64 (8.3.0-6ubuntu1~18.04.1) ...
793Selecting previously unselected package libgcc-7-dev:amd64...............................................................................]
794Preparing to unpack .../23-libgcc-7-dev_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
795Unpacking libgcc-7-dev:amd64 (7.4.0-1ubuntu1~18.04.1) ...
796Selecting previously unselected package gcc-7.##########.................................................................................]
797Preparing to unpack .../24-gcc-7_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
798Unpacking gcc-7 (7.4.0-1ubuntu1~18.04.1) ...
799Selecting previously unselected package gcc.#############................................................................................]
800Preparing to unpack .../25-gcc_4%3a7.4.0-1ubuntu2.3_amd64.deb ...
801Unpacking gcc (4:7.4.0-1ubuntu2.3) ...
802Selecting previously unselected package libstdc++-7-dev:amd64.
803Preparing to unpack .../26-libstdc++-7-dev_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
804Unpacking libstdc++-7-dev:amd64 (7.4.0-1ubuntu1~18.04.1) ................................................................................]
805Selecting previously unselected package g++-7.
806Preparing to unpack .../27-g++-7_7.4.0-1ubuntu1~18.04.1_amd64.deb ...
807Unpacking g++-7 (7.4.0-1ubuntu1~18.04.1) ...###############..............................................................................]
808Selecting previously unselected package g++.
809Preparing to unpack .../28-g++_4%3a7.4.0-1ubuntu2.3_amd64.deb ...
810Unpacking g++ (4:7.4.0-1ubuntu2.3) ...######################.............................................................................]
811Selecting previously unselected package make.
812Preparing to unpack .../29-make_4.1-9.1ubuntu1_amd64.deb ...
813Unpacking make (4.1-9.1ubuntu1) ...
814Selecting previously unselected package libdpkg-perl.#########...........................................................................]
815Preparing to unpack .../30-libdpkg-perl_1.19.0.5ubuntu2.3_all.deb ...
816Unpacking libdpkg-perl (1.19.0.5ubuntu2.3) ...
817Selecting previously unselected package dpkg-dev.##############..........................................................................]
818Preparing to unpack .../31-dpkg-dev_1.19.0.5ubuntu2.3_all.deb ...
819Unpacking dpkg-dev (1.19.0.5ubuntu2.3) ...
820Selecting previously unselected package build-essential.########.........................................................................]
821Preparing to unpack .../32-build-essential_12.4ubuntu1_amd64.deb ...
822Unpacking build-essential (12.4ubuntu1) ...
823Selecting previously unselected package python3-lib2to3.#########........................................................................]
824Preparing to unpack .../33-python3-lib2to3_3.6.9-1~18.04_all.deb ...
825Unpacking python3-lib2to3 (3.6.9-1~18.04) ...
826Selecting previously unselected package python3-distutils.########.......................................................................]
827Preparing to unpack .../34-python3-distutils_3.6.9-1~18.04_all.deb ...
828Unpacking python3-distutils (3.6.9-1~18.04) ...
829Selecting previously unselected package dh-python.
830Preparing to unpack .../35-dh-python_3.20180325ubuntu2_all.deb ...
831Unpacking dh-python (3.20180325ubuntu2) ...#########################.....................................................................]
832Selecting previously unselected package libfakeroot:amd64.
833Preparing to unpack .../36-libfakeroot_1.22-2ubuntu1_amd64.deb ...
834Unpacking libfakeroot:amd64 (1.22-2ubuntu1) ...######################....................................................................]
835Selecting previously unselected package fakeroot.
836Preparing to unpack .../37-fakeroot_1.22-2ubuntu1_amd64.deb ...
837Unpacking fakeroot (1.22-2ubuntu1) ...################################...................................................................]
838Selecting previously unselected package libalgorithm-diff-perl.
839Preparing to unpack .../38-libalgorithm-diff-perl_1.19.03-1_all.deb ...
840Unpacking libalgorithm-diff-perl (1.19.03-1) ...
841Selecting previously unselected package libalgorithm-diff-xs-perl.#####..................................................................]
842Preparing to unpack .../39-libalgorithm-diff-xs-perl_0.04-5_amd64.deb ...
843Unpacking libalgorithm-diff-xs-perl (0.04-5) ...
844Selecting previously unselected package libalgorithm-merge-perl.########.................................................................]
845Preparing to unpack .../40-libalgorithm-merge-perl_0.08-3_all.deb ...
846Unpacking libalgorithm-merge-perl (0.08-3) ...
847Selecting previously unselected package libexpat1-dev:amd64.#############................................................................]
848Preparing to unpack .../41-libexpat1-dev_2.2.5-3ubuntu0.2_amd64.deb ...
849Unpacking libexpat1-dev:amd64 (2.2.5-3ubuntu0.2) ...
850Selecting previously unselected package libfile-fcntllock-perl.############..............................................................]
851Preparing to unpack .../42-libfile-fcntllock-perl_0.22-3build2_amd64.deb ...
852Unpacking libfile-fcntllock-perl (0.22-3build2) ...
853Selecting previously unselected package libpython3.6-dev:amd64.#############.............................................................]
854Preparing to unpack .../43-libpython3.6-dev_3.6.9-1~18.04_amd64.deb ...
855Unpacking libpython3.6-dev:amd64 (3.6.9-1~18.04) ...
856Selecting previously unselected package libpython3-dev:amd64.################............................................................]
857Preparing to unpack .../44-libpython3-dev_3.6.7-1~18.04_amd64.deb ...
858Unpacking libpython3-dev:amd64 (3.6.7-1~18.04) ...
859Selecting previously unselected package manpages-dev.
860Preparing to unpack .../45-manpages-dev_4.15-1_all.deb ...
861Unpacking manpages-dev (4.15-1) ...###########################################...........................................................]
862Selecting previously unselected package python-pip-whl.
863Preparing to unpack .../46-python-pip-whl_9.0.1-2.3~ubuntu1.18.04.1_all.deb ...
864Unpacking python-pip-whl (9.0.1-2.3~ubuntu1.18.04.1) ...#######################..........................................................]
865Selecting previously unselected package python3-crypto.
866Preparing to unpack .../47-python3-crypto_2.6.1-8ubuntu2_amd64.deb ...
867Unpacking python3-crypto (2.6.1-8ubuntu2) ...
868Selecting previously unselected package python3.6-dev.###########################........................................................]
869Preparing to unpack .../48-python3.6-dev_3.6.9-1~18.04_amd64.deb ...
870Unpacking python3.6-dev (3.6.9-1~18.04) ...
871Selecting previously unselected package python3-dev.##############################.......................................................]
872Preparing to unpack .../49-python3-dev_3.6.7-1~18.04_amd64.deb ...
873Unpacking python3-dev (3.6.7-1~18.04) ...
874Selecting previously unselected package python3-secretstorage.#####################......................................................]
875Preparing to unpack .../50-python3-secretstorage_2.3.1-2_all.deb ...
876Unpacking python3-secretstorage (2.3.1-2) ...
877Selecting previously unselected package python3-keyring.############################.....................................................]
878Preparing to unpack .../51-python3-keyring_10.6.0-1_all.deb ...
879Unpacking python3-keyring (10.6.0-1) ...
880Selecting previously unselected package python3-keyrings.alt.########################....................................................]
881Preparing to unpack .../52-python3-keyrings.alt_3.0-1_all.deb ...
882Unpacking python3-keyrings.alt (3.0-1) ...
883Selecting previously unselected package python3-pip.###################################..................................................]
884Preparing to unpack .../53-python3-pip_9.0.1-2.3~ubuntu1.18.04.1_all.deb ...
885Unpacking python3-pip (9.0.1-2.3~ubuntu1.18.04.1) ...
886Selecting previously unselected package python3-setuptools.
887Preparing to unpack .../54-python3-setuptools_39.0.1-2_all.deb ...
888Unpacking python3-setuptools (39.0.1-2) ...#############################################.................................................]
889Selecting previously unselected package python3-wheel.
890Preparing to unpack .../55-python3-wheel_0.30.0-0.2_all.deb ...
891Unpacking python3-wheel (0.30.0-0.2) ...#################################################................................................]
892Selecting previously unselected package python3-xdg.
893Preparing to unpack .../56-python3-xdg_0.25-4ubuntu1_all.deb ...
894Unpacking python3-xdg (0.25-4ubuntu1) ...#################################################...............................................]
895Setting up libquadmath0:amd64 (8.3.0-6ubuntu1~18.04.1) ...
896Setting up libgomp1:amd64 (8.3.0-6ubuntu1~18.04.1) ...######################################.............................................]
897Setting up libatomic1:amd64 (8.3.0-6ubuntu1~18.04.1) ...
898Setting up python-pip-whl (9.0.1-2.3~ubuntu1.18.04.1) ...####################################............................................]
899Setting up libexpat1:amd64 (2.2.5-3ubuntu0.2) ...
900Setting up libcc1-0:amd64 (8.3.0-6ubuntu1~18.04.1) ...########################################...........................................]
901Setting up make (4.1-9.1ubuntu1) ...###########################################################..........................................]
902Processing triggers for mime-support (3.60ubuntu1) ...
903Setting up python3-crypto (2.6.1-8ubuntu2) ...
904Setting up libtsan0:amd64 (8.3.0-6ubuntu1~18.04.1) ...##########################################.........................................]
905Setting up python3-xdg (0.25-4ubuntu1) ...
906Setting up python3-keyrings.alt (3.0-1) ...#######################################################.......................................]
907Setting up linux-libc-dev:amd64 (4.15.0-88.88) ...#################################################......................................]
908Setting up libdpkg-perl (1.19.0.5ubuntu2.3) ...
909Setting up python3-wheel (0.30.0-0.2) ...###########################################################.....................................]
910Setting up liblsan0:amd64 (8.3.0-6ubuntu1~18.04.1) ...
911Setting up gcc-7-base:amd64 (7.4.0-1ubuntu1~18.04.1) ...#############################################....................................]
912Setting up libstdc++-7-dev:amd64 (7.4.0-1ubuntu1~18.04.1) ...
913Setting up libpython3.6-minimal:amd64 (3.6.9-1~18.04) ...
914Setting up libalgorithm-merge-perl (0.08-3) ...
915Setting up libalgorithm-diff-xs-perl (0.04-5) ...
916Setting up python3-pip (9.0.1-2.3~ubuntu1.18.04.1) ...
917Setting up libexpat1-dev:amd64 (2.2.5-3ubuntu0.2) ...
918Setting up python3-setuptools (39.0.1-2) ...
919Setting up dh-python (3.20180325ubuntu2) ...
920Setting up binutils-x86-64-linux-gnu (2.30-21ubuntu1~18.04.2) ...
921Setting up cpp (4:7.4.0-1ubuntu2.3) ...
922Setting up libpython3.6-stdlib:amd64 (3.6.9-1~18.04) ...
923Setting up python3.6-minimal (3.6.9-1~18.04) ...
924Setting up binutils (2.30-21ubuntu1~18.04.2) ...
925Setting up libpython3.6:amd64 (3.6.9-1~18.04) ...
926Setting up python3.6 (3.6.9-1~18.04) ...
927Setting up gcc-7 (7.4.0-1ubuntu1~18.04.1) ...
928Setting up g++-7 (7.4.0-1ubuntu1~18.04.1) ...
929Setting up gcc (4:7.4.0-1ubuntu2.3) ...
930Setting up libpython3.6-dev:amd64 (3.6.9-1~18.04) ...
931Setting up dpkg-dev (1.19.0.5ubuntu2.3) ...
932Setting up g++ (4:7.4.0-1ubuntu2.3) ...
933update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode
934Setting up python3.6-dev (3.6.9-1~18.04) ...
935Setting up libpython3-dev:amd64 (3.6.7-1~18.04) ...
936Setting up build-essential (12.4ubuntu1) ...
937Setting up python3-dev (3.6.7-1~18.04) ...
938Processing triggers for libc-bin (2.27-3ubuntu1) ...
939avsaliy@MSK-6N0NWF2:~$ sudo pip3 install pandas
940The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
941The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
942Collecting pandas
943 Downloading https://files.pythonhosted.org/packages/08/ec/b5dd8cfb078380fb5ae9325771146bccd4e8cad2d3e4c72c7433010684eb/pandas-1.0.1-cp36-cp36m-manylinux1_x86_64.whl (10.1MB)
944 100% |████████████████████████████████| 10.1MB 134kB/s
945Collecting pytz>=2017.2 (from pandas)
946 Downloading https://files.pythonhosted.org/packages/e7/f9/f0b53f88060247251bf481fa6ea62cd0d25bf1b11a87888e53ce5b7c8ad2/pytz-2019.3-py2.py3-none-any.whl (509kB)
947 100% |████████████████████████████████| 512kB 2.4MB/s
948Collecting python-dateutil>=2.6.1 (from pandas)
949 Downloading https://files.pythonhosted.org/packages/d4/70/d60450c3dd48ef87586924207ae8907090de0b306af2bce5d134d78615cb/python_dateutil-2.8.1-py2.py3-none-any.whl (227kB)
950 100% |████████████████████████████████| 235kB 4.0MB/s
951Collecting numpy>=1.13.3 (from pandas)
952 Downloading https://files.pythonhosted.org/packages/62/20/4d43e141b5bc426ba38274933ef8e76e85c7adea2c321ecf9ebf7421cedf/numpy-1.18.1-cp36-cp36m-manylinux1_x86_64.whl (20.1MB)
953 100% |████████████████████████████████| 20.2MB 71kB/s
954Requirement already satisfied: six>=1.5 in /usr/lib/python3/dist-packages (from python-dateutil>=2.6.1->pandas)
955Installing collected packages: pytz, python-dateutil, numpy, pandas
956
957Successfully installed numpy-1.18.1 pandas-1.0.1 python-dateutil-2.8.1 pytz-2019.3
958avsaliy@MSK-6N0NWF2:~$
959avsaliy@MSK-6N0NWF2:~$ sudo pip3 install numpy
960The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
961The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
962Requirement already satisfied: numpy in /usr/local/lib/python3.6/dist-packages
963avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
964Traceback (most recent call last):
965 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 8, in <module>
966 from sqlalchemy import create_engine
967ModuleNotFoundError: No module named 'sqlalchemy'
968avsaliy@MSK-6N0NWF2:~$ sudo pip3 install sqlalchemy
969The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
970The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
971Collecting sqlalchemy
972 Downloading https://files.pythonhosted.org/packages/af/47/35edeb0f86c0b44934c05d961c893e223ef27e79e1f53b5e6f14820ff553/SQLAlchemy-1.3.13.tar.gz (6.0MB)
973 100% |████████████████████████████████| 6.0MB 230kB/s
974Installing collected packages: sqlalchemy
975 Running setup.py install for sqlalchemy ... done
976Successfully installed sqlalchemy-1.3.13
977avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
978Traceback (most recent call last):
979 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 43, in <module>
980 engine = create_engine(connection_string)
981 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/__init__.py", line 479, in create_engine
982 return strategy.create(*args, **kwargs)
983 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 87, in create
984 dbapi = dialect_cls.dbapi(**dbapi_args)
985 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 737, in dbapi
986 import psycopg2
987ModuleNotFoundError: No module named 'psycopg2'
988avsaliy@MSK-6N0NWF2:~$ sudo pip3 install psycopg2
989The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
990The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
991Collecting psycopg2
992 Downloading https://files.pythonhosted.org/packages/84/d7/6a93c99b5ba4d4d22daa3928b983cec66df4536ca50b22ce5dcac65e4e71/psycopg2-2.8.4.tar.gz (377kB)
993 100% |████████████████████████████████| 378kB 1.3MB/s
994 Complete output from command python setup.py egg_info:
995 running egg_info
996 creating pip-egg-info/psycopg2.egg-info
997 writing pip-egg-info/psycopg2.egg-info/PKG-INFO
998 writing dependency_links to pip-egg-info/psycopg2.egg-info/dependency_links.txt
999 writing top-level names to pip-egg-info/psycopg2.egg-info/top_level.txt
1000 writing manifest file 'pip-egg-info/psycopg2.egg-info/SOURCES.txt'
1001 Error: b'You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.\n'
1002
1003 ----------------------------------------
1004Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-veq9e42b/psycopg2/
1005avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
1006Traceback (most recent call last):
1007 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 43, in <module>
1008 engine = create_engine(connection_string)
1009 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/__init__.py", line 479, in create_engine
1010 return strategy.create(*args, **kwargs)
1011 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 87, in create
1012 dbapi = dialect_cls.dbapi(**dbapi_args)
1013 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 737, in dbapi
1014 import psycopg2
1015ModuleNotFoundError: No module named 'psycopg2'
1016avsaliy@MSK-6N0NWF2:~$ sudo pip3 install silence_in_the_library
1017The directory '/home/avsaliy/.cache/pip/http' or its parent directory is not owned by the current user and the cache has been disabled. Please check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
1018The directory '/home/avsaliy/.cache/pip' or its parent directory is not owned by the current user and caching wheels has been disabled. check the permissions and owner of that directory. If executing pip with sudo, you may want sudo's -H flag.
1019Collecting silence_in_the_library
1020Exception:
1021Traceback (most recent call last):
1022 File "/usr/lib/python3/dist-packages/pip/basecommand.py", line 215, in main
1023 status = self.run(options, args)
1024 File "/usr/lib/python3/dist-packages/pip/commands/install.py", line 342, in run
1025 requirement_set.prepare_files(finder)
1026 File "/usr/lib/python3/dist-packages/pip/req/req_set.py", line 380, in prepare_files
1027 ignore_dependencies=self.ignore_dependencies))
1028 File "/usr/lib/python3/dist-packages/pip/req/req_set.py", line 554, in _prepare_file
1029 require_hashes
1030 File "/usr/lib/python3/dist-packages/pip/req/req_install.py", line 278, in populate_link
1031 self.link = finder.find_requirement(self, upgrade)
1032 File "/usr/lib/python3/dist-packages/pip/index.py", line 465, in find_requirement
1033 all_candidates = self.find_all_candidates(req.name)
1034 File "/usr/lib/python3/dist-packages/pip/index.py", line 423, in find_all_candidates
1035 for page in self._get_pages(url_locations, project_name):
1036 File "/usr/lib/python3/dist-packages/pip/index.py", line 568, in _get_pages
1037 page = self._get_page(location)
1038 File "/usr/lib/python3/dist-packages/pip/index.py", line 683, in _get_page
1039 return HTMLPage.get_page(link, session=self.session)
1040 File "/usr/lib/python3/dist-packages/pip/index.py", line 795, in get_page
1041 resp.raise_for_status()
1042 File "/usr/share/python-wheels/requests-2.18.4-py2.py3-none-any.whl/requests/models.py", line 935, in raise_for_status
1043 raise HTTPError(http_error_msg, response=self)
1044requests.exceptions.HTTPError: 404 Client Error: Not Found for url: https://pypi.org/simple/silence-in-the-library/
1045avsaliy@MSK-6N0NWF2:~$ python3 /mnt/c/Users/avsaliy/Documents/zen_pipeline.py --start_dt='2019-09-24 18:00:00' --end_dt='2019-09-24 19:00:00'
1046Traceback (most recent call last):
1047 File "/mnt/c/Users/avsaliy/Documents/zen_pipeline.py", line 43, in <module>
1048 engine = create_engine(connection_string)
1049 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/__init__.py", line 479, in create_engine
1050 return strategy.create(*args, **kwargs)
1051 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/strategies.py", line 87, in create
1052 dbapi = dialect_cls.dbapi(**dbapi_args)
1053 File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 737, in dbapi
1054 import psycopg2
1055ModuleNotFoundError: No module named 'psycopg2'
1056avsaliy@MSK-6N0NWF2:~$