I'm trying to query certain input values from my EventHub with reference data that I retrieve from an SQL database. Is there a way to compare these 2 values? I have already tried parsing from record to float and vice versa, but this is not possible.
Comparison is not allowed for operands of type 'float' and 'record'....
There is a similar case to yours:Error when trying to filter input in stream job query, it is caused the mismatching of values in your expression. Float type can't be compared with Record type.
Please try to use CAST built-in feature to convert the Record into Float.
