csvファイルをOracleDBへロードしたいのですが例外エラー発生

Question

OracleDBへcsvファイルをembulkを使用してバルクインサートしたいのですが、embulk run config.yml実行時に以下のエラーが出力し失敗します。原因と解決方法を教えて頂きたいです。
作業ログは以下の通りです。

環境、Solaris 11/oracle 12c/embulk 0.9.8

srdcs04% embulk run config.yml
2018-10-30 18:06:29.447 +0900: Embulk v0.9.8
2018-10-30 18:06:30.662 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
2018-10-30 18:06:34.845 +0900 [INFO] (main): Gem's home and path are set by default: "/export/home/srdcs/.embulk/lib/gems"
2018-10-30 18:06:36.092 +0900 [INFO] (main): Started Embulk v0.9.8
org.embulk.config.ConfigException: OutputPlugin 'oracle' is not found.
org.jruby.proxy.org.embulk.config.ConfigException$Proxy1: Unknown output plugin 'oracle'. embulk/output/oracle.rb is not installed. Run 'embulk gem search -rd embulk-output' command to find plugins.
org.embulk.plugin.PluginManager.buildPluginNotFoundException(PluginManager.java:78)
org.embulk.plugin.PluginManager.newPluginWithoutWrapper(PluginManager.java:64)
org.embulk.plugin.PluginManager.newPlugin(PluginManager.java:31)
org.embulk.spi.ExecSession.newPlugin(ExecSession.java:148)
org.embulk.spi.Exec.newPlugin(Exec.java:63)
org.embulk.exec.BulkLoader$ProcessPluginSet.<init>(BulkLoader.java:427)
org.embulk.exec.BulkLoader.doRun(BulkLoader.java:501)
org.embulk.exec.BulkLoader.access$000(BulkLoader.java:34)
org.embulk.exec.BulkLoader$1.run(BulkLoader.java:352)
org.embulk.exec.BulkLoader$1.run(BulkLoader.java:349)
org.embulk.spi.Exec.doWith(Exec.java:22)
org.embulk.exec.BulkLoader.run(BulkLoader.java:349)
org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:161)
org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:292)
org.embulk.EmbulkRunner.run(EmbulkRunner.java:156)
org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:436)
org.embulk.cli.EmbulkRun.run(EmbulkRun.java:91)
org.embulk.cli.Main.main(Main.java:26)
pressed: org.embulk.plugin.PluginSourceNotMatchException
     at org.embulk.plugin.InjectedPluginSource.newPlugin(InjectedPluginSource.java:53)
     at org.embulk.plugin.PluginManager.newPluginWithoutWrapper(PluginManager.java:52)

......

Error: OutputPlugin 'oracle' is not found.
org.jruby.proxy.org.embulk.config.ConfigException$Proxy1: Unknown output plugin 'oracle'. embulk/output/oracle.rb is not installed. Run 'embulk gem search -rd embulk-output' command to find plugins.

Answer 1

embulk/output/oracle.rb is not installed

oracle.rbがインストールされてないみたいです
必要なモジュールを足してあげてください

Comments

[raccoondog]

embulk初心者の者です。

ご回答有難うございます。

以下のプラグインでは足りないという認識で宜しいでしょうか。

embulk-input-jdbc-0.9.3.gem
embulk-output-jdbc-0.7.13.gem

oracle.rbのモジュールの在り処を教えて頂きたいです。

[n.t]

gem install embulk-output-oracle
一応これでpluginは足せると思います。
gemで今何が入っていて何がないのかは把握しておくといいと思います。
https://qiita.com/hiroysato/items/9bed39c9016b5f6db4b0
私の記事ではありませんが

[raccoondog]

ご回答有難うございます。
embulk-outpu-oracleをインストールし、再実行しました。
先ほどのエラーは解消されました。

しかしながら、先ほどとは違うエラーがまた出力されました。

