Using Map Steps with JSON Data

On import, Oracle NoSQL Database stores JSON objects as MAP(JSON). This means you can use map filter steps with your JSON objects.

For example, if you want to visually examine the JSON fields in use by your rows:

sql-> SELECT id, j.person.keys() FROM JSONPersons j;
 +----+------------------------+
 | id |        Column_2        |
 +----+------------------------+
 |  4 | address                |
 |    | age                    |
 |    | connections            |
 |    | expenses               |
 |    | firstname              |
 |    | income                 |
 |    | lastLogin              |
 |    | lastname               |
 +----+------------------------+
 |  6 | myarray                |
 |    | mynumber               |
 +----+------------------------+
 |  3 | address                |
 |    | age                    |
 |    | connections            |
 |    | expenses               |
 |    | firstname              |
 |    | income                 |
 |    | lastLogin              |
 |    | lastname               |
 +----+------------------------+
 |  5 | address                |
 |    | age                    |
 |    | connections            |
 |    | expenses               |
 |    | firstname              |
 |    | income                 |
 |    | lastLogin              |
 |    | lastname               |
 +----+------------------------+
 |  1 | address                |
 |    | age                    |
 |    | connections            |
 |    | expenses               |
 |    | firstname              |
 |    | income                 |
 |    | lastLogin              |
 |    | lastname               |
 +----+------------------------+
 |  7 | myarray                |
 |    | mynumber               |
 +----+------------------------+
 |  2 | address                |
 |    | age                    |
 |    | connections            |
 |    | expenses               |
 |    | firstname              |
 |    | income                 |
 |    | lastLogin              |
 |    | lastname               |
 +----+------------------------+

7 rows returned