質問をすることでしか得られない、回答やアドバイスがある。

15分調べてもわからないことは、質問しよう!

新規登録して質問してみよう
ただいま回答率
85.44%
Embulk

Embulkは、CSVデータやアクセスログなどの構造化データを高い信頼性で転送することができる、プラグインベースのバルクデータローダーです。

BigQuery

BigQueryは、Google Cloud Platformが提供しているビッグデータ解析サービス。数TB(テラバイト)またはPB(ペタバイト)の膨大なデータに対し、SQL風のクエリを実行し、高速で集計・分析を行うサービスです。

Google Cloud Platform

Google Cloud Platformは、Google社がクラウド上で提供しているサービス郡の総称です。エンドユーザー向けサービスと同様のインフラストラクチャーで運営されており、Webサイト開発から複雑なアプリ開発まで対応可能です。

Oracle Database

Oracle Databaseは、米オラクルが開発・販売を行うリレーショナルデータベース管理システムです。

Q&A

解決済

3回答

3510閲覧

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

raccoondog

総合スコア77

Embulk

Embulkは、CSVデータやアクセスログなどの構造化データを高い信頼性で転送することができる、プラグインベースのバルクデータローダーです。

BigQuery

BigQueryは、Google Cloud Platformが提供しているビッグデータ解析サービス。数TB(テラバイト)またはPB(ペタバイト)の膨大なデータに対し、SQL風のクエリを実行し、高速で集計・分析を行うサービスです。

Google Cloud Platform

Google Cloud Platformは、Google社がクラウド上で提供しているサービス郡の総称です。エンドユーザー向けサービスと同様のインフラストラクチャーで運営されており、Webサイト開発から複雑なアプリ開発まで対応可能です。

Oracle Database

Oracle Databaseは、米オラクルが開発・販売を行うリレーショナルデータベース管理システムです。

0グッド

0クリップ

投稿2019/02/13 02:29

編集2019/02/13 02:38

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のバージョンがローカルにある他のプラグインとあわないのでしょうか?

気になる質問をクリップする

クリップした質問は、後からいつでもMYページで確認できます。

またクリップした質問に回答があった際、通知やメールを受け取ることができます。

バッドをするには、ログインかつ

こちらの条件を満たす必要があります。

guest

回答3

0

ベストアンサー

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

投稿2019/02/13 05:55

hiroysato

総合スコア415

バッドをするには、ログインかつ

こちらの条件を満たす必要があります。

0

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

sql: 'select * from `embulk_test.T_RS_TRAN_A`

投稿2019/02/13 05:04

hiroysato

総合スコア415

バッドをするには、ログインかつ

こちらの条件を満たす必要があります。

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>
guest

0

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

yaml

1sql: select ...

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

投稿2019/02/13 04:04

hiroysato

総合スコア415

バッドをするには、ログインかつ

こちらの条件を満たす必要があります。

raccoondog

2019/02/13 05:00

ご回答有難うございます。 定義ファイル修正後の結果、また別のエラーが出力致しました。 質問事項に記載したかったのですが(MarkUpdown記法)、1000文字を超えてしまうため、以下に記載させて頂きます。 ●●定義ファイル●● 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>
guest

あなたの回答

tips

太字

斜体

打ち消し線

見出し

引用テキストの挿入

コードの挿入

リンクの挿入

リストの挿入

番号リストの挿入

表の挿入

水平線の挿入

プレビュー

15分調べてもわからないことは
teratailで質問しよう!

ただいまの回答率
85.44%

質問をまとめることで
思考を整理して素早く解決

テンプレート機能で
簡単に質問をまとめる

質問する

関連した質問