org.embulk.exec.PartialExecutionException:org.embulk.config.ConfigException:'header_line' option is invalid if 'skip_header_lines' is set

[n.t]

https://qiita.com/hiroysato/items/a71669d3e5be2049c238
そちらは設定の問題ですね
`header行を何行飛ばしますか`ってことです。

エラーに対してどう言ったアプローチをしたかも記述していただけるとありがたいです。

[raccoondog]

seed.ymlの定義header_lineが古かったみたいなんので、skip header lineに変更したらエラーが解決しました。

そのあと再実行しますと、the network adapter could not establish the connectionのエラーが出力し、OracleへJDBC接続ができないみたいです。現在、seed.ymlファイルの定義を見直している段階でして、何か誤りなどありましたらご教示頂きたいです。

in:
type: file
path_prefix: './output-oracle.csv'
parser:
charset: UTF-8
newline: CRLF
type: csv
delimiter: ','
skip_header_line: false
columns:
- {name: ID, type: long}
- {name: NUM, type: string}
- {name: STR, type: string}
- {name: VARSTR, type: string}
- {name: DT, type: timestamp, format: '%Y-%m-%d'}
- {name: TIME0, type: timestamp, format: '%Y-%m-%d %H:%M:%S'}
- {name: TIME6, type: timestamp, format: '%Y-%m-%d %H:%M:%S.%N'}
- {name: TIME9, type: timestamp, format: '%Y-%m-%d %H:%M:%S.%N'}
out:
type: oracle
host: localhost
database: srdcs
user: srdcs
password: srdcs
table: INPUT_TEST
mode: insert
insert_method: normal
driver_path: '/opt/oracle/product/12.1.0/db/jdbc/lib/ojdbc7.jar'

[n.t]

I/O Exception: The Network Adapter could not establish the connection
JDBC URLにおけるOracleリスナー・ポートのIPアドレスとマシン名が不適切です。
host: localhost この辺が問題な気がします。
oracleは同じサーバー内に作ってありますか？

[raccoondog]

oracleは同じサーバに構築しております。
TNSポートを確認しますと、1533で
embulkのエラーを確認しますと、1521で接続しようとして失敗しているみたいです。

seed.ymlでポート指定はできますでしょうか？

[n.t]

http://blog.idcf.jp/entry/bigdata/ybi_dataconnector/

普通にportって書いてあげればいいみたいです

[raccoondog]

ご回答有難うございます。
seed.ymlにport指定を実施し、正常にJDBC接続できました。

バルクインサートの段階で、エラーが出てしまいまして
以下の通りになっております。

※Oracleテーブルの構成
CREATE TABLE INPUT_TEST (
ID NUMBER(8,0),
NUM NUMBER(12,2),
STR CHAR(8),
VARSTR VARCHAR2(8),
DT DATE,
TIME0 TIMESTAMP(0),
TIME6 TIMESTAMP,
TIME9 TIMESTAMP(9),
PRIMARY KEY(ID)
);

※csvファイルのデータ
srdcs04% cat output-oracle.csv
1,,,,,,,
2,123.4,chr1,varchr1,2015-04-24,2015-04-24 01:02:03,2015-04-24 01:02:03.12345,2015-04-24 01:02:03.12345678
3,1234567890.12,chr12345,varchr12,2015-12-31,2015-12-31 23:59:59,2015-12-31 23:59:59.123456,2015-12-31 23:59:59.123456789

