Cassandra Datastax Ruby插入错误

Question

我有一个问题插入查询在红宝石与卡桑德拉，

这是我的表：

CREATE TABLE testkeyspace.ticket (
    id int,
    uid text,
    annule boolean,
    avoir decimal,
    caisse int,
    clotureid int,
    couverts decimal,
    creation_iso timestamp,
    modif_iso timestamp,
    montantencaisse decimal,
    montantttc decimal,
    nb_articles int,
    numero int,
    remise decimal,
    remise_montant decimal,
    remise_type text,
    remise_valeur decimal,
    rendu decimal,
    stats_iso timestamp,
    PRIMARY KEY (id, uid)
) 

在ruby中，我做了一个prepare语句:

insert_table_ticket = session.prepare("INSERT INTO ticket(id, uid, annule, avoir, caisse, clotureid, couverts,creation_iso, modif_iso, montantencaisse, montantttc, nb_articles, numero, remise,remise_montant, remise_type, remise_valeur, rendu,stats_iso) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)")

我把这些值用于测试：

session.execute(insert_table_ticket,
                      1,
                      "test",
                      true,
                      1.1,
                      1,
                      1,
                      1.0,
                      1415350203,
                      1415350203,
                      1.1,
                      1.1,
                      1,
                      1,
                      1.1,
                      1.1,
                      "tests",
                      1.1,
                      1.1,
                      1415350203
      )

我得到了这个错误：

/home/florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/cql _ byte _ buffer . Rb:275:in < code > to _ s ':来自/home/florian/的参数数目错误(1对0) (ArgumentError)。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/cql _ byte _ buffer . Rb:275:in append _ decimal ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/type _ converter . Rb:287:in < code > decimal _ to _ bytes ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/type _ converter . Rb:85:in 调用' from /home/florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/type _ converter . Rb:85:in < code > to _ bytes ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/requests/execute _ request . Rb:93:in encode _ values ' from/home/Florian/中的块。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/requests/execute _ request . Rb:92:in < code > each ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/requests/execute _ request . Rb:92:in each _ with _ index ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/requests/execute _ request . Rb:92:in < code > encode _ values ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/protocol/requests/execute _ request . Rb:39:in initialize ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/cluster/client . Rb:190:in < code > new ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/cluster/client . Rb:190:in execute ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/session . Rb:81:in < code > execute _ async ' from/home/Florian/。rvm/gems/ruby-2 . 1 . 4/gems/Cassandra-driver-1 . 0 . 0 . RC . 1/lib/Cassandra/session . Rb:103:in execute ' from/home/Florian/Projects/Hadoop-ticket-server/import _ Cassandra . Rb:60:in < code >块(3层)in

你知道我的问题吗？谢谢你

Answer 1

问题是浮点数。

float中的Ruby在cassandra中被解释为double或float。要在cassandra中输入decimal，我们必须在Ruby中输入BigDecimal。

来源：“http://datastax.github.io/ruby-driver/features/basics/"

解决方案：

session.execute(insert_table_ticket,
                  1,
                  "test",
                  true,
                  BigDecimal.new('1.1'),
                  1,
                  1,
                  BigDecimal.new('1.0'),
                  1415350203,
                  1415350203,
                  BigDecimal.new('1.1'),
                  BigDecimal.new('1.1'),
                  1,
                  1,
                  BigDecimal.new('1.1'),
                  BigDecimal.new('1.1'),
                  "tests",
                  BigDecimal.new('1.1'),
                  BigDecimal.new('1.1'),
                  1415350203
  )