[jira] [Created] (SPARK-25514) Pretty JSON

["Maxim Gekk (JIRA)" <ji...@apache.org>]

Maxim Gekk created SPARK-25514:
----------------------------------

             Summary: Pretty 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


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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org