hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3617) Predicates pushed down to hbase is not handled properly when constant part is shown first
Date Tue, 21 Jan 2014 00:31:22 GMT

    [ https://issues.apache.org/jira/browse/HIVE-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13877028#comment-13877028
] 

Navis commented on HIVE-3617:
-----------------------------

I also confused with that. negate() had the semantic as you described (> for <=, etc),
which is now removed. 

In a word, "3<a" is "a>3", not "a>=3"

> Predicates pushed down to hbase is not handled properly when constant part is shown first
> -----------------------------------------------------------------------------------------
>
>                 Key: HIVE-3617
>                 URL: https://issues.apache.org/jira/browse/HIVE-3617
>             Project: Hive
>          Issue Type: Bug
>          Components: HBase Handler
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-3617.3.patch.txt
>
>
> Test result could not show the difference because predicates pushed down are not removed
currently(HIVE-2897). So I added log message(scan.toMap()) and checked the output.
> with query
> select * from hbase_ppd_keyrange where key > 8 and key < 21;
> timeRange=[0, 9223372036854775807], batch=-1, startRow=\x00\x00\x00\x08\x00, stopRow=\x00\x00\x00\x15,
...
> but with query
> select * from hbase_ppd_keyrange where 8 < key and key < 21;
> timeRange=[0, 9223372036854775807], batch=-1, startRow=, stopRow=\x00\x00\x00\x15, ...



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message