[
https://issues.apache.org/jira/browse/CASSANDRA-8234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345246#comment-14345246
]
Brian Hess commented on CASSANDRA-8234:
----------------------------------------
It would also be useful to be able to do:
INSERT INTO foo(x, y, z) SELECT a, b, c FROM bar;
That is, you already have a table set up and want to INSERT into it. This is
sort of under the covers of CTAS (step 1: create the table; step 2: insert the
data into it).
> 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)
