abhishekpoddar-trianz
commented
2 days ago 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.
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.