[HIVE-11372] join with between predicate comparing integer types returns no rows when ORC format used

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 2.0.0
• Release Note: Re-submit
• Assignee: Matt McCline
• Reporter: N Campbell
• Created: 25/Jul/15 12:49
• Updated: 02/Jun/16 10:17
• Resolved: 04/Dec/15 20:00

Description

getDatabaseProductName Apache Hive
getDatabaseProductVersion 1.2.1.2.3.0.0-2557
getDriverName Hive JDBC
getDriverVersion 1.2.1.2.3.0.0-2557
getDriverMajorVersion 1
getDriverMinorVersion 2

select tint.rnum, tsint.rnum from tint , tsint where tint.cint between tsint.csint and tsint.csint

when ORC used no rows returned versus TEXT

create table if not exists TSINT ( RNUM int , CSINT smallint )
– ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
STORED AS orc ;

create table if not exists TINT ( RNUM int , CINT int )
– ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
STORED AS orc ;