The upcoming Materialized View feature should accomplish this. See: https://issues.apache.org/jira/browse/CASSANDRA-6477
Maybe it's a question of whether your are doing a one-time migration of data to a new table, or in fact you want to maintain and update views of a base table that will be updated. In any case, it is not yet clear when exactly this new feature will be available. But it would be nice to hear confirmation of whether it would suit your needs. -- Jack Krupansky On Wed, May 20, 2015 at 1:53 AM, Jonathan Haddad <[email protected]> wrote: > Here's a simple example I did a little while ago that might be helpful: > https://github.com/rustyrazorblade/spark-data-migration > > On Tue, May 19, 2015 at 10:53 PM Jonathan Haddad <[email protected]> > wrote: > >> It's not built into Cassandra. You'll probably want to take a look at >> Apache Spark & the DataStax connector. >> >> https://github.com/datastax/spark-cassandra-connector >> >> Jon >> >> On Tue, May 19, 2015 at 10:29 PM amit tewari <[email protected]> >> wrote: >> >>> Hi >>> >>> We would like to have the ability of being able to create new tables >>> from existing tables (on the fly), but with with a new/different partition >>> key. >>> >>> Can this be done from CQL? >>> >>> Thanks >>> Amit >>> >>
