stax_query ()

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