※バルクインサート
srdcs04% embulk run config.yml
2018-10-31 17:16:54.621 +0900: Embulk v0.9.8
2018-10-31 17:16:55.983 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
2018-10-31 17:17:00.289 +0900 [INFO] (main): Gem's home and path are set by default: "/export/home/srdcs/.embulk/lib/gems"
2018-10-31 17:17:01.525 +0900 [INFO] (main): Started Embulk v0.9.8
2018-10-31 17:17:01.627 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-oracle (0.8.0)
2018-10-31 17:17:01.683 +0900 [INFO] (0001:transaction): Listing local files at directory '.' filtering filename by prefix 'output-oracle.csv'
2018-10-31 17:17:01.686 +0900 [INFO] (0001:transaction): "follow_symlinks" is set false. Note that symbolic links to directories are skipped.
2018-10-31 17:17:01.697 +0900 [INFO] (0001:transaction): Loading files [./output-oracle.csv]
2018-10-31 17:17:01.775 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=64 / output tasks 32 = input tasks 1 * 32
2018-10-31 17:17:01.805 +0900 [INFO] (0001:transaction): Connecting to jdbc:oracle:thin:@10.1.31.75:1533:srdcsc options {user=srdcs, password=***}
2018-10-31 17:17:02.753 +0900 [INFO] (0001:transaction): Using JDBC Driver 12.1.0.2.0
2018-10-31 17:17:02.754 +0900 [INFO] (0001:transaction): Using insert mode

[raccoondog]

2018-10-31 17:17:05.935 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk000" ("ID" NUMBER, "NUM" NUMBER, "STR" CHAR(8), "VARSTR" VARCHAR2(8), "DT" DATE, "TIME0" TIMESTAMP(0), "TIME6" TIMESTAMP(6), "TIME9" TIMESTAMP(9))
2018-10-31 17:17:06.002 +0900 [INFO] (0001:transaction): > 0.07 seconds
2018-10-31 17:17:06.008 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk001" ("ID" NUMBER, "NUM" NUMBER, "STR" CHAR(8), "VARSTR" VARCHAR2(8), "DT" DATE, "TIME0" TIMESTAMP(0), "TIME6" TIMESTAMP(6), "TIME9" TIMESTAMP(9))
2018-10-31 17:17:06.026 +0900 [INFO] (0001:transaction): > 0.02 seconds
2018-10-31 17:17:06.034 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk002" ("ID" NUMBER, "NUM" NUMBER, "STR" CHAR(8), "VARSTR" VARCHAR2(8), "DT" DATE, "TIME0" TIMESTAMP(0), "TIME6" TIMESTAMP(6), "TIME9" TIMESTAMP(9))
2018-10-31 17:17:06.062 +0900 [INFO] (0001:transaction): > 0.03 seconds
2018-10-31 17:17:06.068 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk003" ("ID" NUMBER, "NUM" NUMBER, "STR" CHAR(8), "VARSTR" VARCHAR2(8), "DT" DATE, "TIME0" TIMESTAMP(0), "TIME6" TIMESTAMP(6), "TIME9" TIMESTAMP(9))
2018-10-31 17:17:06.092 +0900 [INFO] (0001:transaction): > 0.02 seconds
2018-10-31 17:17:06.095 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk004" ("ID" NUMBER, "NUM" NUMBER, "STR" CHAR(8), "VARSTR" VARCHAR2(8), "DT" DATE, "TIME0" TIMESTAMP(0), "TIME6" TIMESTAMP(6), "TIME9" TIMESTAMP(9))
2018-10-31 17:17:06.194 +0900 [INFO] (0001:transaction): > 0.10 seconds
2018-10-31 17:17:06.198 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk005" ("ID" NUMBER, "NUM" NUMBER, "STR" CHAR(8), "VARSTR" VARCHAR2(8), "DT" DATE, "TIME0" TIMESTAMP(0), "TIME6" TIMESTAMP(6), "TIME9" TIMESTAMP(9))
2018-10-31 17:17:06.266 +0900 [INFO] (0001:transaction): > 0.07 seconds

