How to query nested fields in mongodb using presto?

@kadin 

To query nested fields in MongoDB using Presto, you can use the following steps:

1. Connect to your MongoDB instance by setting up a MongoDB connector in Presto. You can refer to the documentation of Presto for instructions on how to do this.
2. Once you have connected to your MongoDB instance, you can write SQL queries in Presto to query nested fields. For example, if you have a collection called "users" with documents structured like this:

1
2
3
4
5
6
7
8

{
  "_id": "1",
  "name": "John",
  "address": {
    "street": "123 Main St",
    "city": "New York"
  }
}

You can query the nested field "street" in the "address" field like this:

1

SELECT name, address['street'] FROM users;

This query will return the name of the user and the street address from the "address" field.

1. You can also perform more complex queries on nested fields by using dot notation. For example, if you want to query all users who live in a specific city, you can use the following query:

1

SELECT name FROM users WHERE address['city'] = 'New York';

This query will return the name of all users who live in the city of "New York".

By following these steps, you can query nested fields in MongoDB using Presto.