[
https://issues.apache.org/jira/browse/HIVE-25939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17488856#comment-17488856
]
Stamatis Zampetakis commented on HIVE-25939:
--------------------------------------------
Since the existing code (see
[IndexPredicateAnalyzer|https://github.com/apache/hive/blob/4b7a948e45fd88372fef573be321cda40d189cc7/ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java#L209])
knows how to handle already many expressions in the form "col = literal" one
idea for solving this issue would be to bring also the expressions above with
boolean columns into this form and use the same code
> 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
> Priority: Major
>
> 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)
