{"action":"created","issue":{"url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/201","repository_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde","labels_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/201/labels{/name}","comments_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/201/comments","events_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/201/events","html_url":"https://github.com/rcongiu/Hive-JSON-Serde/issues/201","id":273227609,"node_id":"MDU6SXNzdWUyNzMyMjc2MDk=","number":201,"title":"Can I process multiline JSON data in HIVE ??","user":{"login":"debuggerrr","id":16878718,"node_id":"MDQ6VXNlcjE2ODc4NzE4","avatar_url":"https://avatars2.githubusercontent.com/u/16878718?v=4","gravatar_id":"","url":"https://api.github.com/users/debuggerrr","html_url":"https://github.com/debuggerrr","followers_url":"https://api.github.com/users/debuggerrr/followers","following_url":"https://api.github.com/users/debuggerrr/following{/other_user}","gists_url":"https://api.github.com/users/debuggerrr/gists{/gist_id}","starred_url":"https://api.github.com/users/debuggerrr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/debuggerrr/subscriptions","organizations_url":"https://api.github.com/users/debuggerrr/orgs","repos_url":"https://api.github.com/users/debuggerrr/repos","events_url":"https://api.github.com/users/debuggerrr/events{/privacy}","received_events_url":"https://api.github.com/users/debuggerrr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2017-11-12T13:06:30Z","updated_at":"2018-10-23T07:34:28Z","closed_at":null,"author_association":"NONE","body":"I am able to create table and process data for single line JSON data but my question is can I process JSON data like below:  \r\n```\r\n[{\r\n\t\"field1\": \"data1\",\r\n\t\"field2\": 100,\r\n\t\"field3\": \"more data1\",\r\n\t\"field4\": 123.001\r\n}, {\r\n\t\"field1\": \"data2\",\r\n\t\"field2\": 200,\r\n\t\"field3\": \"more data2\",\r\n\t\"field4\": 123.002\r\n}, {\r\n\t\"field1\": \"data3\",\r\n\t\"field2\": 300,\r\n\t\"field3\": \"more data3\",\r\n\t\"field4\": 123.003\r\n}, {\r\n\t\"field1\": \"data4\",\r\n\t\"field2\": 400,\r\n\t\"field3\": \"more data4\",\r\n\t\"field4\": 123.004\r\n}]\r\n```\r\nI have read that multiline JSON data wasn't supported in HIVE but can I use it now?? If yes, then please share the links where I can find this because I searched alot for this but I couldn't find any relevant material for this. Thanks in advance ."},"comment":{"url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/comments/432129830","html_url":"https://github.com/rcongiu/Hive-JSON-Serde/issues/201#issuecomment-432129830","issue_url":"https://api.github.com/repos/rcongiu/Hive-JSON-Serde/issues/201","id":432129830,"node_id":"MDEyOklzc3VlQ29tbWVudDQzMjEyOTgzMA==","user":{"login":"fayedd","id":17870695,"node_id":"MDQ6VXNlcjE3ODcwNjk1","avatar_url":"https://avatars3.githubusercontent.com/u/17870695?v=4","gravatar_id":"","url":"https://api.github.com/users/fayedd","html_url":"https://github.com/fayedd","followers_url":"https://api.github.com/users/fayedd/followers","following_url":"https://api.github.com/users/fayedd/following{/other_user}","gists_url":"https://api.github.com/users/fayedd/gists{/gist_id}","starred_url":"https://api.github.com/users/fayedd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fayedd/subscriptions","organizations_url":"https://api.github.com/users/fayedd/orgs","repos_url":"https://api.github.com/users/fayedd/repos","events_url":"https://api.github.com/users/fayedd/events{/privacy}","received_events_url":"https://api.github.com/users/fayedd/received_events","type":"User","site_admin":false},"created_at":"2018-10-23T07:34:28Z","updated_at":"2018-10-23T07:34:28Z","author_association":"NONE","body":"Since a nomal json should start wih '{' and end with '}', maybe you can remove the '[' and ']' and then set  row format delimited fields terminated by ','"}}
{"actor":{"display_login":"fayedd"}}