{"action":"created","issue":{"url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/issues/29","repository_url":"https://api.github.com/repos/flydata/fluent-plugin-redshift","labels_url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/issues/29/comments","events_url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/issues/29/events","html_url":"https://github.com/flydata/fluent-plugin-redshift/pull/29","id":164394136,"number":29,"title":"Move the ESCAPE option to redshift_copy_base_options","user":{"login":"ramynasr","id":1080253,"avatar_url":"https://avatars.githubusercontent.com/u/1080253?v=3","gravatar_id":"","url":"https://api.github.com/users/ramynasr","html_url":"https://github.com/ramynasr","followers_url":"https://api.github.com/users/ramynasr/followers","following_url":"https://api.github.com/users/ramynasr/following{/other_user}","gists_url":"https://api.github.com/users/ramynasr/gists{/gist_id}","starred_url":"https://api.github.com/users/ramynasr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ramynasr/subscriptions","organizations_url":"https://api.github.com/users/ramynasr/orgs","repos_url":"https://api.github.com/users/ramynasr/repos","events_url":"https://api.github.com/users/ramynasr/events{/privacy}","received_events_url":"https://api.github.com/users/ramynasr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-07-07T19:59:56Z","updated_at":"2016-07-08T14:14:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/pulls/29","html_url":"https://github.com/flydata/fluent-plugin-redshift/pull/29","diff_url":"https://github.com/flydata/fluent-plugin-redshift/pull/29.diff","patch_url":"https://github.com/flydata/fluent-plugin-redshift/pull/29.patch"},"body":"When trying to insert column values which are JSON strings, having the\r\noption to remove \"ESCAPE\" from the copy command can be very helpful."},"comment":{"url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/issues/comments/231370610","html_url":"https://github.com/flydata/fluent-plugin-redshift/pull/29#issuecomment-231370610","issue_url":"https://api.github.com/repos/flydata/fluent-plugin-redshift/issues/29","id":231370610,"user":{"login":"ramynasr","id":1080253,"avatar_url":"https://avatars.githubusercontent.com/u/1080253?v=3","gravatar_id":"","url":"https://api.github.com/users/ramynasr","html_url":"https://github.com/ramynasr","followers_url":"https://api.github.com/users/ramynasr/followers","following_url":"https://api.github.com/users/ramynasr/following{/other_user}","gists_url":"https://api.github.com/users/ramynasr/gists{/gist_id}","starred_url":"https://api.github.com/users/ramynasr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ramynasr/subscriptions","organizations_url":"https://api.github.com/users/ramynasr/orgs","repos_url":"https://api.github.com/users/ramynasr/repos","events_url":"https://api.github.com/users/ramynasr/events{/privacy}","received_events_url":"https://api.github.com/users/ramynasr/received_events","type":"User","site_admin":false},"created_at":"2016-07-08T14:14:50Z","updated_at":"2016-07-08T14:14:50Z","body":"I am using `tsv` for the `file_type` but the data I am inserting is `json`. The problem happens when I am trying to insert something like `{\"city\":\"Montr\\\\xc3\\\\xa9al\"}`\r\n\r\nUsing `ESCAPE` will insert this as `{\"city\":\"Montr\\xc3\\xa9al\"}` which becomes invalid `json`\r\n\r\nThere is a warning about this in redshift documentation:\r\n\r\n> The ESCAPE parameter does not interpret octal, hex, Unicode, or other escape sequence notation. For example, if your source data contains the octal line feed value (\\012) and you try to load this data with the ESCAPE parameter, Amazon Redshift loads the value 012 into the table and does not interpret this value as a line feed that is being escaped.\r\n\r\nhttp://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html"}}
{"actor":{"display_login":"ramynasr"}}