[jira] [Commented] (HIVE-25939) Support filter pushdown in HBaseStorageHandler for simple expressions with boolean columns

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

    [ 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)