Here you go... // ---------------------------------------------------------------- // IN CQLSH // ---------------------------------------------------------------- CREATE KEYSPACE cirrus WITH strategy_class = 'NetworkTopologyStrategy' AND strategy_options:datacenter1 = '1';
use cirrus; CREATE TABLE data ( uid varchar, t timestamp, foo varchar, bar varchar, PRIMARY KEY (uid, t, foo) ); // ---------------------------------------------------------------- // Then in CLI // ---------------------------------------------------------------- use cirrus; set data['PI7JC8KRF6']['1349110576']='2014-07-31'; list data; // Note, I intentially didn't supply a value for "foo" in the primary key definition. // Listing works. // ---------------------------------------------------------------- // Then in CLI // ---------------------------------------------------------------- select * from data; // The result is... cqlsh:cirrus> select * from data; TSocket read 0 bytes On Thu, Oct 4, 2012 at 3:31 PM, Brian O'Neill <b...@alumni.brown.edu> wrote: > 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 -- Brian ONeill Lead Architect, Health Market Science (http://healthmarketscience.com) mobile:215.588.6024 blog: http://brianoneill.blogspot.com/ twitter: @boneill42
