[ https://issues.apache.org/jira/browse/CASSANDRA-8234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14248756#comment-14248756 ]
Jon Haddad commented on CASSANDRA-8234: --------------------------------------- This is now solved pretty trivially with Spark. I've got a trivial example here: https://github.com/rustyrazorblade/learn-spark-cassandra/blob/master/src/main/scala/DataMigration.scala > CTAS for COPY > ------------- > > Key: CASSANDRA-8234 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8234 > Project: Cassandra > Issue Type: New Feature > Components: Tools > Reporter: Robin Schumacher > Fix For: 3.1 > > > Continuous request from users is the ability to do CREATE TABLE AS SELECT... > The COPY command can be enhanced to perform simple and customized copies of > existing tables to satisfy the need. > - Simple copy is COPY table a TO new table b. > - Custom copy can mimic Postgres: (e.g. COPY (SELECT * FROM country WHERE > country_name LIKE 'A%') TO …) -- This message was sent by Atlassian JIRA (v6.3.4#6332)