質問編集履歴
3
質問内容の更新
title
CHANGED
File without changes
|
body
CHANGED
@@ -9,7 +9,7 @@
|
|
9
9
|
●Embulk定義ファイル
|
10
10
|
in:
|
11
11
|
type: file
|
12
|
-
path_prefix: C:\Users\
|
12
|
+
path_prefix: C:\Users\xxx\Desktop\embulk\DATA_CSV
|
13
13
|
parser:
|
14
14
|
type: csv
|
15
15
|
delimiter: ','
|
@@ -24,50 +24,12 @@
|
|
24
24
|
allow_optional_columns: true
|
25
25
|
columns:
|
26
26
|
- {name: ORDER_NO, type: string}
|
27
|
-
- {name: RS_TYPE, type: string}
|
28
|
-
- {name: FACTORY_CODE, type: string}
|
29
27
|
- {name: ORG_CODE, type: string}
|
30
28
|
- {name: TRAN_DATE, type: timestamp, format: '%Y/%m/%d'}
|
31
|
-
- {name: HINBAN, type: string}
|
32
|
-
- {name: QTY, type: string}
|
33
|
-
- {name: SLIP_NO, type: string}
|
34
|
-
- {name: ITEM_NO, type: string}
|
35
|
-
- {name: DIVISION_NO, type: string}
|
36
|
-
- {name: FROM_FACTORY_CODE, type: string}
|
37
|
-
- {name: FROM_ORG_CODE, type: string}
|
38
|
-
- {name: FROM_SUBINV_CODE, type: string}
|
39
|
-
- {name: FROM_VALUE_CODE, type: string}
|
40
|
-
- {name: FROM_OPERATOR_NAME, type: string}
|
41
|
-
- {name: TO_FACTORY_CODE, type: string}
|
42
|
-
- {name: TO_ORG_CODE, type: string}
|
43
|
-
- {name: TO_SUBINV_CODE, type: string}
|
44
|
-
- {name: TO_VALUE_CODE, type: string}
|
45
|
-
- {name: TO_OPERATOR_NAME, type: string}
|
46
|
-
- {name: SUB_SYSTEM_TYPE1, type: string}
|
47
29
|
- {name: CANCEL_FLAG, type: string}
|
48
30
|
- {name: ACT_CREATION_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
|
49
31
|
- {name: WH_ACT_CREATION_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
|
50
|
-
- {name: JOB_CODE, type: string}
|
51
|
-
- {name: UNIT_PRICE, type: string}
|
52
|
-
- {name: ERROR_STATUS, type: string}
|
53
|
-
- {name: DESCRIPTION, type: string}
|
54
|
-
- {name: LOCATION, type: string}
|
55
|
-
- {name: REVISION_NO, type: string}
|
56
|
-
- {name: OPE_CODE, type: string}
|
57
|
-
- {name: BOX_KIND, type: string}
|
58
|
-
- {name: DEMAND_NO, type: string}
|
59
32
|
- {name: SUB_NO, type: string}
|
60
|
-
- {name: TRAFFIC_NO, type: string}
|
61
|
-
- {name: IF_FLAG, type: string}
|
62
|
-
- {name: SELL_BUY_DATA_FLAG, type: string}
|
63
|
-
- {name: SOURCE_ORDER_NO, type: string}
|
64
|
-
- {name: FT_DEFINE_ID, type: string}
|
65
|
-
- {name: FROM_SELL_BUY_ID, type: string}
|
66
|
-
- {name: TO_SELL_BUY_ID, type: string}
|
67
|
-
- {name: CREATION_DATE, type: string}
|
68
|
-
- {name: CREATED_BY, type: string}
|
69
|
-
- {name: LAST_UPDATE_DATE, type: string}
|
70
|
-
- {name: LAST_UPDATED_BY, type: string}
|
71
33
|
- {name: UPDATE_REQUEST_ID, type: string}
|
72
34
|
- {name: TIME_STAMP, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
|
73
35
|
- {name: INV_UPDATE_FLAG, type: string}
|
@@ -75,37 +37,7 @@
|
|
75
37
|
- {name: BACKUP_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
|
76
38
|
- {name: SOUMEI_ID, type: string}
|
77
39
|
- {name: GCPCS_IF_FLAG, type: string}
|
78
|
-
|
40
|
+
|
79
|
-
- {name: RECIEPT_CODE, type: string}
|
80
|
-
- {name: DELIV_BIN_NO, type: string}
|
81
|
-
- {name: DELIV_NO, type: string}
|
82
|
-
- {name: RECV_BIN_NO, type: string}
|
83
|
-
- {name: SUB_SYSTEM_TYPE2, type: string}
|
84
|
-
- {name: SHIP_DATE, type: string}
|
85
|
-
- {name: C_NO, type: string}
|
86
|
-
- {name: T_NO, type: string}
|
87
|
-
- {name: RECV_OFFICE_CODE, type: string}
|
88
|
-
- {name: SR_IF_FLAG, type: string}
|
89
|
-
- {name: SR_IF_CREATION_DATE, type: string}
|
90
|
-
- {name: PS_IF_FLAG, type: string}
|
91
|
-
- {name: PS_IF_CREATION_DATE, type: string}
|
92
|
-
- {name: CUSTOMER_CODE, type: string}
|
93
|
-
- {name: KS_TYPE, type: string}
|
94
|
-
- {name: SUPPLY_SECTION, type: string}
|
95
|
-
- {name: MANAGE_NO, type: string}
|
96
|
-
- {name: SEND_OFFICE_CODE, type: string}
|
97
|
-
- {name: SOUMEI_SLIP_NO, type: string}
|
98
|
-
- {name: SOUMEI_ITEM_NO, type: string}
|
99
|
-
- {name: PS_YAZAKI_HINBAN, type: string}
|
100
|
-
- {name: INVOICE_CASE_INFO_NO, type: string}
|
101
|
-
- {name: GYK_SITE_CODE, type: string}
|
102
|
-
- {name: CASE_NO, type: string}
|
103
|
-
- {name: CASE_SUB_NO, type: string}
|
104
|
-
- {name: FROM_LOCATION, type: string}
|
105
|
-
- {name: TO_LOCATION, type: string}
|
106
|
-
- {name: GYK_TRAN_TYPE, type: string}
|
107
|
-
- {name: INV_INFO_UPDATE_FLAG, type: string}
|
108
|
-
- {name: tmp, type: string}
|
109
41
|
out: {type: bigquery, auth_method: json_key, json_keyfile: 'C:\Users\yazaki\Desktop\embulk\My
|
110
42
|
First Project-6041ffecfba7.json', project: fluid-emissary-216806, dataset: embulk_test,
|
111
43
|
auto_create_table: true, table: CSV_BQ_TABLE, open_read_timeout_sec: 360000, send_timeout_sec: 360000, read_timeout_sec: 360000}
|
@@ -115,86 +47,22 @@
|
|
115
47
|
|
116
48
|
フィールド名 タイプ モード
|
117
49
|
ORDER_NO STRING NULLABLE
|
118
|
-
RS_TYPE STRING NULLABLE
|
119
|
-
FACTORY_CODE STRING NULLABLE
|
120
50
|
ORG_CODE STRING NULLABLE
|
121
51
|
TRAN_DATE TIMESTAMP NULLABLE
|
122
52
|
HINBAN STRING NULLABLE
|
123
53
|
QTY STRING NULLABLE
|
124
|
-
SLIP_NO STRING NULLABLE
|
125
|
-
ITEM_NO STRING NULLABLE
|
126
|
-
DIVISION_NO STRING NULLABLE
|
127
|
-
FROM_FACTORY_CODE STRING NULLABLE
|
128
|
-
FROM_ORG_CODE STRING NULLABLE
|
129
|
-
FROM_SUBINV_CODE STRING NULLABLE
|
130
|
-
FROM_VALUE_CODE STRING NULLABLE
|
131
|
-
FROM_OPERATOR_NAME STRING NULLABLE
|
132
|
-
TO_FACTORY_CODE STRING NULLABLE
|
133
|
-
TO_ORG_CODE STRING NULLABLE
|
134
|
-
TO_SUBINV_CODE STRING NULLABLE
|
135
|
-
TO_VALUE_CODE STRING NULLABLE
|
136
|
-
TO_OPERATOR_NAME STRING NULLABLE
|
137
54
|
SUB_SYSTEM_TYPE1 STRING NULLABLE
|
138
55
|
CANCEL_FLAG STRING NULLABLE
|
139
56
|
ACT_CREATION_DATE TIMESTAMP NULLABLE
|
140
57
|
WH_ACT_CREATION_DATE TIMESTAMP NULLABLE
|
141
58
|
JOB_CODE STRING NULLABLE
|
142
|
-
UNIT_PRICE STRING NULLABLE
|
143
|
-
ERROR_STATUS STRING NULLABLE
|
144
|
-
DESCRIPTION STRING NULLABLE
|
145
|
-
LOCATION STRING NULLABLE
|
146
|
-
REVISION_NO STRING NULLABLE
|
147
|
-
OPE_CODE STRING NULLABLE
|
148
|
-
BOX_KIND STRING NULLABLE
|
149
|
-
DEMAND_NO STRING NULLABLE
|
150
|
-
SUB_NO STRING NULLABLE
|
151
|
-
TRAFFIC_NO STRING NULLABLE
|
152
|
-
IF_FLAG STRING NULLABLE
|
153
|
-
SELL_BUY_DATA_FLAG STRING NULLABLE
|
154
|
-
SOURCE_ORDER_NO STRING NULLABLE
|
155
|
-
FT_DEFINE_ID STRING NULLABLE
|
156
|
-
FROM_SELL_BUY_ID STRING NULLABLE
|
157
|
-
TO_SELL_BUY_ID STRING NULLABLE
|
158
|
-
CREATION_DATE STRING NULLABLE
|
159
|
-
CREATED_BY STRING NULLABLE
|
160
|
-
LAST_UPDATE_DATE STRING NULLABLE
|
161
|
-
LAST_UPDATED_BY STRING NULLABLE
|
162
|
-
UPDATE_REQUEST_ID STRING NULLABLE
|
163
59
|
TIME_STAMP TIMESTAMP NULLABLE
|
164
60
|
INV_UPDATE_FLAG STRING NULLABLE
|
165
61
|
ISSUE_SEQ STRING NULLABLE
|
166
62
|
BACKUP_DATE TIMESTAMP NULLABLE
|
167
|
-
SOUMEI_ID STRING NULLABLE
|
168
|
-
GCPCS_IF_FLAG STRING NULLABLE
|
169
|
-
GCPCS_IF_CREATION_DATE STRING NULLABLE
|
170
|
-
RECIEPT_CODE STRING NULLABLE
|
171
|
-
DELIV_BIN_NO STRING NULLABLE
|
172
|
-
DELIV_NO STRING NULLABLE
|
173
|
-
RECV_BIN_NO STRING NULLABLE
|
174
|
-
SUB_SYSTEM_TYPE2 STRING NULLABLE
|
175
|
-
SHIP_DATE STRING NULLABLE
|
176
63
|
C_NO STRING NULLABLE
|
177
64
|
T_NO STRING NULLABLE
|
178
65
|
RECV_OFFICE_CODE STRING NULLABLE
|
179
|
-
SR_IF_FLAG STRING NULLABLE
|
180
|
-
SR_IF_CREATION_DATE STRING NULLABLE
|
181
|
-
PS_IF_FLAG STRING NULLABLE
|
182
|
-
PS_IF_CREATION_DATE STRING NULLABLE
|
183
|
-
CUSTOMER_CODE STRING NULLABLE
|
184
|
-
KS_TYPE STRING NULLABLE
|
185
|
-
SUPPLY_SECTION STRING NULLABLE
|
186
|
-
MANAGE_NO STRING NULLABLE
|
187
|
-
SEND_OFFICE_CODE STRING NULLABLE
|
188
|
-
SOUMEI_SLIP_NO STRING NULLABLE
|
189
|
-
SOUMEI_ITEM_NO STRING NULLABLE
|
190
|
-
PS_YAZAKI_HINBAN STRING NULLABLE
|
191
|
-
INVOICE_CASE_INFO_NO STRING NULLABLE
|
192
|
-
GYK_SITE_CODE STRING NULLABLE
|
193
|
-
CASE_NO STRING NULLABLE
|
194
|
-
CASE_SUB_NO STRING NULLABLE
|
195
|
-
FROM_LOCATION STRING NULLABLE
|
196
|
-
TO_LOCATION STRING NULLABLE
|
197
|
-
GYK_TRAN_TYPE STRING NULLABLE
|
198
66
|
INV_INFO_UPDATE_FLAG STRING NULLABLE
|
199
67
|
tmp STRING NULLABLE
|
200
68
|
```
|
2
質問内容更新
title
CHANGED
File without changes
|
body
CHANGED
@@ -1,6 +1,10 @@
|
|
1
1
|
Embulkを使って、OracleDBのデータをBigQueryへバルクインサートする際に5000万件ほどのデータを処理すると一部スキップされてしまいます。
|
2
2
|
|
3
|
+
embulkの定義ファイルで指定したカラムの型と
|
4
|
+
Bigquery側で生成されるテーブルのカラムの型は
|
3
5
|
|
6
|
+
一致しているのですが、一部レコードがスキップされる事象が発生する原因を知りたいです。
|
7
|
+
|
4
8
|
```ここに言語を入力
|
5
9
|
●Embulk定義ファイル
|
6
10
|
in:
|
1
質問内容更新
title
CHANGED
File without changes
|
body
CHANGED
@@ -193,8 +193,18 @@
|
|
193
193
|
GYK_TRAN_TYPE STRING NULLABLE
|
194
194
|
INV_INFO_UPDATE_FLAG STRING NULLABLE
|
195
195
|
tmp STRING NULLABLE
|
196
|
+
```
|
196
197
|
|
198
|
+
```ここに言語を入力
|
199
|
+
●実行結果
|
197
200
|
|
201
|
+
・
|
202
|
+
(中略)
|
203
|
+
・
|
204
|
+
2019-02-15 09:12:04.801 +0900 [INFO] (0001:transaction): {done: 8 / 79, running: 7}
|
205
|
+
2019-02-15 09:12:04.985 +0900 [WARN] (0025:task-0015): Skipped line 82 (org.embulk.spi.time.TimestampParseException: Cannot parse '2018/09/21' by '%Y/%m/%d %H:%M:%S'): "35401536","2","8000","ZPD",2018/10/07,"L571ZW3SDWBD",10,"7NARTLDPH","66",0,"7500","BM0","UIIQ7LOGNI","PLPJ","WJWYWDZFFDZGUUDAQUH","7800","VOP","PH4GRLMBJ1","FNYZPJD","UGFYHBHIPZBCNPZIYKIWWHANJKHUEQ","L","0",2018/09/21,,"J",,"0","TCLJHNVEKMGBJZKQNBNPWJANCBSZXNBATJKB","ZVT","V","JLIMJN","FJWJMJDNBI","JQWOQAHU",,"F","1","J",,,,,,"AFNGJHJJQKFZIR",,"LJBQYC",,2018/12/04 12:11:13,"U","LBBTSNDFV",2018/12/03 09:30:44,,"1",,"WOK","HDU","ZBDGZEZ","JWP","X",,"JK","ZX","AEYM","1",,"1",,"IMN","S","HCFZNQ","KIHHWY","A","AUMN","B","FZVKGUAUYEXZOXWUBPMYECZBTCXVZXNCXI",,"KJ3",,,"IE","QZQNAHMCWBYKZ","14","1",
|
206
|
+
・
|
207
|
+
(中略)
|
208
|
+
・
|
198
209
|
|
199
|
-
|
200
210
|
```
|