locked
Custom.Dimensions at .blob in different order RRS feed

  • Question

  • I'm using a Stream Analytics job to read from a blob container. When I try to read from a .blob with custom.dimensions I can access the dimensions by index, but sometimes the order of the fields change, so my query is not valid anymore

    My query looks like:

    Select
     GetRecordPropertyValue(GetArrayElement(EventsInput.context.custom.dimensions, 0), 'MyProperty') as MyProperty,
     GetRecordPropertyValue(GetArrayElement(EventsInput.context.custom.dimensions, 1), 'MyProperty2') as MyProperty2,
    ...

    Sometimes I receive my blob files with the order properly, but sometimes the order of the properties change, so I can't access them.

    I tried with CASE/ELSE/END syntax. It's dirty but it works, but as the number of properties is getting bigger, the size of the query is growing exponentially.

    Any idea to access the custom dimensions without index?


    • Edited by monteroBeta Tuesday, September 27, 2016 1:08 PM
    Tuesday, September 27, 2016 12:24 PM