cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Shaw (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-2530) Additional AbstractType data type definitions to enrich CQL
Date Fri, 13 May 2011 16:50:47 GMT

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

Rick Shaw commented on CASSANDRA-2530:
--------------------------------------

The CQL mods now support declaring the following datatypes in CQL:

| date     | DateType |
| boolean  | BooleanType |
| float    | FloatType |
| double   | DoubleType |

So you can say: 

{code}
CREATE COLUMNFAMILY TestCF
 (KEY text PRIMARY KEY,
   stamp date,
   description text,
   hasAnAccount boolean,
   floating float,
   anumber varint) 
 WITH comparator = ascii 
  AND comment = 'Test CF' 
  AND default_validation = bigint
  AND memtable_flush_after_mins = 2
 ;


UPDATE TestCF USING CONSISTENCY ONE 
  SET
      description = 'Some Random Text',
      anumber = 3,
      stamp = '2011-01-13 04:30:01',
      hasAnAccount = true,
      floating = 150.234
  WHERE KEY = 2000;

{code} 

> Additional AbstractType data type definitions to enrich CQL
> -----------------------------------------------------------
>
>                 Key: CASSANDRA-2530
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2530
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>    Affects Versions: 0.8.0 beta 2
>            Reporter: Rick Shaw
>            Priority: Trivial
>              Labels: cql
>         Attachments: patch-to-add -5 -new-AbstractTypes-v2.txt, patch-to-add -5 -new-AbstractTypes-v3.txt,
patch-to-add -5 -new-AbstractTypes.txt, patch-to-add-4-new-AbstractTypes-and-CQL-support-v4.txt
>
>
> Provide 5 additional Datatypes: ByteType, DateType, BooleanType, FloatType, DoubleType.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message