----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/30549/#review70897 -----------------------------------------------------------
Ship it! Ship It! - Ashutosh Chauhan On Feb. 4, 2015, 1:43 a.m., Navis Ryu wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/30549/ > ----------------------------------------------------------- > > (Updated Feb. 4, 2015, 1:43 a.m.) > > > Review request for hive. > > > Bugs: HIVE-9397 > https://issues.apache.org/jira/browse/HIVE-9397 > > > Repository: hive-git > > > Description > ------- > > These queries produce an error : > > {code:sql} > 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; > {code} > > The last query throws {{org.apache.hive.service.cli.HiveSQLException}} > {noformat} > 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> > {noformat} > > > Diffs > ----- > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/StatsOptimizer.java 6961d7f > ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDAFSum.java > d1118f1 > ql/src/test/results/clientpositive/metadata_only_queries.q.out 90c76ed > ql/src/test/results/clientpositive/metadata_only_queries_with_filters.q.out > 5be958f > ql/src/test/results/clientpositive/spark/metadata_only_queries.q.out > 9d6a404 > > ql/src/test/results/clientpositive/spark/metadata_only_queries_with_filters.q.out > 5be958f > ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out 8c0bccb > > Diff: https://reviews.apache.org/r/30549/diff/ > > > Testing > ------- > > > Thanks, > > Navis Ryu > >