{"action":"created","issue":{"url":"https://api.github.com/repos/databricks/spark-xml/issues/196","repository_url":"https://api.github.com/repos/databricks/spark-xml","labels_url":"https://api.github.com/repos/databricks/spark-xml/issues/196/labels{/name}","comments_url":"https://api.github.com/repos/databricks/spark-xml/issues/196/comments","events_url":"https://api.github.com/repos/databricks/spark-xml/issues/196/events","html_url":"https://github.com/databricks/spark-xml/issues/196","id":187028637,"number":196,"title":"Getting \"null\" when selecting second or futher columns","user":{"login":"someonehere15","id":18473637,"avatar_url":"https://avatars.githubusercontent.com/u/18473637?v=3","gravatar_id":"","url":"https://api.github.com/users/someonehere15","html_url":"https://github.com/someonehere15","followers_url":"https://api.github.com/users/someonehere15/followers","following_url":"https://api.github.com/users/someonehere15/following{/other_user}","gists_url":"https://api.github.com/users/someonehere15/gists{/gist_id}","starred_url":"https://api.github.com/users/someonehere15/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/someonehere15/subscriptions","organizations_url":"https://api.github.com/users/someonehere15/orgs","repos_url":"https://api.github.com/users/someonehere15/repos","events_url":"https://api.github.com/users/someonehere15/events{/privacy}","received_events_url":"https://api.github.com/users/someonehere15/received_events","type":"User","site_admin":false},"labels":[{"id":291799773,"url":"https://api.github.com/repos/databricks/spark-xml/labels/duplicate","name":"duplicate","color":"cccccc","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-11-03T10:57:51Z","updated_at":"2016-11-03T13:29:15Z","closed_at":"2016-11-03T13:21:11Z","body":"Hi,\r\n\r\nso I have e.g. the following XML file:\r\n```\r\n<root>\r\n  <first>\r\n    <a>textA</a>\r\n  </first>\r\n  <second>\r\n    <b>textB</b>\r\n  </second>\r\n  <third>\r\n    <c>textC</c>\r\n  </third>\r\n</root>\r\n```\r\nI load it into Spark through the DataBricks XML package, and everything looks good and loaded correctly.\r\nWhen I try to select `first `or `first.a`, then I get the result correctly.\r\n\r\nBut if I try to get `second` or `second.b`, or `third` or `third.c`, then I get `null`.\r\n\r\nI tried with a direct query, select function, everything, I don't know what the problem is.\r\nThe rowTag is root.\r\nAny ideas?"},"comment":{"url":"https://api.github.com/repos/databricks/spark-xml/issues/comments/258141954","html_url":"https://github.com/databricks/spark-xml/issues/196#issuecomment-258141954","issue_url":"https://api.github.com/repos/databricks/spark-xml/issues/196","id":258141954,"user":{"login":"HyukjinKwon","id":6477701,"avatar_url":"https://avatars.githubusercontent.com/u/6477701?v=3","gravatar_id":"","url":"https://api.github.com/users/HyukjinKwon","html_url":"https://github.com/HyukjinKwon","followers_url":"https://api.github.com/users/HyukjinKwon/followers","following_url":"https://api.github.com/users/HyukjinKwon/following{/other_user}","gists_url":"https://api.github.com/users/HyukjinKwon/gists{/gist_id}","starred_url":"https://api.github.com/users/HyukjinKwon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/HyukjinKwon/subscriptions","organizations_url":"https://api.github.com/users/HyukjinKwon/orgs","repos_url":"https://api.github.com/users/HyukjinKwon/repos","events_url":"https://api.github.com/users/HyukjinKwon/events{/privacy}","received_events_url":"https://api.github.com/users/HyukjinKwon/received_events","type":"User","site_admin":false},"created_at":"2016-11-03T13:29:15Z","updated_at":"2016-11-03T13:29:15Z","body":"Thank you for reporting this!"}}
{"actor":{"display_login":"HyukjinKwon"}}