hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhaval Modi <dhavalmod...@gmail.com>
Subject Re: hive 2.1.0 Comparison of timestamp fails if empty string is provided.
Date Tue, 20 Dec 2016 14:43:26 GMT
Hi Xupeng,

You need to check for NULL for 'cast("2016-12-31 12:00:00" as timestamp)'.

Regards,
Dhaval Modi
dhavalmodi24@gmail.com

On 20 December 2016 at 07:08, 徐 鹏 <xupeng1226@outlook.com> wrote:

> Dear all:
>         version :2.1.0 (fixed issue:HIVE-15291)
>         query:select cast("2016-12-31 12:00:00" as timestamp) <> ‘'
>         expected result:true
>         actual result:NULL
>
>
>
>
>
>

Mime
View raw message