| |
| create table foo_n9(x date, y timestamp) stored as orc; |
| |
| insert into foo_n9 values('1999-01-01', '1999-01-01 00:00:01'), ('2018-01-01', '2018-01-01 23:23:59'); |
| |
| analyze table foo_n9 compute statistics for columns; |
| |
| set hive.compute.query.using.stats=true; |
| |
| set test.comment=All queries need to be just metadata fetch tasks |
| |
| explain select min(x) from foo_n9; |
| explain select max(x) from foo_n9; |
| explain select count(x) from foo_n9; |
| |
| explain select count(x), max(x), min(x) from foo_n9; |
| |
| select count(x), max(x), min(x) from foo_n9; |