{"action":"created","issue":{"url":"https://api.github.com/repos/databricks/spark-xml/issues/217","repository_url":"https://api.github.com/repos/databricks/spark-xml","labels_url":"https://api.github.com/repos/databricks/spark-xml/issues/217/labels{/name}","comments_url":"https://api.github.com/repos/databricks/spark-xml/issues/217/comments","events_url":"https://api.github.com/repos/databricks/spark-xml/issues/217/events","html_url":"https://github.com/databricks/spark-xml/issues/217","id":195618803,"number":217,"title":"There is a problem on the    inner join CONDITION  between two  XML file  with multiple attributes per tag","user":{"login":"shermilaguerra","id":16290660,"avatar_url":"https://avatars.githubusercontent.com/u/16290660?v=3","gravatar_id":"","url":"https://api.github.com/users/shermilaguerra","html_url":"https://github.com/shermilaguerra","followers_url":"https://api.github.com/users/shermilaguerra/followers","following_url":"https://api.github.com/users/shermilaguerra/following{/other_user}","gists_url":"https://api.github.com/users/shermilaguerra/gists{/gist_id}","starred_url":"https://api.github.com/users/shermilaguerra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shermilaguerra/subscriptions","organizations_url":"https://api.github.com/users/shermilaguerra/orgs","repos_url":"https://api.github.com/users/shermilaguerra/repos","events_url":"https://api.github.com/users/shermilaguerra/events{/privacy}","received_events_url":"https://api.github.com/users/shermilaguerra/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-14T19:11:43Z","updated_at":"2016-12-15T08:06:17Z","closed_at":null,"body":"Good morning!!\r\nplease, i am to do join inner in XML file(f1 and f2) with multiple attributes per tag in spark-xml.\r\nNext query\r\nf1.join(f2).select(\"p1.DADOS_BASICOS_DO_ARTIGO.@TITULO_DO_ARTIGO\", \"p2.DADOS_BASICOS_DO_ARTIGO.@TITULO_DO_ARTIGO\",\"p2.DADOS_BASICOS_DO_ARTIGO.@ANO_DO_ARTIGO\",\"p2.DADOS_BASICOS_DO_ARTIGO.@PAIS_DE_PUBLICACAO\").show()\r\n\r\nit shows very well:\r\n+--------------------+--------------------+--------------+-------------------+\r\n| @TITULO_DO_ARTIGO| @TITULO_DO_ARTIGO|@ANO_DO_ARTIGO|@PAIS_DE_PUBLICACAO|\r\n+--------------------+--------------------+--------------+-------------------+\r\n|Approximation By ...|Generalized inter...| 1997| Estados Unidos|\r\n|Interpolation On ...|Generalized inter...| 1997| Estados Unidos|\r\n|Generalized Inter...|Generalized inter...| 1997| Estados Unidos|\r\n|Interpolation On ...|Generalized inter...| 1997| Estados Unidos|\r\n|Strictly Positive...|Generalized inter...| 1997| Estados Unidos|\r\n|Strictly Positive...|Generalized inter...| 1997| Estados Unidos|\r\n|Interpolation On ...|Generalized inter...| 1997| Estados Unidos|\r\n|Fundamental sets ...|Generalized inter...| 1997| Estados Unidos|\r\n|Strict positive d...|Generalized inter...| 1997| Estados Unidos|\r\n|Strictly positive...|Generalized inter...| 1997| Estados Unidos|\r\n|Positive definite...|Generalized inter...| 1997| Estados Unidos|\r\n|A complex approac...|Generalized inter...| 1997| Estados Unidos|\r\n|Strict positive d...|Generalized inter...| 1997| Estados Unidos|\r\n|A necessary and s...|Generalized inter...| 1997| Estados Unidos|\r\n|Conditionally pos...|Generalized inter...| 1997| Estados Unidos|\r\n|Operators associa...|Generalized inter...| 1997| Estados Unidos|\r\n|Annihilating prop...|Generalized inter...| 1997| Estados Unidos|\r\n|Orthogonal basis ...|Generalized inter...| 1997| Estados Unidos|\r\n|Strictly positive...|Generalized inter...| 1997| Estados Unidos|\r\n|Approximation on ...|Generalized inter...| 1997| Estados Unidos|\r\n+--------------------+--------------------+--------------+-------------------+`\r\n\r\ntype(publicacoes1) and type(publicacoes1) is:\r\n<class 'pyspark.sql.dataframe.DataFrame'>\r\n\r\nthe problem is in the JOIN CONDITION \r\npublicacoes2.join(publicacoes1, (\"publicacoes2.p1.@TITULO_DO_ARTIGO\"== \"publicacoes1.p2.@TITULO_DO_ARTIGO\" ), 'inner' )\\.select(\"p2.DADOS_BASICOS_DO_ARTIGO.@TITULO_DO_ARTIGO\",\"p2.DADOS_BASICOS_DO_ARTIGO.@ANO_DO_ARTIGO\", \"p2.DADOS_BASICOS_DO_ARTIGO.@PAIS_DE_PUBLICACAO\").show()\r\nlast code shows this erro: on should be Column or list of Column\r\n\r\nThank you very much for your support.\r\nbest regards,\r\nShermila."},"comment":{"url":"https://api.github.com/repos/databricks/spark-xml/issues/comments/267263723","html_url":"https://github.com/databricks/spark-xml/issues/217#issuecomment-267263723","issue_url":"https://api.github.com/repos/databricks/spark-xml/issues/217","id":267263723,"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-12-15T08:06:16Z","updated_at":"2016-12-15T08:06:16Z","body":"@shermilaguerra Could I ask to try this with higher versions such as  0.4.1 for Spark 2.x or 0.3.5 for Spark 1.3+ please?"}}
{"actor":{"display_login":"HyukjinKwon"}}