Description
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
Attachments
Issue Links
- duplicates
-
HIVE-9397 SELECT max(bar) FROM foo is broken after ANALYZE ... FOR COLUMNS
-
- Closed
-