cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Evans (JIRA)" <j...@apache.org>
Subject [jira] Created: (CASSANDRA-2027) term definitions
Date Fri, 21 Jan 2011 21:31:43 GMT
term definitions
----------------

                 Key: CASSANDRA-2027
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2027
             Project: Cassandra
          Issue Type: Sub-task
          Components: API
    Affects Versions: 0.8
            Reporter: Eric Evans
            Assignee: Eric Evans
            Priority: Minor
             Fix For: 0.8


h3. String

Anything between double-quotes.  Node-side this is just converted to bytes, so it could really
be used to represent *any* type so long as it is appropriately encoded.

Examples:

{code:style=SQL}
SELECT "name" FROM cf;
UPDATE cf SET "name" = "value" WHERE KEY = "key";
{code}

h3. UTF-8

A double-quoted string literal that is prefixed with a "u" to indicated that it should be
encoded to bytes using the utf-8 charset node-side.

Examples:

{code:style=SQL}
SELECT u"name" FROM cf;
UPDATE cf SET u"name" = u"value" WHERE KEY = "key";
{code}

h3. Integer

An undecorated numeric literal, converted to a 4-byte int node-side.

Examples:

{code:style=SQL}
SELECT 10..100 FROM cf WHERE KEY = "key";
UPDATE cf SET 1000 = "thousand", 100 = "hundred" WHERE KEY = "key";
{code}

h3. Long

A numeric literal suffixed with an "L", converted to an 8-byte long node-side.

Examples:

{code:style=SQL}
SELECT 10L..100L FROM cf WHERE KEY = "key";
UPDATE cf SET 1000L = "thousand", 100L = "hundred" WHERE KEY = "key";
{code}

h3. UUID

A string-formatted UUID supplied as an "argument" to a ctor/function formated string ({{uuid(<uuid
string>)}}).  Node-side this is converted back to the corresponding UUID.

Examples:

{code:style=SQL}
SELECT uuid(5f989e95-ae07-4425-b84a-6876ba106c66) FROM cf WHERE KEY = "key";
UPDATE cf SET uuid(5621b93d-d3a2-4d22-8a59-bdb93202b6cb)  = "username" WHERE KEY = "key";
{code}

h3. TimeUUID (UUID Type 1)

A string-formatted time-based UUID (type 1) supplied as an "argument" to a ctor/function formated
string ({{timeuuid(<uuid string>)}}).  Node-side this is converted back to the corresponding
UUID.  In addition to a string-formatted UUID, it should also be possible to supply dates
in a variety of formats which will result in a new UUID being created node-side.

Examples:

{code:style=SQL}
SELECT timeuuid(2011-01-01)..timeuuid(2010-01-21) FROM cf WHERE KEY = "key";
UPDATE cf SET timeuuid(now) = 1000L  WHERE KEY = "key";
{code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message