Q&A
ベストアンサー
ご回答有難うございます。
定義修正後の結果、エラーとなってしまいました。
取り急ぎ、連絡させて頂きます。
in:
type: oracle
path_prefix: null
driver_path: C:\Users\xxxxxxxxx\Desktop\embulkDB\product\12.2.0\dbhome_1\sqldeveloper\jdbc\lib\ojdbc7.jar
host: A0430-02396
user: system
password: xxxxxxxxx
database: ORCL
query: |-
select
A1.BANGOU,A1.NUM,A1.STR,A1.DT as A1_DT
from
INPUT_TEST_001 A1,INPUT_TEST_002 B1
where
A1.NUM = B1.NUM
AND A1_DT > :A1_DT
use_raw_query_with_incremental: true
last_record: [18-12-10]
incremental_columns: [A1_dt]
incremental: true
out: {type: bigquery, auth_method: json_key, json_keyfile: 'C:\Users\xxxxxxxxx\Desktop\embulk\My
First Project-6041xxxxxx.json', project: fluid-xxxxx-xxxxx, dataset: embulk_test,
auto_create_table: true, table: INPUT_TEST_001, read_timeout_sec: 360000, open_timeout_sec: 360000,
send_timeout_sec: 360000, mode: append}
C:\Users\xxxxxxxxx\Desktop\embulk>embulk-0.9.8.bat run config_test.yml.liquid -c diff_001.yml
2018-12-13 17:27:34.465 +0900: Embulk v0.9.8
2018-12-13 17:27:35.448 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
2018-12-13 17:27:39.118 +0900 [INFO] (main): Gem's home and path are set by default: "C:\Users\xxxxxxxxx.embulk\lib\gems"
2018-12-13 17:27:42.799 +0900 [INFO] (main): Started Embulk v0.9.8
2018-12-13 17:27:42.908 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-oracle (0.9.3)
2018-12-13 17:27:48.240 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-bigquery (0.4.9)
2018-12-13 17:27:48.302 +0900 [INFO] (0001:transaction): Connecting to jdbc:oracle:thin:@A0430-02396:1521:ORCL options {oracle.jdbc.ReadTimeout=1800000, user=system, password=***, oracle.net.CONNECT_TIMEOUT=300000}
2018-12-13 17:27:48.818 +0900 [INFO] (0001:transaction): Using JDBC Driver 12.1.0.2.0
org.embulk.exec.PartialExecutionException: org.embulk.config.ConfigException: Column ":A1.dt" doesn't exist in query string
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.embulk.config.ConfigException: Column ":A1.dt" doesn't exist in query string
at org.embulk.input.jdbc.AbstractJdbcInputPlugin.getRawQuery(AbstractJdbcInputPlugin.java:365)
at org.embulk.input.jdbc.AbstractJdbcInputPlugin.setupTask(AbstractJdbcInputPlugin.java:217)
at org.embulk.input.jdbc.AbstractJdbcInputPlugin.transaction(AbstractJdbcInputPlugin.java:201)
at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:506)
... 11 more
Error: org.embulk.config.ConfigException: Column ":A1.dt" doesn't exist in query string
C:\Users\xxxxxxxxx\Desktop\embulk>
下記のような回答は推奨されていません。
このような回答には修正を依頼しましょう。
2018/12/14 04:32