[
https://issues.apache.org/jira/browse/SPARK-10840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ankit Sarraf updated SPARK-10840:
---------------------------------
Description:
Well formed JSON doesn't work with the 1.5.1 version while using
sqlContext.read.json("<json-file>"):
<code>
{
"employees": {
"employee": [
{
"name": "Mia", <newline>
"surname": "Radison",<newline>
"mobile": "7295913821",<newline>
"email": "miaradi...@sparky.com"
},
{
"name": "Thor",<newline>
"surname": "Kovaskz",<newline>
"mobile": "8829177193",<newline>
"email": "tkova...@sparky.com"
},
{
"name": "Bindy",<newline>
"surname": "Kvuls",<newline>
"mobile": "5033828845",<newline>
"email": "bind...@sparky.com"
}
]
}
}
</code>
Where as, this works because all are in the same line:
[
{"name": "Mia","surname": "Radison","mobile": "7295913821","email":
"miaradi...@sparky.com"},
{"name": "Thor","surname": "Kovaskz","mobile": "8829177193","email":
"tkova...@sparky.com"},
{"name": "Bindy","surname": "Kvuls","mobile": "5033828845","email":
"bind...@sparky.com"}
]
was:
Well formed JSON doesn't work with the 1.5.1 version while using
sqlContext.read.json("<json-file>"):
<code>
{
"employees": {
"employee": [
{
"name": "Mia",
"surname": "Radison",
"mobile": "7295913821",
"email": "miaradi...@sparky.com"
},
{
"name": "Thor",
"surname": "Kovaskz",
"mobile": "8829177193",
"email": "tkova...@sparky.com"
},
{
"name": "Bindy",
"surname": "Kvuls",
"mobile": "5033828845",
"email": "bind...@sparky.com"
}
]
}
}
</code>
Where as, this works because all are in the same line:
[
{"name": "Mia","surname": "Radison","mobile": "7295913821","email":
"miaradi...@sparky.com"},
{"name": "Thor","surname": "Kovaskz","mobile": "8829177193","email":
"tkova...@sparky.com"},
{"name": "Bindy","surname": "Kvuls","mobile": "5033828845","email":
"bind...@sparky.com"}
]
> SparkSQL doesn't work well with JSON
> ------------------------------------
>
> Key: SPARK-10840
> URL: https://issues.apache.org/jira/browse/SPARK-10840
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: Ankit Sarraf
> Priority: Trivial
> Labels: JSON, Scala, SparkSQL
>
> Well formed JSON doesn't work with the 1.5.1 version while using
> sqlContext.read.json("<json-file>"):
> <code>
> {
> "employees": {
> "employee": [
> {
> "name": "Mia", <newline>
> "surname": "Radison",<newline>
> "mobile": "7295913821",<newline>
> "email": "miaradi...@sparky.com"
> },
> {
> "name": "Thor",<newline>
> "surname": "Kovaskz",<newline>
> "mobile": "8829177193",<newline>
> "email": "tkova...@sparky.com"
> },
> {
> "name": "Bindy",<newline>
> "surname": "Kvuls",<newline>
> "mobile": "5033828845",<newline>
> "email": "bind...@sparky.com"
> }
> ]
> }
> }
> </code>
> Where as, this works because all are in the same line:
> [
> {"name": "Mia","surname": "Radison","mobile": "7295913821","email":
> "miaradi...@sparky.com"},
> {"name": "Thor","surname": "Kovaskz","mobile": "8829177193","email":
> "tkova...@sparky.com"},
> {"name": "Bindy","surname": "Kvuls","mobile": "5033828845","email":
> "bind...@sparky.com"}
> ]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