2018-10-31 17:17:07.020 +0900 [INFO] (0001:transaction): > 0.02 seconds
2018-10-31 17:17:07.059 +0900 [INFO] (0001:transaction): {done: 0 / 1, running: 0}
2018-10-31 17:17:07.115 +0900 [INFO] (0028:task-0000): Connecting to jdbc:oracle:thin:@10.1.31.75:1533:srdcsc options {user=srdcs, password=***}
2018-10-31 17:17:07.117 +0900 [INFO] (0028:task-0000): Connecting to jdbc:oracle:thin:@10.1.31.75:1533:srdcsc options {user=srdcs, password=***}
2018-10-31 17:17:07.118 +0900 [INFO] (0001:transaction): {done: 1 / 1, running: 0}
2018-10-31 17:17:07.131 +0900 [INFO] (0001:cleanup): Connecting to jdbc:oracle:thin:@10.1.31.75:1533:srdcsc options {user=srdcs, password=***}
2018-10-31 17:17:07.422 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk000"
2018-10-31 17:17:07.585 +0900 [INFO] (0001:cleanup): > 0.16 seconds
2018-10-31 17:17:07.586 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk001"
2018-10-31 17:17:07.609 +0900 [INFO] (0001:cleanup): > 0.02 seconds
2018-10-31 17:17:07.610 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk002"
2018-10-31 17:17:07.633 +0900 [INFO] (0001:cleanup): > 0.02 seconds
2018-10-31 17:17:07.634 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk003"
2018-10-31 17:17:07.651 +0900 [INFO] (0001:cleanup): > 0.02 seconds
2018-10-31 17:17:07.652 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk004"

[raccoondog]

2018-10-31 17:17:08.164 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE "SRDCS"."INPUT_TEST_6c9328f82_embulk031"
2018-10-31 17:17:08.175 +0900 [INFO] (0001:cleanup): > 0.01 seconds
org.embulk.exec.PartialExecutionException: java.lang.RuntimeException: java.sql.SQLException: No column to insert.
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: java.lang.RuntimeException: java.sql.SQLException: No column to insert.
at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.open(AbstractJdbcOutputPlugin.java:1033)
at org.embulk.exec.LocalExecutorPlugin$ScatterTransactionalPageOutput.openOutputs(LocalExecutorPlugin.java:404)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor.runInputTask(LocalExecutorPlugin.java:258)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor.access$000(LocalExecutorPlugin.java:196)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor$1.call(LocalExecutorPlugin.java:235)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor$1.call(LocalExecutorPlugin.java:232)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: No column to insert.
at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.open(AbstractJdbcOutputPlugin.java:1014)
... 9 more

Error: java.lang.RuntimeException: java.sql.SQLException: No column to insert.

[n.t]

申し訳ありません。
エラーの部分はどこになりますか？

どんな操作をして
どんなエラーが出て
それに対してどんなアプローチをしたか教えていただきたいです。
質問に答えるのはできますがこのままではあなたの力にならないと思います。

[raccoondog]

すみません、情報整理します。

データインサート時に、以下のエラーが出力されました。
srdcs04% embulk run config.yml

org.embulk.exec.PartialExecutionException: java.lang.RuntimeException: java.sql.SQLException: No column to insert.
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: java.lang.RuntimeException: java.sql.SQLException: No column to insert.
at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.open(AbstractJdbcOutputPlugin.java:1033)
at org.embulk.exec.LocalExecutorPlugin$ScatterTransactionalPageOutput.openOutputs(LocalExecutorPlugin.java:404)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor.runInputTask(LocalExecutorPlugin.java:258)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor.access$000(LocalExecutorPlugin.java:196)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor$1.call(LocalExecutorPlugin.java:235)
at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor$1.call(LocalExecutorPlugin.java:232)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: No column to insert.
at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.open(AbstractJdbcOutputPlugin.java:1014)
... 9 more

Error: java.lang.RuntimeException: java.sql.SQLException: No column to insert.

インサート元のcsvファイルの内容と、インサート先のテーブルの構成を見直し中になります。
他に失敗要因がありましたらご教示の程お願いいたします。

[n.t]

Error: java.lang.RuntimeException: java.sql.SQLException: No column to insert.

No column to insertとなっているので カラムがないか指定されていないのだと思います。
Errorと記述されている部分を重点的に攻めていくと解決にぐっと近づくと思います。

[raccoondog]

お世話になっております。
カラムの指定をseed.ymlに記載し、再実行しますと上記エラーは解消されました。

srdcs04% cat seed.yml
in:
type: file
path_prefix: './output-oracle.csv'
parser:
charset: UTF-8
newline: CRLF
type: csv
delimiter: ','
skip_header_line: false
columns:
- {name: ID, type: long}
- {name: NUM, type: string}
- {name: STR, type: string}
- {name: VARSTR, type: string}
- {name: DT, type: timestamp, format: '%Y-%m-%d'}
- {name: TIME0, type: timestamp, format: '%Y-%m-%d %H:%M:%S'}
- {name: TIME6, type: timestamp, format: '%Y-%m-%d %H:%M:%S.%N'}
- {name: TIME9, type: timestamp, format: '%Y-%m-%d %H:%M:%S.%N'}
out:
type: oracle
host: 10.1.31.75
port: 1533
database: srdcsc
user: srdcs
password: srdcs
table: INPUT_TEST
mode: insert
insert_method: normal
driver_path: '/opt/oracle/product/12.1.0/db/jdbc/lib/ojdbc7.jar'
column_options:
ID: {type: long}
NUM: {type: string}
STR: {type: string}
VARSTR: {type: string}
DT: {type: timestamp}
TIME0: {type: timestamp}
TIME6: {type: timestamp}
TIME9: {type: timestamp}
srdcs04%

次に、null値はインサート出来ない。というエラーが発生したのですがembulkのprebiewで確認しますとnull値はないように思われます。OracleDB側のテーブル構成と、Embulk側のカラム定義が食い違っているのでしょうか

srdcs04%　embulk run config.yml

org.embulk.exec.PartialExecutionException: org.embulk.config.ConfigException: com.fasterxml.jackson.databind.JsonMappingException: Setting null to a task field is not allowed. Use Optional<T> to represent null.
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

srdcs04% embulk preview config.yml
2018-11-01 09:56:08.635 +0900: Embulk v0.9.8
2018-11-01 09:56:09.591 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
2018-11-01 09:56:12.905 +0900 [INFO] (main): Gem's home and path are set by default: "/export/home/srdcs/.embulk/lib/gems"
2018-11-01 09:56:13.906 +0900 [INFO] (main): Started Embulk v0.9.8
2018-11-01 09:56:13.989 +0900 [INFO] (0001:preview): Listing local files at directory '.' filtering filename by prefix 'output-oracle.csv'
2018-11-01 09:56:13.991 +0900 [INFO] (0001:preview): "follow_symlinks" is set false. Note that symbolic links to directories are skipped.
2018-11-01 09:56:14.001 +0900 [INFO] (0001:preview): Loading files [./output-oracle.csv]
2018-11-01 09:56:14.019 +0900 [INFO] (0001:preview): Try to read 32,768 bytes from input source
+--------+-----------------+----------+----------+-------------------------+-------------------------+--------------------------------+-----------------------------------+
| 1:long | :double | :string | :string | :timestamp | :timestamp | :timestamp | :timestamp |
+--------+-----------------+----------+----------+-------------------------+-------------------------+--------------------------------+-----------------------------------+
| 2 | 123.4 | chr1 | varchr1 | 2015-04-24 00:00:00 UTC | 2015-04-24 01:02:03 UTC | 2015-04-24 01:02:03.123450 UTC | 2015-04-24 01:02:03.123456780 UTC |
| 3 | 1.23456789012E9 | chr12345 | varchr12 | 2015-12-31 00:00:00 UTC | 2015-12-31 23:59:59 UTC | 2015-12-31 23:59:59.123456 UTC | 2015-12-31 23:59:59.123456789 UTC |
+--------+-----------------+----------+----------+-------------------------+-------------------------+--------------------------------+-----------------------------------+
srdcs04%

[raccoondog]

自己解決致しました。

大変お世話になりました。

ご協力有難うございました。