Working with JSON using the Dataset API and SQL together

In this recipe, we explore how to use JSON with Dataset. The JSON format has rapidly become the de-facto standard for data interoperability in the last 5 years.

We explore how Dataset uses JSON and executes API commands like select(). We then progress by creating a view (that is, createOrReplaceTempView()) and then execute a SQL query to demonstrate how to query against a JSON file using API and SQL with ease.

How to do it...

1. Start a new project in IntelliJ or in an IDE of your choice. Make sure the necessary JAR files are included.

2. We will use a JSON data file named cars.json which has been created for this example:

{"make": "Telsa", "model": "Model S", "price": 71000.00, "style": "sedan", "kind": "electric"}
{"make": "Audi", "model": "A3 E-Tron", "price": 37900.00, "style": "luxury", "kind": "hybrid"}
{"make": "BMW", "model": "330e", "price": 43700.00, "style": "sedan", "kind": "hybrid"}

3. Set up the package location where the program will...