After Upgrade To CDH5.3/BDA4.1 Executing Alter Table Set Tblproperties in Impala Silently Fails (Doc ID 2007780.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.1.0 and later
Linux x86-64

Symptoms

After Upgrade to CDH5.3/BDA4.1 alter table set tblproperties is not working

a) Check table_stats of any table

show table stats log_arena_members_v1;
| 2015-04-24 | 340395 | 1 | 7.39MB | NOT CACHED | PARQUET | false |
| 2015-04-25 | 383304 | 1 | 8.20MB | NOT CACHED | PARQUET | true |
| 2015-04-26 | -1 | 1 | 8.39MB | NOT CACHED | PARQUET | false |
| 2015-04-27 | -1 | 1 | 6.35MB | NOT CACHED | PARQUET | false |
| 2015-04-28 | -1 | 1 | 5.80MB | NOT CACHED | PARQUET | false |
| Total | 383304 | 533 | 7.81GB | 0B | | |
+------------+---------+--------+---------+--------------+---------+-------------------+


b) Execute Alter table command

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms