embulk-input-bigqueryによるデータ連携

embulk-input-bigqueryプラグインを使って、bigqueryへアップしたOracleデータを、ローカルにあるOracleDBへインサートしたいです。（bigquery側のデータとローカル側のデータは同じテーブルレイアウトになります。）

実行した結果、ローカルに導入済みのプラグイン、定義ファイルについて以下になります。

●●embulkプラグイン●●
C:\Users\xxxxxxxxx\Desktop\embulk>embulk-0.9.8.bat gem list
2019-02-13 11:21:25.860 +0900: Embulk v0.9.8

Gem plugin path is: C:\Users\xxxxxxxxx.embulk\lib\gems


*** LOCAL GEMS ***

addressable (2.5.2)
bundler (1.16.0)
concurrent-ruby (1.1.4)
declarative (0.0.10)
declarative-option (0.1.0)
did_you_mean (default: 1.0.1)
embulk (0.9.8 java)
embulk-input-bigquery (0.0.6)
embulk-input-jdbc (0.9.3)
embulk-input-oracle (0.9.3)
embulk-output-bigquery (0.4.9)
embulk-output-jdbc (0.7.13)
embulk-output-oracle (0.8.0)
faraday (0.15.3)
google-api-client (0.24.3, 0.19.8)
google-cloud-bigquery (1.4.0)
google-cloud-core (1.3.0)
google-cloud-env (1.0.5)
googleauth (0.6.7)
httpclient (2.8.3)
jar-dependencies (default: 0.3.10)
jruby-openssl (0.9.21 java)
jruby-readline (1.2.0 java)
json (1.8.3 java)
jwt (2.1.0)
liquid (4.0.0)
memoist (0.16.0)
mime-types (3.2.2)
mime-types-data (3.2018.0812)
minitest (default: 5.4.1)
msgpack (1.1.0 java)
multi_json (1.13.1)
multipart-post (2.0.0)
net-telnet (default: 0.1.1)
os (1.0.0)
power_assert (default: 0.2.3)
psych (2.2.4 java)
public_suffix (3.0.3)
rake (default: 10.4.2)
rdoc (default: 4.2.0)
representable (3.0.4)
retriable (3.1.2)
signet (0.11.0)
test-unit (default: 3.1.1)
thread_safe (0.3.6 java)
time_with_zone (0.3.1)
tzinfo (1.2.5)
uber (0.1.0)





