Attempting to load a JSON file fails due to schema issue (Free Edition)

[chris84]

Hello,

I created a Volume named 'test_volume' under catalog:workspace and schema:default.

Then I uploaded a file named user_0.json into test_volume (fake data, of course):

Now I want to load that file into a data frame.

With Python in a notebook:

With SQL:

Apparently there is a problem with the schema. But how is that possible given how primitive the JSON object is?

What am I doing wrong here?

Thanks

[chris84]

The JSON file I uploaded contained the JSON object pretty printed (multiple lines and spaces for indentation). After removing those (single line), it works.

[JAHNAVI]

@chris84 Could try using spark.read .option("multiline", "true").json("volume_path") in pyspark