qbits.hayt.dsl.statement

alter-column-family

deprecated in 1.5.0

alter-columnfamily

(alter-columnfamily columnfamily & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#alterTableStmt

Takes a columnfamiliy identifier and additional clause arguments:

  • alter-column
  • add-column
  • alter-column
  • rename-column
  • drop-column
  • with

alter-keyspace

(alter-keyspace keyspace & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#alterKeyspaceStmt

Takes a keyspace identifier and a with clause.

alter-table

(alter-table table & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#alterTableStmt

Takes a table identifier and additional clause arguments:

  • alter-column
  • add-column
  • alter-column
  • rename-column
  • drop-column
  • with

alter-type

(alter-type type & clauses)

alter-user

(alter-user user & clauses)

Takes clauses: * password * superuser (defaults to false)

batch

(batch & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#batchStmt

Takes hayt queries optional clauses: * queries * using * counter * logged

create-index

(create-index table name & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#createIndexStmt

Takes a table identifier and additional clause arguments:

  • index-column
  • index-name
  • custom
  • on (overwrites table id)

create-keyspace

(create-keyspace keyspace & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt

Takes a keyspace identifier and clauses: * with

create-table

(create-table table & clauses)

Takes a table identifier and additional clause arguments:

  • column-definitions
  • with

create-trigger

(create-trigger trigger table using)

create-type

(create-type type & clauses)

create-user

(create-user user & clauses)

Takes clauses: * password * superuser (defaults to false)

delete

(delete table & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#deleteStmt

Takes a table identifier and additional clause arguments:

  • columns (defaults to *)
  • using
  • where
  • only-if

drop-columnfamily

(drop-columnfamily cf & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#dropTableStmt

Takes a column family identifier and additional clauses: * if-exists

drop-index

(drop-index index & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#dropIndexStmt

Takes an index identifier and additional clauses: * if-exists

drop-keyspace

(drop-keyspace keyspace & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#dropKeyspaceStmt

Takes a keyspace identifier and additional clauses: * if-exists

drop-table

(drop-table table & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#dropTableStmt

Takes a table identifier and additional clauses: * if-exists

drop-trigger

(drop-trigger trigger table)

http://cassandra.apache.org/doc/cql3/CQL.html#dropTriggerStmt

Takes a trigger identifier and a table identifier

drop-type

(drop-type type & clauses)

http://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlRefDropType.html

Takes a type identifier and additional clauses: * if-exists

drop-user

(drop-user user & clauses)

Takes a user identifier * if-exists

grant

(grant perm & clauses)

Takes clauses: * resource * user

insert

(insert table & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#insertStmt

Takes a table identifier and additional clause arguments: * values * using * if-exists

list-perm

(list-perm & clauses)

Takes clauses: * perm (defaults to ALL if not supplied) * user * resource * recursive (defaults to true)

list-users

(list-users)

revoke

(revoke perm & clauses)

Takes clauses: * resource * user

select

(select table & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#selectStmt

Takes a table identifier and additional clause arguments:

  • columns (defaults to *)
  • where
  • order-by
  • limit
  • only-if

truncate

(truncate table)

update

(update table & clauses)

http://cassandra.apache.org/doc/cql3/CQL.html#updateStmt

Takes a table identifier and additional clause arguments:

  • using
  • set-columns
  • where
  • only-if
  • if-exists

use-keyspace

(use-keyspace keyspace)