| --! qt:dataset:src | |
| set hive.stats.fetch.column.stats=true; | |
| drop table if exists decimal_1_n1; | |
| create table decimal_1_n1 (t decimal(4,2), u decimal(5), v decimal); | |
| desc decimal_1_n1; | |
| insert overwrite table decimal_1_n1 | |
| select cast('17.29' as decimal(4,2)), 3.1415926BD, null from src; | |
| analyze table decimal_1_n1 compute statistics for columns; | |
| desc formatted decimal_1_n1 v; | |
| explain select * from decimal_1_n1 order by t limit 100; | |
| drop table decimal_1_n1; |