cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-12423) Cells missing from compact storage table after upgrading from 2.1.9 to 3.7
Date Mon, 22 Aug 2016 13:50:20 GMT

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

Aleksey Yeschenko commented on CASSANDRA-12423:
-----------------------------------------------

Looked into it more, together with Stefania. To sum it up, in no particular order:

1. {{DESCRIBE}} output is broken. Sparse compact tables (with regular columns defined) that
have non-text comparators should be filtered out from {{DESCRIBE}} output, as they cannot
currently be represented via CQL {{CREATE TABLE}}. [~aholmber] I've raised this issue privately,
do you remember if there is a python-driver JIRA open for it already? (also for filtering
out supers). [~ifesdjeen] same goes for a follow-up JIRA to CASSANDRA-7190

2. The column names for {{Keyspace1.Standard3}} in schema tables in 2.1 and 3.0 are both correct.
Should be using {{BytesType}} for regulars in 2.1 (statics in 3.0) given the {{BytesType}}
comparator.

3. Yup, you are pretty much right about {{ColumnIdentifier.getInterned()}} being relied on
incorrectly. We should fix this in 2.1 and upwards. I'll open a separate JIRA (assign to you,
if you don't mind it), and link to this one, to either make the type part of the key in the
interned map, or just limit its use.

> Cells missing from compact storage table after upgrading from 2.1.9 to 3.7
> --------------------------------------------------------------------------
>
>                 Key: CASSANDRA-12423
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12423
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Tomasz Grabiec
>            Assignee: Stefania
>         Attachments: 12423.tar.gz
>
>
> Schema:
> {code}
> create table ks1.test ( id int, c1 text, c2 text, v int, primary key (id, c1, c2)) with
compact storage and compression = {'sstable_compression': ''};
> {code}
> sstable2json before upgrading:
> {code}
> [
> {"key": "1",
>  "cells": [["","0",1470761440040513],
>            ["a","asd",2470761440040513,"t",1470764842],
>            ["asd:","0",1470761451368658],
>            ["asd:asd","0",1470761449416613]]}
> ]
> {code}
> Query result with 2.1.9:
> {code}
> cqlsh> select * from ks1.test;
>  id | c1  | c2   | v
> ----+-----+------+---
>   1 |     | null | 0
>   1 | asd |      | 0
>   1 | asd |  asd | 0
> (3 rows)
> {code}
> Query result with 3.7:
> {code}
> cqlsh> select * from ks1.test;
>  id | 6331 | 6332 | v
> ----+------+------+---
>   1 |      | null | 0
> (1 rows)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message