質問編集履歴
2
内容の追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -5,6 +5,26 @@
|
|
|
5
5
|
**解決したい問題**
|
|
6
6
|
|
|
7
7
|
下記エラーの対処方法をご教授いただきたいです。
|
|
8
|
+
|
|
9
|
+
|
|
10
|
+
|
|
11
|
+
**一応の解決方法**
|
|
12
|
+
|
|
13
|
+
下記で一応動きました。。
|
|
14
|
+
|
|
15
|
+
```sql
|
|
16
|
+
|
|
17
|
+
\encoding utf8
|
|
18
|
+
|
|
19
|
+
|
|
20
|
+
|
|
21
|
+
drop table access_log;
|
|
22
|
+
|
|
23
|
+
\i src/access_log.ct
|
|
24
|
+
|
|
25
|
+
\copy access_log from 'src/access_log.bz2.csv' with csv header null '' delimiter ',' quote e'"';
|
|
26
|
+
|
|
27
|
+
```
|
|
8
28
|
|
|
9
29
|
|
|
10
30
|
|
|
@@ -157,3 +177,9 @@
|
|
|
157
177
|
* Windows10
|
|
158
178
|
|
|
159
179
|
* PostgresSQL 9.4
|
|
180
|
+
|
|
181
|
+
|
|
182
|
+
|
|
183
|
+
**参考サイト**
|
|
184
|
+
|
|
185
|
+
[PostgreSQLのcopyではまった](http://deta.hateblo.jp/entry/2015/09/10/094157)
|
1
文章の変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -35,6 +35,30 @@
|
|
|
35
35
|
16632811:hoge.fuga.net.mx~-~-~23/Sep/2018:10:16:30 +0900~GET~/index.php?q=hoge_fuga&search_id=1234"~200~144241~-~-
|
|
36
36
|
|
|
37
37
|
16632832:hoge.fuga.net.mx~-~-~23/Sep/2018:10:16:32 +0900~GET~/index.php?q=hoge_fuga&search_id=1234&page=piyo~200~331344~-~-
|
|
38
|
+
|
|
39
|
+
|
|
40
|
+
|
|
41
|
+
$ tail -10 access_log.tsv
|
|
42
|
+
|
|
43
|
+
m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&action=ghi&q%3Dabc%26id%3D123&text=&_=123~200~38~https://www.fuga.com/index.php?q=abc&id=1234~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
|
44
|
+
|
|
45
|
+
m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&action=def~200~56~https://www.fuga.com/~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
|
46
|
+
|
|
47
|
+
m123.piyo.piyo.ne.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?&q=abc&id=123~200~306~https://www.fuga.com/~Mozilla/5.0 (iPhone; CPU iPhone OS 11_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15G77 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
|
48
|
+
|
|
49
|
+
1-2-3.hoge.fuga.ad.jp~-~-~01/Oct/2018:01:59:58 +0900~GET~/index.php?q=123&search=%AB%BC%DF~200~44979~https://www.google.com/~Mozilla/5.0 (Linux; Android 8.1.0; F-04K Build/V18R067C) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Mobile Safari/537.36
|
|
50
|
+
|
|
51
|
+
123.hoge.fuga.ne.jp~-~-~01/Oct/2018:01:59:59 +0900~GET~/index.php?&q=def&search=~200~51~https://www.hoge.net/index.php?q=123~Mozilla/5.0 (iPhone; CPU iPhone OS 12_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16A366 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
|
52
|
+
|
|
53
|
+
123.hoge.fuga.ne.jp~-~-~01/Oct/2018:01:59:59 +0900~GET~/index.php?&q=def~200~56~https://www.hoge.net/~Mozilla/5.0 (iPhone; CPU iPhone OS 12_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/16A366 YJApp-IOS jp.co.yahoo.ipn.appli/4.11.6
|
|
54
|
+
|
|
55
|
+
Oct 1 02:00:00 svr1 newsyslog[50902]: logfile turned over
|
|
56
|
+
|
|
57
|
+
hgoe.fuga.co.jp~-~-~01/Oct/2018:02:00:00 +0900~GET~/blog/?q=1~200~19843~-~-
|
|
58
|
+
|
|
59
|
+
hoge1234567890.fuga.net~-~-~01/Oct/2018:02:00:00 +0900~GET~/index.php?q=abc&page_id=1234&gclid=ABCDEFG~200~47956~-~Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) GSA/59.0.213668279 Mobile/14D27 Safari/602.1
|
|
60
|
+
|
|
61
|
+
.
|
|
38
62
|
|
|
39
63
|
|
|
40
64
|
|