cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijay (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5576) CREATE/DROP TRIGGER in CQL
Date Tue, 11 Jun 2013 05:40:23 GMT

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

Vijay commented on CASSANDRA-5576:
----------------------------------

It took longer than expected to troubleshoot CFMetaData, 
https://github.com/Vijay2win/cassandra/commits/5576-v2 has the following semantics...

{code}
cqlsh> create TRIGGER test2 ON "Keyspace1"."Standard1" using 'org.apache.cassandra.triggers.InvertedIndex';
cqlsh> SELECT * FROM system.schema_triggers WHERE keyspace_name='Keyspace1' AND column_family='Standard1';

 keyspace_name | column_family | trigger_classes
---------------+---------------+------------------------------------------------------
     Keyspace1 |     Standard1 | {test2: org.apache.cassandra.triggers.InvertedIndex}

cqlsh> drop trigger test2 on "Keyspace1"."Standard1";                           
{code}

The trigger data is now stored in schema_triggers and cli is as follows
{code}
update column family Standard1 with triggers= '{"test":"org.apache.cassandra.triggers.InvertedIndex"}';
{code}
                
> CREATE/DROP TRIGGER in CQL
> --------------------------
>
>                 Key: CASSANDRA-5576
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5576
>             Project: Cassandra
>          Issue Type: Bug
>          Components: API, Core
>            Reporter: Jonathan Ellis
>            Assignee: Vijay
>             Fix For: 2.0
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message