Stamatis Zampetakis created HIVE-25939:
------------------------------------------
Summary: Support filter pushdown in HBaseStorageHandler for simple
expressions with boolean columns
Key: HIVE-25939
URL: https://issues.apache.org/jira/browse/HIVE-25939
Project: Hive
Issue Type: Improvement
Reporter: Stamatis Zampetakis
In current master (commit
[4b7a948e45fd88372fef573be321cda40d189cc7|https://github.com/apache/hive/commit/4b7a948e45fd88372fef573be321cda40d189cc7]),
the HBaseStorageHandler is able to push many simple comparison predicates into
the underlying engine but fails do so for some simple predicates with boolean
columns.
The goal of this issue is to support filter pushdown in HBaseStorageHandler for
the following queries.
{code:sql}
CREATE TABLE hbase_table(row_key string, c1 boolean, c2 boolean)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" = ":key,cf:c1,cf:c2"
);
explain select * from hbase_table where c1;
explain select * from hbase_table where not c1;
explain select * from hbase_table where c1 = true;
explain select * from hbase_table where c1 = false;
explain select * from hbase_table where c1 IS TRUE;
explain select * from hbase_table where c1 IS FALSE;
{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
