I have jsut started to use databricks, I'm using the community cloud and I'm trying to read json file.
I have tried to do this as following:

```
from pyspark.sql import SparkSession

df=spark.read.json('people')

```

But then I'm getting error:

> 
> IllegalArgumentException: Path must be absolute: people
> 
> 
> 

I have tried to acess the people.json file with different writing:

'people.json', '/people.json','Data/deafult/people' ect., the last one is based on where I understood that the data is stored:

[![enter image description here](https://i.stack.imgur.com/r2Lvt.png)](https://i.stack.imgur.com/r2Lvt.png)

However, that did not work and I kept geting the same error message.

HoWhenever I try to read it with sql.Context.sql it shows the table:

```
df=sqlContext.sql("SELECT * FROM people")
df.show()

>>>
+----+-------+
| age|   name|
+----+-------+
|null|Michael|
|  30|   Andy|
|  19| Justin|
+----+-------+

```

**So my question is how can I open the json file with spark.read.json?**