Is it possible to query nested json properties from a parquet datasource?

1

For example I have a datasource with two columns: an Id column and a position column.

The Id consists of an integer. The position column consists of a json object. e.g.

{
“x”:3.142,
“y”:7.234
}

Is is possible to write a SQL query in the editor that returns all of the rows in the datasource with ‘x’ contained between a lower and upper bound? If so what is the syntax?

2

What is the type of column “position” in parquet?
There reason I am asking is if type of “position” column is “map” you can always do:

SELECT id, “table_name”.position.x where “table_name”.position.x > N1 and “table_name”.position.x < N2