connect and insert into Cassandra using perl

Question

I want to know how to connect to Cassandra using Perl, and insert, select, update etc.

I tried this

my $dbh = DBI->connect(
    "dbi:Cassandra:host=localhost;keyspace=nomkeyspace",
    "root",
    '',
    { RaiseError => 1 }
);

my $rows = $dbh->selectall_arratref( "SELECT id, nom" );

for my $row ( @$rows ) {
    print( "ok" );
}

$dbh->do( "insert into resultat (ip, nom) values (?,?)" );

$dbh->disconnect;

but it's give me this error

Can't locate DBD/Cassandra.pm in @INC (you may need to install the DBD::Cassandra module)

thanks

it said " Can't locate DBD/Cassandra.pm in @INC (you may need to install the DBD::Cassandra module) " , — Ussopokingo, Jun 08 '17 at 14:09
no, but I have doubt more about this code , if it can really do the task — Ussopokingo, Jun 08 '17 at 14:11

score 1 · Accepted Answer · answered Jun 08 '17 at 14:11

1

You have to install the reqired perl module DBD::Cassandra

You can do this with perl -MCPAN -e install "DBD::Cassandra"

answered Jun 08 '17 at 14:11

Jens

67,715
15
98
113

nothing happen when i lunch this cmd line, and the error stays the same – Ussopokingo Jun 08 '17 at 14:18
@KhaledAssandi You are working on Windows, mac or Linux? – Jens Jun 08 '17 at 14:19
@KhaledAssandi I can not belive that *nothing* happens if you enter the command there must be some output – Jens Jun 08 '17 at 14:20
im working in Linux (ubuntu) , yes nothing i don't know why , if the module is already installed, so why it give me the error message – Ussopokingo Jun 08 '17 at 14:24
1

`perl -MCPAN -e install "DBD::Cassandra"` is generally written `cpan DBD::Cassandra` – Borodin Jun 08 '17 at 17:42
Thanks for you all – Ussopokingo Oct 24 '18 at 12:06

connect and insert into Cassandra using perl

1 Answers1