cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4779) Boolean type of composite column of compound primary key converted into UTF8Type
Date Tue, 09 Oct 2012 14:05:03 GMT

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

Jonathan Ellis commented on CASSANDRA-4779:
-------------------------------------------

Neither, it will be CompositeType.

If you absolutely must mess with CQL definitions from (non-CQL) Thrift, Brian O'Neill has
blogged an example: http://brianoneill.blogspot.com/2012/10/cql-astyanax-and-compoundcomposite-keys.html
                
> Boolean type of composite column of compound primary key converted into UTF8Type
> --------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-4779
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4779
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.5
>            Reporter: Vivek Mishra
>
> Steps to reproduce:
> 1) connect to cqlsh --cql3
> 2) create keyspace testcomp;
> 3) CREATE TABLE altercations (
>        instigator text,
>        started_at timestamp,
>        ships_destroyed int,
>        energy_used float,
>        alliance_involvement boolean,
>        PRIMARY KEY (instigator,started_at,ships_destroyed)
> 4) INSERT INTO altercations (instigator, started_at, ships_destroyed,
>                              energy_used, alliance_involvement)
>                      VALUES ('Jayne Cobb', '2012-07-24', 2, 4.6, 'false');
> 5) select * from altercations; gives output:
>  instigator | started_at               | ships_destroyed | alliance_involvement | energy_used
> ------------+--------------------------+-----------------+----------------------+-------------
>  Jayne Cobb | 2012-07-23 00:00:00+0000 |               2 |                False |   
     4.6
> But when try to connect via cassandra-cli and execute:
>  
> 6)list altercations; (output gives an error as below):
> Using default limit of 100
> Using default column limit of 100
> -------------------
> RowKey: Jayne Cobb
> => (column=2012-07-23 00:00:00+0530:2:alliance_involvement, value=, timestamp=1349772570037000)
> invalid UTF8 bytes 40933333
> gives me  {invalid UTF8 bytes 40933333} 
> Keyspace description:
> Keyspace: testcomp:
>   Replication Strategy: org.apache.cassandra.locator.NetworkTopologyStrategy
>   Durable Writes: true
>     Options: [datacenter1:1]
>   Column Families:
>     ColumnFamily: altercations
>       Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>       Default column value validator: org.apache.cassandra.db.marshal.UTF8Type
>       Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.DateType,org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type)
>       GC grace seconds: 864000
>       Compaction min/max thresholds: 4/32
>       Read repair chance: 0.1
>       DC Local Read repair chance: 0.0
>       Replicate on write: true
>       Caching: KEYS_ONLY
>       Bloom Filter FP chance: default
>       Built indexes: []
>       Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>       Compression Options:
>         sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor
> Issue: 
> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.DateType,org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type)
> Although alliance_involvement is of "boolean" data type! which is causing this issue.
> Looks like an issue with CompositeType creation, somehow boolean is also treated as UTF8Type.

--
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