Description:
Query a Cassandra database and return the query result as a table sequence.
Syntax:
stax_query (staxClient, cql, [arg1], [arg2], ...)
Note:
The CassandraCli external library function (See External Library Guide) performs the query cql over a Cassandra database and returns the query result as a table sequence. The parameter staxClient is the database connection.
Parameter:
|
staxClient |
Database connection handle. |
|
cql |
The query statement. |
|
args |
Parameter values; can be omitted. |
Return value:
Table sequence
Example:
|
|
A |
|
|
1 |
=stax_open("127.0.0.1":9042, "mycasdb","cassandra":"cassandra") |
Create a Cassandra database connection. |
|
2 |
=stax_query(A1,"select * from user where id=?",1) |
Execute query over the Cassandra database. |
|
3 |
=stax_close(A1) |
|