Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Tue, 30 Sep 2014 22:14:34 +0000 (UTC)
From: "Robert Stupp (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12744151.1411683687000.159296.1412115274537@Atlassian.JIRA>
In-Reply-To: <JIRA.12744151.1411683687000@Atlassian.JIRA>
References: <JIRA.12744151.1411683687000@Atlassian.JIRA>
 <JIRA.12744151.1411683687474@arcas>
Subject: [jira] [Commented] (CASSANDRA-8005) Server-side DESCRIBE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Robert Stupp commented on CASSANDRA-8005:
-----------------------------------------

Especially backup tools should exactly know what they're doing - these need to inspect the schema tables anyway.
Dump & load might be a valid use-case for server-side DESC support - could work fine with that JSON style select and update (CASSANDRA-7970). But then there would be demand to provide an "UPSERT style CREATE TABLE" (just to apply the changes like added columns).

> Server-side DESCRIBE
> --------------------
>
>                 Key: CASSANDRA-8005
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8005
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: API
>            Reporter: Tyler Hobbs
>            Priority: Minor
>              Labels: cql3
>             Fix For: 3.0
>
>
> The various {{DESCRIBE}} commands are currently implemented by cqlsh, and nearly identical implementations exist in many drivers.  There are several motivations for making {{DESCRIBE}} part of the CQL language:
> * Eliminate the (fairly complex) duplicate implementations across drivers and cqlsh
> * Get closer to allowing drivers to not have to fetch the schema tables. (Minor changes to prepared statements are also needed.)
> * Have instantaneous support for new schema features in cqlsh.  (You currently have to update the bundled python driver.)
> * Support writing out schemas where it makes sense.  One good example of this is backups.  You need to restore the schema before restoring data in the case of total loss, so it makes sense to write out the schema alongside snapshots.


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