[IMPALA-1420] Can't update stats manually via alter table after upgrading to CDH 5.2

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Not A Bug
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.0.1
• Environment: Upgrading cluster from CDH 5.1.3 to CDH 5.2
• Assignee: Henry Robinson
• Reporter: Matthew Jacobs
• Created: 24/Oct/14 22:01
• Updated: 20/Dec/15 00:05
• Resolved: 30/Oct/14 19:48

Description

A few customers have reported that they can't update stats manually via alter table after upgrading to CDH 5.2.

From the user list:

After upgrading to Impala 2.0 my script that updates the stats after a new partition has been added, no longer works.

The bash script uses impala-shell to execute the following:

alter table queries partition(year="2014", month="10", day="21") set tblproperties ('numRows'='150304428');

I get no error after running this but when running
"show table stats table_name" i can see that the
partition #rows has a value of -1

+-------+-------+-----+-------------+--------+----------+--------------+---------+
| year  | month | day | #Rows       | #Files | Size     | Bytes Cached | Format  |
+-------+-------+-----+-------------+--------+----------+--------------+---------+
| 2014  | 10    | 21  | -1          | 29     | 6.51GB   | NOT CACHED   | PARQUET |