[
https://issues.apache.org/jira/browse/HIVE-9735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14328382#comment-14328382
]
Ashutosh Chauhan commented on HIVE-9735:
----------------------------------------
If you are running your queries through beeline, then you are likely hitting
into it : HIVE-9397
> 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)
