IN AZURE STREAM ANALYTICS- The QUERY area for 2 different queries fail

MD DILLS 6

I can run each query independently and get the correct results but when I stack one query ontop of the other it fails. Do I need to insert some sort of SQL Keyword?

The first query pulls the whole stream and uses the built in "spikes and dips" function. I output that to Power BI.

The second query is the same as the first but adds a where clause to return only the Anomalies ( as a subset of all the data) The result from this second query is outputed to Blob Storage.

Again each query works by itself but fails when i stack them. I think I should be able to do this in one "streaming job" or do I need to create a separate streaming job? Thanks in advance for any help here. Cheers,

PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-06-15T05:43:57.433+00:00

Hello @MD DILLS ,

Thanks for the question and using MS Q&A platform.

In order to investigate further, could you please provide the combined query and the error message which you are experiencing?
PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2022-06-20T07:02:55.447+00:00

Hello @MD DILLS ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.