Ch 6 Working With JSON

[evohnave]

Using Python...

Having trouble replicating the use of get_json_object and json_tuple (p110). One small issue is using "... as 'column'" [easily fixed with use of .alias("column") instead], but even when accounting for this I'm getting a "DataFrame object is not callable" error. If I replace the col("jsonString") with jsonDF.jsonString (where ever that is used) the error goes away. This sort of replicates what's in use in the documentation for get_json_object, so I'm guessing it's the right answer. And when I run this I get the results in the book...

Also, the SQL string only calls out one column, "column"... and it doesn't seem like the pure SQL code of previous examples, but I was able to reproduce the results.

If you see what I mean and agree I'll do a PR (errata page still down...)

Won't address the Scala code, but it looks as if it would have the same issues...

[JoeKastner]

Just came across this as well. .alias("column") worked for me when testing it out in DataBricks. I'll submit PR for this issue.