Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1420

Can't update stats manually via alter table after upgrading to CDH 5.2

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Not A Bug
    • Affects Version/s: Impala 2.0
    • Fix Version/s: Impala 2.0.1
    • Component/s: None
    • Labels:
      None
    • Environment:
      Upgrading cluster from CDH 5.1.3 to CDH 5.2

      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 |
      

        Attachments

          Activity

            People

            • Assignee:
              henryr Henry Robinson
              Reporter:
              mjacobs Matthew Jacobs
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: