{"action":"opened","issue":{"url":"https://api.github.com/repos/embulk/embulk-output-jdbc/issues/154","repository_url":"https://api.github.com/repos/embulk/embulk-output-jdbc","labels_url":"https://api.github.com/repos/embulk/embulk-output-jdbc/issues/154/labels{/name}","comments_url":"https://api.github.com/repos/embulk/embulk-output-jdbc/issues/154/comments","events_url":"https://api.github.com/repos/embulk/embulk-output-jdbc/issues/154/events","html_url":"https://github.com/embulk/embulk-output-jdbc/issues/154","id":195750269,"number":154,"title":"embulk-output-redshift - no JSON support?","user":{"login":"jdotjdot","id":1328961,"avatar_url":"https://avatars.githubusercontent.com/u/1328961?v=3","gravatar_id":"","url":"https://api.github.com/users/jdotjdot","html_url":"https://github.com/jdotjdot","followers_url":"https://api.github.com/users/jdotjdot/followers","following_url":"https://api.github.com/users/jdotjdot/following{/other_user}","gists_url":"https://api.github.com/users/jdotjdot/gists{/gist_id}","starred_url":"https://api.github.com/users/jdotjdot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdotjdot/subscriptions","organizations_url":"https://api.github.com/users/jdotjdot/orgs","repos_url":"https://api.github.com/users/jdotjdot/repos","events_url":"https://api.github.com/users/jdotjdot/events{/privacy}","received_events_url":"https://api.github.com/users/jdotjdot/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-15T09:00:53Z","updated_at":"2016-12-15T09:00:53Z","closed_at":null,"body":"I'm using Embulk (which we just discovered today and already love it, thanks so much for your work on this!) to copy over our entire Postgres database to Redshift daily.  To do this, we've created a generic Embulk config with the table name as an environmental variable and we're just iterating over every table name in our database.\r\n\r\nIt appears that even though the Redshift output plugin is documented to support JSON, we keep getting errors that the JSON type isn't supported.  Is there something we're doing wrong?\r\n\r\nError:\r\n```\r\n...\r\n\tat usr.local.Cellar.embulk.$0_dot_8_dot_9.libexec.embulk_dot_jar.embulk.command.embulk_bundle.invokeOther34:require(file:/usr/local/Cellar/embulk/0.8.9/libexec/embulk.jar!/embulk/command/embulk_bundle.rb)\r\n\tat usr.local.Cellar.embulk.$0_dot_8_dot_9.libexec.embulk_dot_jar.embulk.command.embulk_bundle.RUBY$script(file:/usr/local/Cellar/embulk/0.8.9/libexec/embulk.jar!/embulk/command/embulk_bundle.rb:30)\r\n\tat java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:625)\r\n\tat org.jruby.ir.Compiler$1.load(Compiler.java:111)\r\n\tat org.jruby.Ruby.runScript(Ruby.java:817)\r\n\tat org.jruby.Ruby.runScript(Ruby.java:809)\r\n\tat org.jruby.Ruby.runNormally(Ruby.java:747)\r\n\tat org.jruby.Ruby.runFromMain(Ruby.java:569)\r\n\tat org.jruby.Main.doRunFromMain(Main.java:415)\r\n\tat org.jruby.Main.internalRun(Main.java:310)\r\n\tat org.jruby.Main.run(Main.java:239)\r\n\tat org.jruby.Main.main(Main.java:201)\r\n\tat org.embulk.cli.Main.main(Main.java:23)\r\n\r\nError: This plugin doesn't support json type. Please try to upgrade version of the plugin using 'embulk gem update' command. If the latest version still doesn't support json type, please contact plugin developers, or change configuration of input plugin not to use json type.\r\n```\r\n\r\nConfig:\r\n\r\n```yaml\r\nin:\r\n  type: postgresql\r\n  host: ***\r\n  port: 5432\r\n  user: ***\r\n  password: ***\r\n  database: ***\r\n  schema: public\r\n  ssl: true\r\n\r\n  application_name: postgres-read-replica-input\r\n\r\n  table: {{ env.table_name }}\r\n  incremental: true\r\n\r\n  column_options:\r\n    uuid: { value_type: string }\r\n\r\nout:\r\n  type: redshift\r\n  host: ***\r\n  port: 5439\r\n  user: ***\r\n  password: ***\r\n  database: dev\r\n  schema: embulk_loaded_postgres\r\n  table: {{ env.table_name }}\r\n\r\n  access_key_idL ***\r\n  secret_access_key: ***\r\n\r\n  s3_bucket: redshift\r\n  s3_key_prefix: embulk-loader-postgres/\r\n  mode: replace\r\n```"}}
{"actor":{"display_login":"jdotjdot"}}