[ https://issues.apache.org/jira/browse/SPARK-25514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon reassigned SPARK-25514: ------------------------------------ Assignee: Maxim Gekk > Generating pretty JSON by to_json > --------------------------------- > > Key: SPARK-25514 > URL: https://issues.apache.org/jira/browse/SPARK-25514 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 2.4.0 > Reporter: Maxim Gekk > Assignee: Maxim Gekk > Priority: Minor > > It would be nice to have an option, for example *"pretty"*, which enable > special output mode for the to_json function. In the mode, produced JSON > string will have easily readable representation. For example: > {code:scala} > val json = > """[{"book":{"publisher":[{"country":"NL","year":[1981,1986,1999]}]}}]""" > to_json(from_json('col, ...), Map("pretty" -> "true"))) > [ { > "book" : { > "publisher" : [ { > "country" : "NL", > "year" : [ 1981, 1986, 1999 ] > } ] > } > } ] > {code} > There are at least two use cases: > # Exploring content of nested columns. For example, a result of your query is > a few rows, and some columns have deep nested structure. And you want to > analyze and find a value of one of nested fields. > # You already have an JSON in one of columns, and want to explore the JSON > records. New option will allow to do that easily without copy-past JSON > content to an editor by combining from_json and to_json functions. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org