Perfect. Tnx. On Thu, Oct 4, 2012 at 3:37 PM, Jonathan Ellis <jbel...@gmail.com> wrote: > Oh, I see. I misunderstood at first. Yes, the thrift side in 1.1 > doesn't validate cql3 composites. This should be fixed in 1.2 beta1; > see > https://issues.apache.org/jira/browse/CASSANDRA-4377?focusedCommentId=13436817&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13436817 > > On Thu, Oct 4, 2012 at 2: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 > > > > -- > 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
