[ https://issues.apache.org/jira/browse/HIVE-17640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16184879#comment-16184879 ]
Vigith Maurice commented on HIVE-17640: --------------------------------------- This seems to be the issue casting of timestamp to date returns NULL. hive (default)> select cast('2017-01-01 00:00:00' as date); OK NULL > Comparison of date return null if time part is provided in string. > ------------------------------------------------------------------ > > Key: HIVE-17640 > URL: https://issues.apache.org/jira/browse/HIVE-17640 > Project: Hive > Issue Type: Bug > Reporter: Yongzhi Chen > Assignee: Yongzhi Chen > Fix For: 2.1.0 > > > Reproduce: > select '2017-01-01 00:00:00' < current_date; > INFO : OK > ... > 1 row selected (18.324 seconds) > ... > NULL -- This message was sent by Atlassian JIRA (v6.4.14#64029)