[jira] [Created] (HIVE-11372) join with betwee predicate comparing integer types returns no rows when ORC format used

[N Campbell (JIRA)]

N Campbell created HIVE-11372:
---------------------------------

             Summary: join with betwee predicate comparing integer types 
returns no rows when ORC format used
                 Key: HIVE-11372
                 URL: https://issues.apache.org/jira/browse/HIVE-11372
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.2.0
            Reporter: N Campbell


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  ;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)