[jira] [Created] (HIVE-9735) aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created HIVE-9735:
--------------------------------

             Summary: aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short
                 Key: HIVE-9735
                 URL: https://issues.apache.org/jira/browse/HIVE-9735
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 0.14.0
            Reporter: N Campbell


select min( tsint.csint ) from tsint 
select max( tsint.csint ) from tsint
ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short

select min( t_tsint.csint ) from t_tsint 

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

create table  if not exists TSINT ( RNUM int , CSINT smallint   )
TERMINATED BY '\n' 
 STORED AS orc  ;

input data loaded into text file and then inserted into ORC table from text based table

0|\N
1|-1
2|0
3|1
4|10




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