Description:
Query a Cassandra database and return the query result as a table sequence.
Syntax:
stax_query (staxClient, cql, [arg1], [arg2], ...)
Note:
The function performs the query cql over a Cassandra database and returns the query result as a table sequence. The parameter staxClient is the database connection.
Parameters:
staxClient |
Database connection handle |
cql |
The query statement |
args |
Parameter values; can be omitted |
Return value:
A table sequence
Example:
|
A |
|
1 |
=stax_connect("127.0.0.1";keyspace:"mycas") |
Create a Cassandra database connection |
2 |
=stax_query(A3,"select * from mycas.user where id=?",1) |
Execute query over the Cassandra database |