[ 
https://issues.apache.org/jira/browse/CASSANDRA-8234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556978#comment-14556978
 ] 

Evan Chan commented on CASSANDRA-8234:
--------------------------------------

[~schumacr]  I would recommend integrating Spark HiveContext/HiveMetadata 
support into DSE, if it's not there already.  Then you tell the Oracle DBA:

1. Fire up DSE
2. Go to Spark/Hive shell, and type in COPY (SELECT * FROM ...) TO ....


> 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.x
>
>
> 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)

Reply via email to