Cassandra
  1. Cassandra
  2. CASSANDRA-7049

Rows with dynamic columns inserted via cassandra-cli are not shown via cqlsh

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Fix Version/s: None
    • Component/s: Core

      Description

      # use cli/thrift interface to create column family and insert 2 rows
      bin/cassandra-cli
      
      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.
      
      # check that 2 rows are visible from cqlsh
      bin/cqlsh
      
      use test;
      select * from t1;
      (0 rows)
      

      Expected result:
      Rows are show from CQL
      Actual result:
      No rows are displayed

        Activity

        Sergey Bushik created issue -
        Sergey Bushik made changes -
        Field Original Value New Value
        Description # use cli/thrift interface
        bin/cassandra-cli
        {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}

        # check rows are visible from cqlsh
        bin/cqlsh
        {code}
        use test;
        select * from t1;
        (0 rows)
        {code}
        {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
        {noformat}
        bin/cqlsh
        {code}
        use test;
        select * from t1;
        (0 rows)
        {code}

        Expected result:
        Rows are show from CQL
        Actual result:
        No rows are displayed
        Sergey Bushik made changes -
        Description {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
        {noformat}
        bin/cqlsh
        {code}
        use test;
        select * from t1;
        (0 rows)
        {code}

        Expected result:
        Rows are show from CQL
        Actual result:
        No rows are displayed
        {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
        Mikhail Stepura made changes -
        Fix Version/s 2.0.6 [ 12326170 ]
        Michael Shuler made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Won't Fix [ 2 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Sergey Bushik
          • Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development