- hermes@laptano:~/work/c/rubycassa/lib$ irb -I .
- irb(main):001:0> require "cassandra/0.7"
- => true
- irb(main):002:0> @ks = Cassandra.new("Keyspace1","127.0.0.1:9160")
- => #<Cassandra:70177015802540, @keyspace="Keyspace1", @schema={}, @servers=["127.0.0.1:9160"]>
- irb(main):003:0> @ks.create_index("Keyspace1","Standard1","x","LongType")
- => "2462cbb7-0494-11e0-b5ff-e700f669bcfc"
- irb(main):004:0> @ks.drop_index("Keyspace1","Standard1","x")
- => "2ce85848-0494-11e0-b5ff-e700f669bcfc"
- irb(main):005:0> @ks.create_index("Keyspace1","Standard1","x","LongType")
- CassandraThrift::InvalidRequestException: CassandraThrift::InvalidRequestException
- from /home/hermes/work/c/rubycassa/lib/../vendor/0.7/gen-rb/cassandra.rb:472:in `recv_system_update_column_family'
- from /home/hermes/work/c/rubycassa/lib/../vendor/0.7/gen-rb/cassandra.rb:462:in `system_update_column_family'
- from /var/lib/gems/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:115:in `send'
- from /var/lib/gems/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:115:in `handled_proxy'
- from /var/lib/gems/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:57:in `system_update_column_family'
- from ./cassandra/0.7/cassandra.rb:104:in `update_column_family'
- from ./cassandra/0.7/cassandra.rb:121:in `create_index'
- from (irb):12
- from :0
- irb(main):006:0> @k.insert("Standard1","row1",{'x' => [0,10].pack("NN")})
- => nil
- irb(main):007:0> @k.insert("Standard1","row2",{'x' => [0,21].pack("NN")})
- => nil
- irb(main):008:0> @k.insert("Standard1","row3",{'x' => [0,27].pack("NN")})
- => nil
- irb(main):009:0> @k.insert("Standard1","row4",{'x' => [0,99].pack("NN")})
- => nil
- irb(main):010:0> idx_clause = CassandraThrift::IndexClause.new(
- irb(main):011:1* :start_key => '',
- irb(main):012:1* :expressions => [CassandraThrift::IndexExpression.new(
- irb(main):013:3* :column_name => "x",
- irb(main):014:3* :value => [0,21].pack("NN"),
- irb(main):015:3* :op => CassandraThrift::IndexOperator::EQ)])
- => <CassandraThrift::IndexClause expressions:[<CassandraThrift::IndexExpression column_name:78, op:EQ (0), value:0000000000000015>], start_key:, count:100>
- irb(main):016:0> @ks.get_indexed_rows("Standard1", idx_clause, CassandraThrift::ConsistencyLevel::ONE)
- => [<CassandraThrift::KeySlice key:726f7732, columns:[<CassandraThrift::ColumnOrSuperColumn column:<CassandraThrift::Column name:78, value:0000000000000015, timestamp:1292022275888422>>]>]