azure - “哪里”运算符 : Failed to resolve column or scalar expression named ''

Question

收到错误“where”运算符:从 Azure 门户运行心跳查询时无法解析名为“AgeofOldestMissingRequiredUpdate”的列或标量表达式

Answer 1

'where' operator: Failed to resolve column or scalar expression named 'column name'

此错误可能是多种不同情况造成的。您还没有发布您的查询，但我使用类似的查询遇到了相同的错误

MyTable
| Project Column1, Column2
| where Column3 == "Value"
| Take 100

就我而言，出现了第二个错误:

The name '<column>' does not refer to any known column, table, variable or function.

MyTable的结构确实包含该列!

MyTable
|- Column1
|- Column2
|- Column3

解决方案

我更新了查询，以便 project 子句包含 where 子句中指定的列:

MyTable
| Project Column1, Column2, Column3
| where Column3 == "Value"
| Take 100

然后我就可以成功运行我的查询。 :-)