[HIVE-9397] SELECT max(bar) FROM foo is broken after ANALYZE ... FOR COLUMNS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0, 1.0.0, 1.1.0
• Fix Version/s: 1.2.0
• Component/s: Beeline, Logical Optimizer
• Assignee: Maikl
• Reporter: Damien Carol
• Created: 16/Jan/15 14:46
• Updated: 15/Jul/19 21:41
• Resolved: 05/Feb/15 00:03

Description

These queries produce an error :

DROP TABLE IF EXISTS foo;

CREATE TABLE foo (id int) STORED AS ORC;

INSERT INTO TABLE foo VALUES (1);
INSERT INTO TABLE foo VALUES (2);
INSERT INTO TABLE foo VALUES (3);
INSERT INTO TABLE foo VALUES (4);
INSERT INTO TABLE foo VALUES (5);

SELECT max(id) FROM foo;

ANALYZE TABLE foo COMPUTE STATISTICS FOR COLUMNS id;

SELECT max(id) FROM foo;

The last query throws org.apache.hive.service.cli.HiveSQLException

0: jdbc:hive2://nc-h04:10000/casino> SELECT max(id) FROM foo;
+-------------+--+
|     _c0     |
+-------------+--+
org.apache.hive.service.cli.HiveSQLException: java.lang.ClassCastException
0: jdbc:hive2://nc-h04:10000/casino>

Issue Links

• is duplicated by: HIVE-9735 aggregate ( smalllint ) fails when ORC file used ava.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Short
• links to: review board