| Revision | Date | Author | Comments |
|---|---|---|---|
| 1.0 | 2016-03-31 | Affan Salman | Created initial structure and added “SERVER OPTIONS” |
While defining a foreign Cassandra SERVER, you can provide OPTIONS
pertaining to connection configuration.
You can do so by adding comma-separated key-value pairs to the OPTIONS
clause of the CREATE SERVER command.
The following simple example shows the key host with the value ‘127.0.0.1’:
CREATE SERVER cass_serv FOREIGN DATA WRAPPER cstar_fdw
OPTIONS (host '127.0.0.1');The full list of the supported SERVER parameters is:
| Parameter Name | Required? |
|---|---|
| host | Y |
| port | N |
| protocol | N |
The details for each of these parameters follow:
The address(es) or hostname(s) of the Cassandra server(s).
- Example values: ‘127.0.0.1’, ‘127.0.0.1,127.0.0.2’, ‘server1.domain.com’
- Default value: N/A (mandatory parameter)
The port number of the Cassandra server(s).
- Example value: 9042
- Default value: 9042
The protocol version to use for connecting with the Cassandra server.
- Example value: ‘4’
- Default value: ‘4’ (for cpp-driver version 2.3)