How to use varbinary column in where clause

1

I am looking forward to use varbinary column in where clause in one of the SQL queries. In dataset, column is varbinay and writing the sql queries to filter some data into it. But it unable to parse the query.

select * from testdataset where id = 0xA98159FE

id is a varbinary column.

2

@alokseth84 What happens if you wrap the value (0xA98159FE) in single quotes?

3

Cannot apply ‘=’ to arguments of type ‘<VARBINARY(65536)> = <VARCHAR(18)>’. Supported form(s): ‘<COMPARABLE_TYPE> = <COMPARABLE_TYPE>’ ’ = ’ ’ = '.

4

@alokseth84 Is id a number/int/bigint data type?

5

id is a varbinary data type.

6

@alokseth84 Try using something like this?
where id = CONVERT_TO(‘somestring’,‘UTF8’)

CONVERT_TO should convert it to a binary string. See Docs: Dremio