New language functions in Stream Analytics

Posted on 11 February 2019

Four new built-in functions in Azure Stream Analytics address common scenarios:

  • REPLACE replaces all occurrences of a specified string value within another string value.
  • COALESCE evaluates a list of arguments and returns the value of the first expression that is not NULL.
  • ROUND returns a numeric value rounded to the specified length or precision.
  • CROSS JOIN joins reference data with an event stream.