I have a Delta Table Emp with HashKey column as a binary data type.
The HashKey values are like OTg0MTIzMjUyMTk4NzExZmM1ODM4MWMxODJiMGMyMTY, MjEwYjE4ZTUwNTJlOTU0NzY1ZTgzODIwNTg4MGNkZjA=
etc..
When I am trying to do
select * from Emp
where HashKey=’OTg0MTIzMjUyMTk4NzExZmM1ODM4MWMxODJiMGMyMTY’, it’s not working.