Re: Changing compression format of existing table from snappy to zlib

2018-03-14 Thread Gopal Vijayaraghavan
Hi, > Would this also ensure that all the existing data compressed in snappy format > and the new data stored in zlib format can work in tandem with no disruptions > or issues to end users who query the table. Yes. Each file encodes its own compressor kind & readers use that. The writers

Changing compression format of existing table from snappy to zlib

2018-03-14 Thread Gopi Krishnan
Hello, I have a Hive table with few a petabytes of data which is compressed in snappy format. This is a managed table in ORC format. Now I want to change the compression format of table to zlib from snappy. Can I use the alter table command to update the table properties? Would this also ensure