[BUG] No data returned on using WHERE clause in SELECT query with connector HBase
Closed this issue · 2 comments
Describe the bug
No data returned on using WHERE clause in SELECT query
To Reproduce
-
On running below query it returns 0 items
SELECT * FROM "lambda:hbasev2finaltest".default.datatypes_test where "cf2:binary_column"=01010101 -
However, on running the same query without WHERE clause, it returns the respective items.
Expected behavior
When using WHERE clause in the SELECT query, expectation is that it returns the respective row.
On using the Glue table for HBase data the mentioned query for binary data works fine. Same is mentioned in the documentation:
https://docs.aws.amazon.com/athena/latest/ug/connectors-hbase.html#connectors-hbase-data-type-support
Further, instead of using binary data directly as in the below query (which is considered as BIGINT)
SELECT * FROM "lambda:hbasev2finaltest".default.datatypes_test where "cf2:binary_column"=01010101
if we query it with escape character then it woks fine. Something like below:
SELECT * FROM "lambda:hbase-master-15-10-2024"."default"."binary_test" where "cf:binary_column" = X'01 01 01 01'
Example with detailed steps is in the attached document.
As no code changes required. So, this issue can be closed now.
@macohen - Can you please assign this ticket to me @abhishekpoddar-trianz