[ https://issues.apache.org/jira/browse/HIVE-10266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis updated HIVE-10266: --------------------------------------- Fix Version/s: (was: 0.13.0) I cleared the fixVersion field since this ticket is still open. Please review this ticket and if the fix is already committed to a specific version please set the version accordingly and mark the ticket as RESOLVED. According to the [JIRA guidelines|https://cwiki.apache.org/confluence/display/Hive/HowToContribute] the fixVersion should be set only when the issue is resolved/closed. > Boolean expression True and True returns False > ---------------------------------------------- > > Key: HIVE-10266 > URL: https://issues.apache.org/jira/browse/HIVE-10266 > Project: Hive > Issue Type: Bug > Components: SQL > Affects Versions: 0.14.0 > Reporter: ckran > Priority: Major > > A Hive query with a Boolean expression with day and month calculations that > each evaluate to TRUE with use of AND evaluates to FALSE. > create table datest (cntr int, date date ) row format delimited fields > terminated by ',' stored as textfile ; > insert into table datest values (1,'2015-04-8') ; > select > ((DAY('2015-05-25') - DAY(DATE)) < 25), > ((MONTH('2015-05-25') - MONTH(DATE)) = 1) , > ((DAY('2015-05-25') - DAY(DATE)) < 25) AND ((MONTH('2015-05-25') - > MONTH(DATE)) = 1) > from datest > Returns values > True | True | False -- This message was sent by Atlassian Jira (v8.20.10#820010)