Disabling Compression

Set the compression level to none to remove data compression from a table or partition.

Note:

Modifying a database's compression level, or enabling and disabling compression at table or partition level does not affect existing data; it affects only data you add or update after the change. However, changing whether a column is compressed or not performs a data copy, and therefore effects existing data.

Disable compression using :

alter table table_name
set compression = none

See the Reference Manual: Commands.

To set the compression to none for the sales table, use:

alter table sales
set compression = none

To disallow compression for the order_num column:

alter table sales
modify order_num int not compressed

To remove compression from the Y2008 and Y2009 partitions:

alter table sales_date
modify partition Y2008, Y2009 set compression = none