Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
From: Amey Barve <ameybarve15@gmail.com>
Date: Thu, 5 May 2016 16:23:39 +0530
Message-ID: <CAOr_Eshd63uqFTVxZiUYsujej0xwik-WTzhwh-UghqFv3i3C-A@mail.gmail.com>
Subject: Predicates for 'like' and 'between' operators to custom storage handler.
To: user@hive.apache.org, dev@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11c133c80118ff0532162a8a
archived-at: Thu, 05 May 2016 10:54:28 -0000

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

Hi All,

I have implemented custom storage-handler and able to get predicates from
hive for '=', '!=', '<', '<=', '>' and '>=' operators.
But I cannot get predicates from hive for 'like', 'between' operators.

Here's my code:

*final String expression = conf.get(TableScanDesc.FILTER_EXPR_CONF_STR);*

here expression remains null for like and between operators but not null
for above operators.

Does hive not give predicates for 'like' and 'between' operators to custom
storage handler ?
*Is there some other mechanism to get predicates for 'like' operator*?

I tested with hive version 1.2 and 0.14.

Thanks and Regards,
Amey

--001a11c133c80118ff0532162a8a
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi All,<div><br></div><div><div>I have implemented custom =
storage-handler and able to get predicates from hive for &#39;=3D&#39;, =
9;!=3D&#39;, &#39;&lt;&#39;, &#39;&lt;=3D&#39;, &#39;&gt;&#39; and &#39;&gt=
;=3D&#39; operators.</div><div>But I cannot get predicates from hive for &#=
39;like&#39;, &#39;between&#39; operators.</div><div><br></div><div>Here=
9;s my code:</div><div><br></div><div><b>final String expression =3D conf.g=
et(TableScanDesc.FILTER_EXPR_CONF_STR);</b></div><div><br></div><div>here e=
xpression remains null for like and between operators but not null for abov=
e operators.</div><div><br></div><div>Does hive not give predicates for =
9;like&#39; and &#39;between&#39; operators to custom storage handler ?</di=
v><div><b>Is there some other mechanism to get predicates for &#39;like&#39=
; operator</b>?</div><div><br></div><div>I tested with hive version 1.2 and=
 0.14.</div></div><div><br></div><div>Thanks and Regards,</div><div>Amey</d=
iv></div>

--001a11c133c80118ff0532162a8a--