[jira] [Commented] (CASSANDRA-7049) Rows with dynamic columns inserted via cassandra-cli are not shown via cqlsh

["Aleksey Yeschenko (JIRA)" <ji...@apache.org>]

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

Aleksey Yeschenko commented on CASSANDRA-7049:
----------------------------------------------

This actually is a legit issue, and doesn't have much to do with CLI itself, deprecated or not.

There is currently no way to access columns that aren't part of column_metadata (the dynamic part of 'mixed' Thrift column families), only the static part.

Except removing all the column_metadata entirely, so that it would become a dynamic column family. You'll probably want to change default_validation_class to BytesType then, too.

Then you'd be able to read all the data via CQL, treated as dense tables.

We'll have to find a way to do this in a better way, eventually, probably, but for now that's the only workaround.

> Rows with dynamic columns inserted via cassandra-cli are not shown via cqlsh
> ----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-7049
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7049
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Sergey Bushik
>              Labels: cassandra-cli, cqlsh
>
> {noformat}
> # use cli/thrift interface to create column family and insert 2 rows
> bin/cassandra-cli
> {noformat}
> {code}
> create keyspace test;
> use test;
> # create column family first
> create column family t1 with comparator = UTF8Type and key_validation_class = UTF8Type and default_validation_class=UTF8Type and column_metadata = [{column_name: column1, validation_class: UTF8Type}];  
> # insert few rows into t1 with dynamic columns
> set t1['1']['column2'] = 'value2';
> set t1['2']['column3'] = 'value3';
> # list rows
> list t1;
> -------------------
> RowKey: 2
> => (name=column3, value=value3, timestamp=1397717445436000)
> -------------------
> RowKey: 1
> => (name=column2, value=value2, timestamp=1397717447253000)
> 2 Rows Returned.
> {code}
> {noformat}
> # check that 2 rows are visible from cqlsh
> bin/cqlsh
> {noformat}
> {code}
> use test;
> select * from t1;
> (0 rows)
> {code}
> Expected result:
> Rows are show from CQL
> Actual result:
> No rows are displayed



--
This message was sent by Atlassian JIRA
(v6.2#6252)