Cassandra
  1. Cassandra
  2. CASSANDRA-5628

cqlsh "copy to" fails when there are more than 21 columns

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Not A Problem
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      Description

      See the cqlsh script below. If you comment out the "c1" line then the "copy to" command exports 0 rows even though the "select *" works fine!

      USE test_keyspace;

      DROP TABLE foo;

      CREATE TABLE foo (
      id varchar PRIMARY KEY,
      a0 varchar,
      a1 varchar,
      a2 varchar,
      a3 varchar,
      a4 varchar,
      a5 varchar,
      a6 varchar,
      a7 varchar,
      a8 varchar,
      a9 varchar,
      b0 varchar,
      b1 varchar,
      b2 varchar,
      b3 varchar,
      b4 varchar,
      b5 varchar,
      b6 varchar,
      b7 varchar,
      b8 varchar,
      b9 varchar,
      c0 varchar,
      – c1 varchar, – uncomment this line and the "copy" will fail even though the "select" works fine!
      );

      insert into foo (id, a1) values ('foo', 'grum');

      select * from foo;

      copy foo to '/tmp/foo.csv';

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        2d 3h 24m 1 Jonathan Ellis 12/Jun/13 15:38
        Jonathan Ellis made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Not A Problem [ 8 ]
        Hide
        Jonathan Ellis added a comment -

        Noted.

        Show
        Jonathan Ellis added a comment - Noted.
        Hide
        Ian Rogers added a comment -

        Tested with this version and it worked fine (tested with 50 columns)

        $ cqlsh --version
        cqlsh 3.0.2
        $ nodetool -h localhost version
        ReleaseVersion: 1.2.5

        But we can't upgrade from 1.1.* to 1.2 due to the incompatible changes in cql etc. unfortunately.

        Show
        Ian Rogers added a comment - Tested with this version and it worked fine (tested with 50 columns) $ cqlsh --version cqlsh 3.0.2 $ nodetool -h localhost version ReleaseVersion: 1.2.5 But we can't upgrade from 1.1.* to 1.2 due to the incompatible changes in cql etc. unfortunately.
        Hide
        Jonathan Ellis added a comment -

        Does this affect 1.2 as well?

        Show
        Jonathan Ellis added a comment - Does this affect 1.2 as well?
        Ian Rogers made changes -
        Environment ubuntu 13.04
        $ uname -a
        Linux ian 3.8.0-23-generic #34-Ubuntu SMP Wed May 29 20:22:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
        $ cqlsh --version
        cqlsh 2.2.0
        $ nodetool -h localhost version
        ReleaseVersion: 1.1.12
        ubuntu 13.04
        $ uname -a
        Linux ian 3.8.0-23-generic #34-Ubuntu SMP Wed May 29 20:22:58 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
        $ cqlsh --version
        cqlsh 2.2.0
        $ nodetool -h localhost version
        ReleaseVersion: 1.1.12
        $ dpkg -l python-cql
        1.4.0-1 DB-API 2.0 compliant client library for Cassandra/CQL

        Ian Rogers made changes -
        Field Original Value New Value
        Summary cqlsh "copy to" fails when there are more than 22 columns cqlsh "copy to" fails when there are more than 21 columns
        Ian Rogers created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Ian Rogers
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development