ozgrakkurt opened a new issue, #3125:
URL: https://github.com/apache/arrow-datafusion/issues/3125
Hi,
I want to query parquet files by a binary column. I have the scalar value to
query by in hex form and I want to run an sql query.
I tried `to_hex` and postgres style `encode` but neither seemed to work.
```sql
SELECT block_number from log
WHERE log.block_number >= 10000000
AND log.block_number < 10001000
AND encode(log.address, 'hex') =
'0xced4e93198734ddaff8492d525bd258d49eb388e'
```
or
```sql
SELECT block_number from log
WHERE log.block_number >= 10000000
AND log.block_number < 10001000
AND to_hex(log.address) = '0xced4e93198734ddaff8492d525bd258d49eb388e'
```
I get this error with `to_hex`:
```
failed to execute query:\nError during planning: Coercion from [Binary] to
the signature Uniform(1, [Int64]) failed.
```
Would it be possible to implement this? also how can I enter a binary
literal so maybe I can run this query now?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
