Analytics Engine does not perform a cardinality check on scalar subqueries. Make sure the scalar subquery returns no more than one row.