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

        Ian Rogers created issue -
        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 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

        Jonathan Ellis made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Not A Problem [ 8 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development