Compiles a hayt query into its raw string value

? can be used as a query value to mark a prepared statement value ex: (select :foo (where > :foo ?] [< :foo 2]))

Clause: takes a table identifier and a column type

Clause: sets ALLOW FILTERING on select queries, defaults to true is used without a value

Clause: takes a table identifier and a column type

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

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

Takes a keyspace identifier and a with clause.

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

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

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

Append/conjoin element to Map/Set/List

Aliases a column (selector) to another identifier (id)

Converts ascii to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

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

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

Converts bigint to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to ascii. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to bigint. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to boolean. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to counter. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to decimal. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to double. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to float. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to inet. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to int. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to text. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to timestamp. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to timeuuid. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to uuid. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to varchar. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts blob to varint. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts boolean to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Clause: Takes a map of columns definitions (keys are identifiers , values, types), to be used with create-table.

Clause: takes columns identifiers ex: (columns :foo “bar” :baz)

contains can be used as a query value to mark CONTAINS in where clause ex: (select :foo (where contains :foo ...]))

contains-key can be used as a query value to mark CONTAINS-KEY in where clause ex: (select :foo (where contains :foo ...]))

Returns a count(*) CQL function

Returns a count(1) CQL function

Clause: Sets COUNTER attribute on BATCH queries

Converts counter to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Calls supplied function by name, with the supplied args

handles namespaced identifiers

Allows to pass raw (assumed safe) content, no escaping will be applied.

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)

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

Takes a keyspace identifier and clauses: * with

Takes a table identifier and additional clause arguments:

• column-definitions
• with

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

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

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

Clause: Sets CUSTOM status on create-index query

DEPRECATED: USE to-date instead http://cassandra.apache.org/doc/cql3/CQL.html#usingtimeuuid

Returns a dateOf function with the supplied argument

Decrement counter by x, usable in values and set-columns

Converts decimal to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

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

Takes a table identifier and additional clause arguments:

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

Returns DISTINCT column id ex: (select :table (columns (distinct :foo)))

Converts double to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Clause: Takes a column Identifier

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

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

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

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

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

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

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

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

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

Takes a trigger identifier and a table identifier

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

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

Takes a user identifier * if-exists

Converts float to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Generates a frozen type definition, takes n arguments

Takes clauses: * resource * user

Clause: Apply only if the target exists

DEPRECATED use (if-exists false) Clause: Apply only if the row does not exist

in can be used as a query value to mark IN in where clause ex: (select :foo (where in :foo [1 2 3]))

Increment counter by x, usable in values and set-columns

Clause: Takes an index identifier

Converts inet to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

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

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

Converts int to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Clause: Sets LIMIT, takes a numeric value

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

Generates a list type definition, takes a single argument indicating the list elements type

Clause: Sets LOGGED/UNLOGGED attribute on BATCH queries

Generates a map type definition, takes 2 arguments, for key and value types

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

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

Returns a now() CQL function

Clause: takes a map or a vector of pairs (same as where) to compose the if clause of a update/delete query

Clause: takes a map or a vector of pairs (same as where) to compose the if clause of a update/delete query

Clause: takes vectors of 2 elements, where the first is the column identifier and the second is the ordering as keyword. ex: (order-by [:asc :desc])

Clause: To be used with alter-user and create-user, sets password

Clause: Sets permission to be listed with list-perm

Prepend element to List

Clause: takes hayt queries to be executed during a batch operation.

Clause: Sets recusivity on list-perm (LIST PERMISSION) queries

Clause: rename from old-name to new-name

Clause: Sets resource to be modified/used with grant or list-perm

Takes clauses: * resource * user

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

Clause: Takes a map of columns to be updated

Generates a set type definition, takes a single argument indicating the set elements type

Clause: To be used with alter-user and create-user, sets superuser status

Converts text to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts timestamp to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts timeuuid to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

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

Converts the timestamp/timeuuid argument into a date type

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

Converts the timestamp/timeuuid argument into a timestamp type

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

Converts the timestamp/timeuuid/date argument into a bigInt raw value

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

Returns a token function with the supplied argument

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

Takes a table identifier.

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

Returns a TTL function with the supplied argument

Generates a tuple type definition, takes n arguments

DEPRECATED: USE to-unix-timestamp instead http://cassandra.apache.org/doc/cql3/CQL.html#usingtimeuuid

Returns a unixTimestampOf function with the supplied argument

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

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

Takes a keyspace identifier

Clause: Sets user to be modified/used with grant or list-perm

Marks a map as User Data Type

Clause: Sets USING, takes keyword/value pairs for :timestamp and :ttl

Converts uuid to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Clause: Takes a map of columns to be inserted

Converts varchar to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Converts varint to blob. See https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#functions

Clause: takes a map or a vector of pairs to compose the where clause of a select/update/delete query

Same as where but for people who prefer unrolled args

backward compatible with hayt 1.0 and 2.0 betas

Clause: compiles to a CQL with clause (possibly nested maps)

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

Returns a WRITETIME function with the supplied argument