When you read JSON data, the input files can be based on a schema with multiple lines or on a schema with a single line.

The following sample shows a JSON schema on a single line:

{"Name":"Tom","Street":"2100 Seaport Blvd","City":"Redwood City","State":"CA","Country":"USA","Zip":"94063"}

The following sample shows a JSON schema that spans across multiple lines:

{
	"Name": "Tom",
	"Surname": "Day",
	"City": "Redwood City",
	"State": "CA",
	"Country": "USA",
	"Zip": "94063"
}

By default, the Hierarchy Processor transformation reads each JSON schema as a single line. To read input that spans across multiple lines, you can configure the formatting options in the Source transformation to read multiple-line JSON files.

When you write JSON data, you can write each output record to a separate file, or you can write all output records to one file.

By default, each output record is written to a separate file. To write the output records to one JSON-formatted file, set the following Spark session property in the mapping task: