Thanks DuyHai !! We were also thinking to do it the "Spark" way but I was not sure that its would be so simple :) We have a compact storage cf with each row having some data in staticly defined columns while other data in dynamic columns. Is the approach mentioned in link adaptable to the scenario where we want to migrate the existing data to a Non-Compact CF with static columns and collections ?
Thanks Anuj -------------------------------------------- On Tue, 2/2/16, DuyHai Doan <doanduy...@gmail.com> wrote: Subject: Re: Moving Away from Compact Storage To: user@cassandra.apache.org Date: Tuesday, 2 February, 2016, 12:57 AM Use Apache Spark to parallelize the data migration. Look at this piece of code https://github.com/doanduyhai/Cassandra-Spark-Demo/blob/master/src/main/scala/usecases/MigrateAlbumsData.scala#L58-L60 If your source and target tables have the SAME structure (except for the COMPACT STORAGE clause), migration with Spark is a 2 lines of code On Mon, Feb 1, 2016 at 8:14 PM, Anuj Wadehra <anujw_2...@yahoo.co.in> wrote: Hi Whats the fastest and reliable way to migrate data from a Compact Storage table to Non-Compact storage table? I was not able to find any command for dropping the compact storage directive..so I think migrating data is the only way...any suggestions? ThanksAnuj
