[HIVE-7053] Unable to fetch column stats from decimal columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.14.0
• Component/s: Statistics
• Assignee: Xuefu Zhang
• Reporter: Xuefu Zhang
• Created: 13/May/14 03:43
• Updated: 13/Nov/14 19:39
• Resolved: 08/Jun/14 18:16

Description

After HIVE-6701, column stats for decimal columns can be computed. However, when the stats are fetched, nothing is returned. The problem was originally reproducible using thrift API. With the patch in HIVE-7050, the problem can be also produced using "desc formatted table column".

hive> desc formatted dec i;   
OK
# col_name            	data_type           	min                 	max                 	num_nulls           	distinct_count      	avg_col_len         	max_col_len         	num_trues           	num_falses          	comment             
	 	 	 	 	 	 	 	 	 	 
i                   	int                 	0                   	4                   	0                   	5                   	null                	null                	null                	null                	from deserializer   
hive> desc formatted dec d;
OK
# col_name            	data_type           	min                 	max                 	num_nulls           	distinct_count      	avg_col_len         	max_col_len         	num_trues           	num_falses          	comment             
	 	 	 	 	 	 	 	 	 	 
d                   	decimal(5,2)        	from deserializer