Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
MIME-Version: 1.0
From: Amey Barve <ameybarve15@gmail.com>
Date: Fri, 26 Feb 2016 15:55:04 +0530
Message-ID: 
 <CAOr_EshowvuTGLe6BGe327K6cpSbNEFt1U73F8qu_9PKXOYOKg@mail.gmail.com>
Subject: predicate push down with custom StorageHandler
To: user@hive.apache.org, dev@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11393f54b9de82052ca9b8ca

--001a11393f54b9de82052ca9b8ca
Content-Type: text/plain; charset=UTF-8

Hi All,

I have implemented HiveStoragePredicateHandler for my StorageHandler.

I am able to push down predicates for following query and this works fine.
Example: select o_custkey,c_custkey from customer,orders where c_mktsegment
= 'BUILDING';
(*column-ref = c_mktsegment comparison-op = op constant-value = 'BUILDING'*)

I get no results when I execute following query
Example: select o_custkey,c_custkey from customer,orders where
 c_mktsegment = 'BUILDING' and c_custkey = o_custkey limit 10;
in this case (*column-ref = c_mktsegment comparison-op = op constant-value
= 'BUILDING'*) is evaluated by my storageHandler.
While (*column-ref = c_custkey comparison-op = op constant-value =
o_custkey*) is evaluated by hive.

Does such kind of query work with non native tables with predicate push
down or am I missing anything?
Does any custom StorageHandler like HBaseStorageHandler,
AccumuloStorageHandler, CassandraStorageHandler etc. support such kind of
predicate push down.

Thanks and Regards,
Amey

--001a11393f54b9de82052ca9b8ca--