cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-8234) CTAS (CREATE TABLE AS SELECT)
Date Thu, 06 Aug 2015 17:04:08 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-8234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jonathan Ellis updated CASSANDRA-8234:
--------------------------------------
    Description: 
Continuous request from users is the ability to do CREATE TABLE AS SELECT.  The simplest form
would be copying the entire table.  More advanced would allow specifying thes column and UDF
to call as well as filtering rows out in WHERE.

More advanced still would be to get all the way to allowing JOIN, for which we probably want
to integrate Spark.

  was:
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 …)

        Summary: CTAS (CREATE TABLE AS SELECT)  (was: CTAS for COPY)

> CTAS (CREATE TABLE AS SELECT)
> -----------------------------
>
>                 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 simplest
form would be copying the entire table.  More advanced would allow specifying thes column
and UDF to call as well as filtering rows out in WHERE.
> More advanced still would be to get all the way to allowing JOIN, for which we probably
want to integrate Spark.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message