cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cathy Daw (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-3311) cqlsh: Error running "select *" vs "select all columns"
Date Tue, 04 Oct 2011 21:09:34 GMT
cqlsh: Error running "select *" vs "select all columns"
-------------------------------------------------------

                 Key: CASSANDRA-3311
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3311
             Project: Cassandra
          Issue Type: Bug
         Environment: Server: BDP/main
CQLSH: 1.0.5
            Reporter: Cathy Daw


* Install cql 1.0.5 from [http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/downloads/detail?name=cql-1.0.5.tar.gz&can=2&q=]

* Query using "select *"
{code}
cqlsh> select * from users;
Exception: 'utf8' codec can't decode byte 0xb4 in position 7: unexpected code byte
{code}

* Query selecting all columns
{code}
 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 |
{code}

* Test Data
{code}
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');    
{code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message