Obfuscated slightly.... The table is something simliar to:
CREATE TABLE data ( uid varchar, t timestamp, foo varchar, bar varchar, PRIMARY KEY (uid, t, foo, bar) ); Then I can insert just fine via Astyanax and I can see the row via cli, but the select statement fails in cqlsh. The table is fine, when I only interact with it through CQL. I can insert and select fine, until I insert a row from Asytanax. If needed, I can probably create a small test for this that I can share. -brian On Thu, Oct 4, 2012 at 3:08 PM, Jonathan Ellis <[email protected]> wrote: > What kind of data did you insert, and what was expected? Expected > behavior would be to reject nonconforming data at insert time. > > On Thu, Oct 4, 2012 at 2:04 PM, Brian O'Neill <[email protected]> wrote: >> This is probably already on your radar, but we could use a better >> error message from cqlsh when the column key doesn't conform to the >> expected schema... >> >> I accidentally inserted data using Astyanax that didn't conform to the >> schema. After that, selects from that table via cqlsh return no >> useful information. >> (CLI shows the data just fine) >> >> >> bone@boneill-macbook-wired:~/tools/cassandra-> bin/cassandra-cli >> Connected to: "Test Cluster" on 127.0.0.1/9160 >> Welcome to Cassandra CLI version 1.1.5 >> >> Type 'help;' or '?' for help. >> Type 'quit;' or 'exit;' to quit. >> >> [default@unknown] use cirrus; >> Authenticated to keyspace: cirrus >> [default@cirrus] list data; >> Using default limit of 100 >> Using default column limit of 100 >> ------------------- >> RowKey: PI7JC8 >> => (column=*****, value=2014-07-31, timestamp=1349376866686000) >> ------------------- >> RowKey: PI1234 >> => (column=*****, value=Y, timestamp=1349372660453000) >> >> 2 Rows Returned. >> Elapsed time: 212 msec(s). >> [default@cirrus] quit; >> bone@boneill-macbook-wired:~/tools/cassandra-> bin/cqlsh -3 >> Connected to Test Cluster at localhost:9160. >> [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 3.0.0 | Thrift protocol 19.32.0] >> Use HELP for help. >> cqlsh> use cirrus; >> cqlsh:cirrus> select * from data; >> TSocket read 0 bytes >> cqlsh:cirrus> >> >> -- >> Brian ONeill >> Lead Architect, Health Market Science (http://healthmarketscience.com) >> mobile:215.588.6024 >> blog: http://brianoneill.blogspot.com/ >> twitter: @boneill42 > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com -- Brian ONeill Lead Architect, Health Market Science (http://healthmarketscience.com) mobile:215.588.6024 blog: http://brianoneill.blogspot.com/ twitter: @boneill42
