Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-3311

cqlsh: Error running "select *" vs "select all columns"

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 1.0.0
    • Component/s: Legacy/CQL
    • Labels:
      None
    • Environment:

      Server: BDP/main
      CQLSH: 1.0.5

    • Severity:
      Normal

      Description

      • Query using "select *"
        cqlsh> select * from users;
        Exception: 'utf8' codec can't decode byte 0xb4 in position 7: unexpected code byte
        
      • Query selecting all columns
         select KEY, password, gender, session_token, state, birth_year from users;
           KEY |  password | gender | session_token | state | birth_year |
         user1 | ch@ngem3a |      f |          None |    TX |       1968 |
        
      • Test Data
        CREATE KEYSPACE ks1 with 
          strategy_class =  
            'org.apache.cassandra.locator.SimpleStrategy' 
          and strategy_options:replication_factor=1;
          
        use ks1;
        
        CREATE COLUMNFAMILY users (
          KEY varchar PRIMARY KEY, password varchar, gender varchar,
          session_token varchar, state varchar, birth_year bigint);
          
        INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user1', 'ch@ngem3a', 'f', 'TX', '1968');    
        

        Attachments

          Activity

            People

            • Assignee:
              xedin Pavel Yaskevich
              Reporter:
              cdaw Cathy Daw
              Authors:
              Pavel Yaskevich
              Reviewers:
              Jonathan Ellis
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: