>From this, I assume I inserted the wrong number of values into the compound key from Astyanax. It would be nice to carry this error across to the CQL client.
-brian On Thu, Oct 4, 2012 at 3:17 PM, Brian O'Neill <b...@alumni.brown.edu> wrote: > Here you go... > > ERROR 14:57:37,270 Error occurred during processing of message. > java.lang.ArrayIndexOutOfBoundsException: 4 > at > org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:773) > at > org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:137) > at > org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:108) > at > org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:121) > at > org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1237) > at > org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3542) > at > org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3530) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34) > at > org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:680) > > > On Thu, Oct 4, 2012 at 3: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 > > > > -- > 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
