https://community.databricks.com/t5/data-engineering/getting-error-datatype-mismatch-binary-op-diff-types/m-p/14742#M9190 <P>[DATATYPE_MISMATCH.BINARY_OP_DIFF_TYPES] Cannot resolve "(DocDate AND orderedhl)" due to data type mismatch: the left and right operands of the binary operator have incompatible types ("STRING" and "DECIMAL(38,6)").; line 67, pos 0</P><P></P><P></P><P>66. group by&nbsp;</P><P>67. ord.DocDate</P><P>68. and ord.orderedhl</P><P>69. and ord.plant</P><P>70. and ord.sku</P> Sat, 24 Dec 2022 10:29:54 GMT georgian2133 2022-12-24T10:29:54Z https://community.databricks.com/t5/data-engineering/getting-error-datatype-mismatch-binary-op-diff-types/m-p/14742#M9190 <P>[DATATYPE_MISMATCH.BINARY_OP_DIFF_TYPES] Cannot resolve "(DocDate AND orderedhl)" due to data type mismatch: the left and right operands of the binary operator have incompatible types ("STRING" and "DECIMAL(38,6)").; line 67, pos 0</P><P></P><P></P><P>66. group by&nbsp;</P><P>67. ord.DocDate</P><P>68. and ord.orderedhl</P><P>69. and ord.plant</P><P>70. and ord.sku</P> Sat, 24 Dec 2022 10:29:54 GMT https://community.databricks.com/t5/data-engineering/getting-error-datatype-mismatch-binary-op-diff-types/m-p/14742#M9190 georgian2133 2022-12-24T10:29:54Z