cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

You have json file which is nested with multiple key value pair how you read it in databricks?

learning_1989
New Contributor II

You have json file which is nested with multiple key value pair how you read it in databricks?

2 REPLIES 2

Ayushi_Suthar
Databricks Employee
Databricks Employee

Hello @learning_1989 Please have a look at the following document to see how to read the JSON file in Databricks:
Document: https://docs.databricks.com/en/query/formats/json.html#json-file

This allows you to read JSON files with key-value pairs in single-line or multi-line mode. In single-line mode, a file can be split into many parts and read in parallel. In multi-line mode, a file is loaded as a whole entity and cannot be split.

Lakshay
Databricks Employee
Databricks Employee

You should be able to read the json file with below code.

val df = spark.read.format("json").load("file.json")

After this you will need to use the explode function to add columns to the dataframe using the nested values.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group