How to fix "where' operator: Failed to resolve scalar expression named 'properties_s'" when running the standard query named "List all input deserialization errors" in Stream Analytics job

Question

How to fix "where' operator: Failed to resolve scalar expression named 'properties_s'" when running the standard query named "List all input deserialization errors" in Stream Analytics job

Lucas Pires Savassa 0

When attempting to run the following standard query:
A print screen showing a list of suggested standard queries to run in the resource Logs

The following error message is displayed

'where' operator: Failed to resolve scalar expression named 'properties_s'

A print screen a query text editor containing the standard query that runs, an an error message saying that one of the columns listed doesn't exist

If the column properties_s doesn't exist, which column should I use instead?

Venkat Reddy Navari 1,585 Reputation points Microsoft External Staff

2025-03-19T11:37:55.07+00:00

@Lucas Pires Savassa We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Venkat Reddy Navari 1,585 Reputation points Microsoft External Staff

2025-03-19T11:37:55.07+00:00

@Lucas Pires Savassa We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi Lucas Pires Savassa
The error you're encountering indicates that the column properties_s is being referenced in your query, but it does not exist in your dataset or event schema. This could happen if there is a mismatch between the column name used in the query and the actual column in the data stream.

Check the Data Schema: Look at the data you're working with to see if properties_s is a valid column. The name might have changed.
Find the Correct Column: If properties_s isn't there, find the correct column that should be used instead. You can check the event data or logs for this.

If the column properties_s doesn't exist, which column should I use instead?

Check the Table: If you're not sure, run this query to view the columns in your data:

SELECT * FROM input_stream LIMIT 10

This will help you find the right column. Once you find the correct column, replace properties_s

in your query with it.

I hope this helps. Please let us know if you have any further questions.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Venkat Reddy Navari 1,585 Reputation points Microsoft External Staff

2025-03-20T09:16:36.3+00:00

Lucas Pires Savassa Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

How to fix "where' operator: Failed to resolve scalar expression named 'properties_s'" when running the standard query named "List all input deserialization errors" in Stream Analytics job

1 answer

Your answer