●●config_BQ_Oracle.yml●●
in:
  type: bigquery
  project: 'fluid-emissary-216806'
  keyfile: 'C:\Users\xxxxxxxxx\Desktop\embulk\My First Project-6041ffecfba7.json'
  columns:
    - {name: ORDER_NO, type: string}
    - {name: RS_TYPE, type: string}
    - {name: FACTORY_CODE, type: string}
    - {name: ORG_CODE, type: string}
    - {name: TRAN_DATE, type: timestamp, format: '%Y/%m/%d'}
    - {name: HINBAN, type: string}
    - {name: QTY, type: string}
    - {name: SLIP_NO, type: string}
    - {name: ITEM_NO, type: string}
    - {name: DIVISION_NO, type: string}
    - {name: FROM_FACTORY_CODE, type: string}
    - {name: FROM_ORG_CODE, type: string}
    - {name: FROM_SUBINV_CODE, type: string}
    - {name: FROM_VALUE_CODE, type: string}
    - {name: FROM_OPERATOR_NAME, type: string}
    - {name: TO_FACTORY_CODE, type: string}
    - {name: TO_ORG_CODE, type: string}
    - {name: TO_SUBINV_CODE, type: string}
    - {name: TO_VALUE_CODE, type: string}
    - {name: TO_OPERATOR_NAME, type: string}
    - {name: SUB_SYSTEM_TYPE1, type: string}
    - {name: CANCEL_FLAG, type: string}
    - {name: ACT_CREATION_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: WH_ACT_CREATION_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: JOB_CODE, type: string}
    - {name: UNIT_PRICE, type: string}
    - {name: ERROR_STATUS, type: string}
    - {name: DESCRIPTION, type: string}
    - {name: LOCATION, type: string}
    - {name: REVISION_NO, type: string}
    - {name: OPE_CODE, type: string}
    - {name: BOX_KIND, type: string}
    - {name: DEMAND_NO, type: string}
    - {name: SUB_NO, type: string}
    - {name: TRAFFIC_NO, type: string}
    - {name: IF_FLAG, type: string}
    - {name: SELL_BUY_DATA_FLAG, type: string}
    - {name: SOURCE_ORDER_NO, type: string}
    - {name: FT_DEFINE_ID, type: string}
    - {name: FROM_SELL_BUY_ID, type: string}
    - {name: TO_SELL_BUY_ID, type: string}
    - {name: CREATION_DATE, type: string}
    - {name: CREATED_BY, type: string}
    - {name: LAST_UPDATE_DATE, type: string}
    - {name: LAST_UPDATED_BY, type: string}
    - {name: UPDATE_REQUEST_ID, type: string}
    - {name: TIME_STAMP, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: INV_UPDATE_FLAG, type: string}
    - {name: ISSUE_SEQ, type: string}
    - {name: BACKUP_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: SOUMEI_ID, type: string}
    - {name: GCPCS_IF_FLAG, type: string}
    - {name: GCPCS_IF_CREATION_DATE, type: string}
    - {name: RECIEPT_CODE, type: string}
    - {name: DELIV_BIN_NO, type: string}
    - {name: DELIV_NO, type: string}
    - {name: RECV_BIN_NO, type: string}
    - {name: SUB_SYSTEM_TYPE2, type: string}
    - {name: SHIP_DATE, type: string}
    - {name: C_NO, type: string}
    - {name: T_NO, type: string}
    - {name: RECV_OFFICE_CODE, type: string}
    - {name: SR_IF_FLAG, type: string}
    - {name: SR_IF_CREATION_DATE, type: string}
    - {name: PS_IF_FLAG, type: string}
    - {name: PS_IF_CREATION_DATE, type: string}
    - {name: CUSTOMER_CODE, type: string}
    - {name: KS_TYPE, type: string}
    - {name: SUPPLY_SECTION, type: string}
    - {name: MANAGE_NO, type: string}
    - {name: SEND_OFFICE_CODE, type: string}
    - {name: SOUMEI_SLIP_NO, type: string}
    - {name: SOUMEI_ITEM_NO, type: string}
    - {name: PS_xxxxxxxxx_HINBAN, type: string}
    - {name: INVOICE_CASE_INFO_NO, type: string}
    - {name: GYK_SITE_CODE, type: string}
    - {name: CASE_NO, type: string}
    - {name: CASE_SUB_NO, type: string}
    - {name: FROM_LOCATION, type: string}
    - {name: TO_LOCATION, type: string}
    - {name: GYK_TRAN_TYPE, type: string}
    - {name: INV_INFO_UPDATE_FLAG, type: string}
out: {type: oracle, host: 10.1.52.109, port: 1521, database: ORCL, user: system, password: xxxxxxxxx, table: T_RS_TRAN, mode: insert, insert_method: normal, driver_path: 'C:\Users\xxxxxxxxx\Desktop\embulkDB\product\12.2.0\dbhome_1\jdbc\lib\ojdbc8.jar'}




