Re: CURRENT_TIMESTAMP timezone in hive 3.1

2018-12-13 Thread Jesus Camacho Rodriguez
Hi Andrey, Thanks for reporting this. This is a bug introduced by the JIRA you reference, since CURRENT_TIMESTAMP should not use UTC for every case. I have created https://issues.apache.org/jira/browse/HIVE-21039 to fix the issue and discuss about the desired behavior. -Jesús From: Andrey

Re: Partition Filtering Using LIKE

2018-12-13 Thread Andreea Paduraru
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

Partition Filtering Using LIKE

2018-12-13 Thread Andreea Paduraru
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