Stream Analytics with Microsoft Azure

Complex types

As previously discussed, arrays are a complex data type posing unique query processing challenges. In our sensors example, a series of motion sensors are contained in an array within a conference room, which itself is one in a series of rooms contained in an array within an office building, which is in a series of buildings in an array. This nested array of sensors within rooms within buildings is a complex structure, all contained in a single column or expression, usually defined with either the Array or Record data types.

Following is a sample of one conference room:

{    "id": "ba5fbde4-bfa1-4046-b361-7dd27019a55f",    "conferenceRoom": "Market Research Lab",    "readings":     {         "Temperature" : 71,         "Humidity" : 52,        "Pressure" :  ...