●●実行結果●●
C:\Users\xxxxxxxxx\Desktop\embulk>embulk-0.9.8.bat run config_BQ_Oracle.yml
2019-02-13 11:05:35.569 +0900: Embulk v0.9.8
2019-02-13 11:05:36.563 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
2019-02-13 11:05:40.294 +0900 [INFO] (main): Gem's home and path are set by default: "C:\Users\xxxxxxxxx.embulk\lib\gems"
2019-02-13 11:05:41.908 +0900 [INFO] (main): Started Embulk v0.9.8
WARNING: You are running Ruby 2.3.3, which is nearing end-of-life.
The Google Cloud API clients work best on supported versions of Ruby. Consider upgrading to Ruby 2.4 or later.
See https://www.ruby-lang.org/en/downloads/branches/ for more info on the Ruby maintenance schedule.
To suppress this message, set the GOOGLE_CLOUD_SUPPRESS_RUBY_WARNINGS environment variable.
2019-02-13 11:05:49.544 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-bigquery (0.0.6)
2019-02-13 11:05:49.669 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-oracle (0.8.0)
org.embulk.exec.PartialExecutionException: org.jruby.exceptions.RaiseException: (NoMethodError) undefined method `encoding' for nil:NilClass
        at org.embulk.exec.BulkLoader$LoaderState.buildPartialExecuteException(BulkLoader.java:339)
        at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:565)
        at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:34)
        at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:352)
        at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:349)
        at org.embulk.spi.Exec.doWith(Exec.java:22)
        at org.embulk.exec.BulkLoader.run(BulkLoader.java:349)
        at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:161)
        at org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:292)
        at org.embulk.EmbulkRunner.run(EmbulkRunner.java:156)
        at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:436)
        at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:91)
        at org.embulk.cli.Main.main(Main.java:26)
        Suppressed: java.lang.NullPointerException
                at org.embulk.exec.BulkLoader.doCleanup(BulkLoader.java:462)
                at org.embulk.exec.BulkLoader$3.run(BulkLoader.java:396)
                at org.embulk.exec.BulkLoader$3.run(BulkLoader.java:393)
                at org.embulk.spi.Exec.doWith(Exec.java:22)
                at org.embulk.exec.BulkLoader.cleanup(BulkLoader.java:393)
                at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:164)
                ... 5 more
Caused by: org.jruby.exceptions.RaiseException: (NoMethodError) undefined method `encoding' for nil:NilClass
        at RUBY.compile(uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/erb.rb:599)
        at RUBY.initialize(uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/erb.rb:801)
        at RUBY.transaction(C:/Users/xxxxxxxxx/.embulk/lib/gems/gems/embulk-input-bigquery-0.0.6/lib/embulk/input/bigquery.rb:28)
        at RUBY.transaction(uri:classloader:/gems/embulk-0.9.8-java/lib/embulk/input_plugin.rb:58)

