Partition Filtering Using LIKE

[Andreea Paduraru <t-...@hotels.com>]

Hi,

I would like to know what kind of expressions the ‘LIKE’ operator supports in the case of partition filtering. Is it percent (“%”) and underscore (“_”) or something else?


Thanks,
Andreea

Re: Partition Filtering Using LIKE

[Andreea Paduraru <t-...@hotels.com>]

To give more detail to the previous email, I want to fully replicate the behaviour of the filters in my own code, so I would like to know if “_” will be considered a wildcard matching any character/how it will be matched, and the same for “%”(does it match multiple characters?). Also, can there be more than one of each? Is there anywhere this implementation is documented or defined?

Thank you,
Andreea

From: Andreea Paduraru <t-...@hotels.com>
Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
Date: Thursday, 13 December 2018 at 14:39
To: "user@hive.apache.org" <us...@hive.apache.org>
Subject: Partition Filtering Using LIKE

Hi,

I would like to know what kind of expressions the ‘LIKE’ operator supports in the case of partition filtering. Is it percent (“%”) and underscore (“_”) or something else?


Thanks,
Andreea