I was able to reproduce with CLI. I'll send over the example as soon as I can obfuscate it.
-brian On Thu, Oct 4, 2012 at 3:19 PM, Jonathan Ellis <jbel...@gmail.com> wrote: > Nothing jumps out at me, varchar should be pretty straightforward. > Probably going to need a test case. (Even better if you can repro w/ > cli instead of needing Astyanax.) > > On Thu, Oct 4, 2012 at 2:15 PM, Brian O'Neill <b...@alumni.brown.edu> wrote: >> 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 <jbel...@gmail.com> 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 <b...@alumni.brown.edu> 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 > > > > -- > 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