Error: org.jruby.exceptions.RaiseException: (NoMethodError) undefined method `encoding' for nil:NilClass

embulk-input-bigqueryのバージョンがローカルにある他のプラグインとあわないのでしょうか？

回答3件

ベストアンサー

Bigqueryの仕様のようですね。https://cloud.google.com/bigquery/troubleshooting-errors 件数を減らしてみてはどうでしょうか？(私はBigquery使っていないので細かい仕様のことはわかりません)

投稿2019/02/13 05:55

hiroysato

総合スコア408

'がないからじゃないですか？

sql: 'select * from `embulk_test.T_RS_TRAN_A`

投稿2019/02/13 05:04

hiroysato

総合スコア408

回答へのコメント

raccoondog

2019/02/13 05:47

シングルクォートを追記して、先ほどのエラーは解消されました。有難うございます。また、インサート対象のデータ量が大き過ぎるのか？　別エラーが出力されました。 2019-02-13 14:23:28.242 +0900 [INFO] (main): Started Embulk v0.9.8 WARNING: You are running Ruby 2.3.3, which is nearing end-of-life. The Google Cloud API clients work best on supported versions of Ruby. Consider upgrading to Ruby 2.4 or later. See https://www.ruby-lang.org/en/downloads/branches/ for more info on the Ruby maintenance schedule. To suppress this message, set the GOOGLE_CLOUD_SUPPRESS_RUBY_WARNINGS environment variable. 2019-02-13 14:23:35.110 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-bigquery (0.0.6) 2019-02-13 14:23:35.219 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-oracle (0.8.0) 2019-02-13 14:23:35.313 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=8 / output tasks 4 = input tasks 1 * 4 2019-02-13 14:23:35.360 +0900 [INFO] (0001:transaction): Connecting to jdbc:oracle:thin:@A0430-02396:1521:ORCL options {user=system, password=***} 2019-02-13 14:23:35.934 +0900 [INFO] (0001:transaction): Using JDBC Driver 12.2.0.1.0 2019-02-13 14:23:35.934 +0900 [INFO] (0001:transaction): Using insert mode 2019-02-13 14:23:36.871 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SYSTEM"."T_RS_TRAN_68e54f76f8_embulk000" ("ORDER_NO" NUMBER, "RS_TYPE" VARCHAR2(1), "FACTORY_CODE" VARCHAR2(4), "ORG_CODE" VARCHAR2(3), "TRAN_DATE" DATE, "HINBAN" VARCHAR2(40), "QTY" NUMBER, "SLIP_NO" VARCHAR2(10), "ITEM_NO" 2019-02-13 14:23:37.089 +0900 [INFO] (0001:transaction): > 0.03 seconds 2019-02-13 14:23:37.214 +0900 [INFO] (0001:transaction): {done: 0 / 1, running: 0} 2019-02-13 14:23:37.245 +0900 [INFO] (0019:task-0000): Connecting to jdbc:oracle:thin:@A0430-02396:1521:ORCL options {user=system, password=***} 2019-02-13 14:23:37.245 +0900 [INFO] (0019:task-0000): Connecting to jdbc:oracle:thin:@A0430-02396:1521:ORCL options {user=system, password=***} 2019-02-13 14:23:37.386 +0900 [INFO] (0019:task-0000): Prepared SQL: INSERT INTO "SYSTEM"."T_RS_TRAN_68e54f76f8_embulk000" ("ORDER_NO", "RS_TYPE", "FACTORY_CODE", "ORG_CODE", "TRAN_DATE", "HINBAN", "QTY", "SLIP_NO", "ITEM_NO", "DIVISION_NO", "FROM_FACTORY_CODE", "FROM_ORG_CODE", "FROM_SUBINV_CODE", 2019-02-13 14:26:01.348 +0900 [INFO] (0001:transaction): {done: 1 / 1, running: 0} 2019-02-13 14:26:01.379 +0900 [INFO] (0001:cleanup): Connecting to jdbc:oracle:thin:@A0430-02396:1521:ORCL options {user=system, password=***} 2019-02-13 14:26:01.491 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SYSTEM"."T_RS_TRAN_68e54f76f8_embulk000" 2019-02-13 14:26:01.537 +0900 [INFO] (0001:cleanup): > 0.05 seconds 2019-02-13 14:26:01.537 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SYSTEM"."T_RS_TRAN_68e54f76f8_embulk001" 2019-02-13 14:26:01.584 +0900 [INFO] (0001:cleanup): > 0.05 seconds 2019-02-13 14:26:01.600 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SYSTEM"."T_RS_TRAN_68e54f76f8_embulk002" 2019-02-13 14:26:01.631 +0900 [INFO] (0001:cleanup): > 0.03 seconds 2019-02-13 14:26:01.631 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SYSTEM"."T_RS_TRAN_68e54f76f8_embulk003" 2019-02-13 14:26:01.662 +0900 [INFO] (0001:cleanup): > 0.03 seconds org.embulk.exec.PartialExecutionException: org.jruby.exceptions.RaiseException: (PermissionDeniedError) responseTooLarge: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more information, see https://cloud.google.com/bigquery/troubleshooting-er rors at org.embulk.exec.BulkLoader$LoaderState.buildPartialExecuteException(BulkLoader.java:339) at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:565) at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:34) at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:352) at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:349) at org.embulk.spi.Exec.doWith(Exec.java:22) at org.embulk.exec.BulkLoader.run(BulkLoader.java:349) at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:161) at org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:292) at org.embulk.EmbulkRunner.run(EmbulkRunner.java:156) at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:436) at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:91) at org.embulk.cli.Main.main(Main.java:26) Caused by: org.jruby.exceptions.RaiseException: (PermissionDeniedError) responseTooLarge: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors at RUBY.execute(C:/Users/yazaki/.embulk/lib/gems/gems/google-cloud-bigquery-1.4.0/lib/google/cloud/bigquery/service.rb:413) at RUBY.job_query_results(C:/Users/yazaki/.embulk/lib/gems/gems/google-cloud-bigquery-1.4.0/lib/google/cloud/bigquery/service.rb:289) at RUBY.block in wait_until_done!(C:/Users/yazaki/.embulk/lib/gems/gems/google-cloud-bigquery-1.4.0/lib/google/cloud/bigquery/query_job.rb:282) at org.jruby.RubyKernel.loop(org/jruby/RubyKernel.java:1292) at RUBY.wait_until_done!(C:/Users/yazaki/.embulk/lib/gems/gems/google-cloud-bigquery-1.4.0/lib/google/cloud/bigquery/query_job.rb:281) at RUBY.query(C:/Users/yazaki/.embulk/lib/gems/gems/google-cloud-bigquery-1.4.0/lib/google/cloud/bigquery/project.rb:534) at RUBY.run(C:/Users/yazaki/.embulk/lib/gems/gems/embulk-input-bigquery-0.0.6/lib/embulk/input/bigquery.rb:81) at RUBY.run(uri:classloader:/gems/embulk-0.9.8-java/lib/embulk/input_plugin.rb:107) Error: org.jruby.exceptions.RaiseException: (PermissionDeniedError) responseTooLarge: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors C:\Users\yazaki\Desktop\embulk>

https://qiita.com/narita-takeru/items/045c184c006086763a8b

yaml
1sql: select ...

が必要なのではないでしょうか？

投稿2019/02/13 04:04

hiroysato

総合スコア408

回答へのコメント

raccoondog

2019/02/13 05:00

ご回答有難うございます。定義ファイル修正後の結果、また別のエラーが出力致しました。質問事項に記載したかったのですが（MarkUpdown記法）、１０００文字を超えてしまうため、以下に記載させて頂きます。 ●●定義ファイル●● in: type: bigquery project: 'fluid-emissary-216806' keyfile: 'C:\Users\yazaki\Desktop\embulk\My First Project-6041ffecfba7.json' sql: 'select * from `embulk_test.T_RS_TRAN_A` allow_extra_columns: false allow_optional_columns: true columns: - {name: ORDER_NO, type: string} - {name: RS_TYPE, type: string} - {name: FACTORY_CODE, type: string} - {name: ORG_CODE, type: string} - {name: TRAN_DATE, type: timestamp, format: '%Y/%m/%d'} - {name: HINBAN, type: string} - {name: QTY, type: string} - {name: SLIP_NO, type: string} - {name: ITEM_NO, type: string} - {name: DIVISION_NO, type: string} - {name: FROM_FACTORY_CODE, type: string} - {name: FROM_ORG_CODE, type: string} - {name: FROM_SUBINV_CODE, type: string} - {name: FROM_VALUE_CODE, type: string} - {name: FROM_OPERATOR_NAME, type: string} - {name: TO_FACTORY_CODE, type: string} - {name: TO_ORG_CODE, type: string} - {name: TO_SUBINV_CODE, type: string} - {name: TO_VALUE_CODE, type: string} - {name: TO_OPERATOR_NAME, type: string} - {name: SUB_SYSTEM_TYPE1, type: string} - {name: CANCEL_FLAG, type: string} - {name: ACT_CREATION_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'} - {name: WH_ACT_CREATION_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'} - {name: JOB_CODE, type: string} - {name: UNIT_PRICE, type: string} - {name: ERROR_STATUS, type: string} - {name: DESCRIPTION, type: string} - {name: LOCATION, type: string} - {name: REVISION_NO, type: string} - {name: OPE_CODE, type: string} - {name: BOX_KIND, type: string} - {name: DEMAND_NO, type: string} - {name: SUB_NO, type: string} - {name: TRAFFIC_NO, type: string} - {name: IF_FLAG, type: string} - {name: SELL_BUY_DATA_FLAG, type: string} - {name: SOURCE_ORDER_NO, type: string} - {name: FT_DEFINE_ID, type: string} - {name: FROM_SELL_BUY_ID, type: string} - {name: TO_SELL_BUY_ID, type: string} - {name: CREATION_DATE, type: string} - {name: CREATED_BY, type: string} - {name: LAST_UPDATE_DATE, type: string} - {name: LAST_UPDATED_BY, type: string} - {name: UPDATE_REQUEST_ID, type: string} - {name: TIME_STAMP, type: timestamp, format: '%Y/%m/%d %H:%M:%S'} - {name: INV_UPDATE_FLAG, type: string} - {name: ISSUE_SEQ, type: string} - {name: BACKUP_DATE, type: timestamp, format: '%Y/%m/%d %H:%M:%S'} - {name: SOUMEI_ID, type: string} - {name: GCPCS_IF_FLAG, type: string} - {name: GCPCS_IF_CREATION_DATE, type: string} - {name: RECIEPT_CODE, type: string} - {name: DELIV_BIN_NO, type: string} - {name: DELIV_NO, type: string} - {name: RECV_BIN_NO, type: string} - {name: SUB_SYSTEM_TYPE2, type: string} - {name: SHIP_DATE, type: string} - {name: C_NO, type: string} - {name: T_NO, type: string} - {name: RECV_OFFICE_CODE, type: string} - {name: SR_IF_FLAG, type: string} - {name: SR_IF_CREATION_DATE, type: string} - {name: PS_IF_FLAG, type: string} - {name: PS_IF_CREATION_DATE, type: string} - {name: CUSTOMER_CODE, type: string} - {name: KS_TYPE, type: string} - {name: SUPPLY_SECTION, type: string} - {name: MANAGE_NO, type: string} - {name: SEND_OFFICE_CODE, type: string} - {name: SOUMEI_SLIP_NO, type: string} - {name: SOUMEI_ITEM_NO, type: string} - {name: PS_YAZAKI_HINBAN, type: string} - {name: INVOICE_CASE_INFO_NO, type: string} - {name: GYK_SITE_CODE, type: string} - {name: CASE_NO, type: string} - {name: CASE_SUB_NO, type: string} - {name: FROM_LOCATION, type: string} - {name: TO_LOCATION, type: string} - {name: GYK_TRAN_TYPE, type: string} - {name: INV_INFO_UPDATE_FLAG, type: string} out: {type: oracle, host: A0430-02396, port: 1521, database: ORCL, user: system, password: yazaki, table: T_RS_TRAN, mode: insert, insert_method: normal, driver_path: 'C:\Users\yazaki\Desktop\embulkDB\product\12.2.0\dbhome_1\jdbc\lib\ojdbc8.jar'} ●●実行結果●● C:\Users\yazaki\Desktop\embulk>embulk-0.9.8.bat run config_BQ_Oracle.yml 2019-02-13 13:50:11.112 +0900: Embulk v0.9.8 2019-02-13 13:50:12.082 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected. 2019-02-13 13:50:15.887 +0900 [INFO] (main): Gem's home and path are set by default: "C:\Users\yazaki.embulk\lib\gems" while scanning for the next token found character '%' that cannot start any token. (Do not use % for indentation) in 'string', line 13, column 51: ... DATE, type: timestamp, format: '%Y/%m/%d'} ^ at org.yaml.snakeyaml.scanner.ScannerImpl.fetchMoreTokens(ScannerImpl.java:420) at org.yaml.snakeyaml.scanner.ScannerImpl.checkToken(ScannerImpl.java:226) at org.yaml.snakeyaml.parser.ParserImpl$ParseBlockMappingKey.produce(ParserImpl.java:557) at org.yaml.snakeyaml.parser.ParserImpl.peekEvent(ParserImpl.java:157) at org.yaml.snakeyaml.parser.ParserImpl.checkEvent(ParserImpl.java:147) at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:224) at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:154) at org.yaml.snakeyaml.composer.Composer.composeValueNode(Composer.java:246) at org.yaml.snakeyaml.composer.Composer.composeMappingChildren(Composer.java:237) at org.yaml.snakeyaml.composer.Composer.composeMappingNode(Composer.java:225) at org.yaml.snakeyaml.composer.Composer.composeNode(Composer.java:154) at org.yaml.snakeyaml.composer.Composer.composeDocument(Composer.java:122) at org.yaml.snakeyaml.composer.Composer.getSingleNode(Composer.java:105) at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:122) at org.yaml.snakeyaml.Yaml.loadFromReader(Yaml.java:505) at org.yaml.snakeyaml.Yaml.load(Yaml.java:424) at org.embulk.config.ConfigLoader.fromYamlString(ConfigLoader.java:58) at org.embulk.EmbulkRunner.readConfig(EmbulkRunner.java:359) at org.embulk.EmbulkRunner.run(EmbulkRunner.java:150) at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:436) at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:91) at org.embulk.cli.Main.main(Main.java:26) Error: while scanning for the next token found character '%' that cannot start any token. (Do not use % for indentation) in 'string', line 13, column 51: ... DATE, type: timestamp, format: '%Y/%m/%d'} ^ C:\Users\yazaki\Desktop\embulk>