[
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)
