Frends.CassandraDB.ExecuteQuery / 2.0.0

Summary

Runs a CQL statement against a keyspace and returns the rows along with any warnings the cluster raised. Connects to contact points rather than a single host, in the way Cassandra clients normally do.

Typical use — reading from or writing to Cassandra from a Process; the warnings are worth logging, as Cassandra uses them for expensive queries

Details

Frends version: 5.7 and newer
Agent: Crossplatform
Target framework: net8.0

Input parameters.

Name	Type	Default	Example	Description
AuthenticationMethods	`AuthenticationMethods`	`PlainTextAuthProvider`	`AuthenticationMethods.PlainTextAuthProvider`	Authentication method. Possible values: `None`: None. `PlainTextAuthProvider`: Plain-text authentication using username and password. NOTE: The PlainTextAuthProvider should only be used when authenticating against Apache Cassandra® clusters, not DSE `DsePlainTextAuthProvider`: SASL authentication using the PLAIN mechanism.
UseSsl	`Boolean`	`False`	`false`	Use Ssl.
X509CertificateFilePath	`String`	–	`c:\temp`	X509 certificate location.
X509CertificatePasswordSecret	`String`	–	`FooBar`	X509 certificate's password.
Username	`String`	–	`Foo`	Username.
Password	`String`	–	`Bar`	Password.
AsUser	`String`	–	`Foo2`	Connect with 'Input.Username' credentials, but will act as 'Input.AsUser'.
ContactPoints	`ContactPoint[]`	–	`Object{127.0.0.1}`	Contact point(s).
Port	`Int32`	`9042`	`9042`	Port.
Keyspace	`String`	–	`foo`	Keyspace (Case-sensitive).
Query	`String`	–	`SELECT bar FROM foo`	Query to execute.