Creating and using the cqlshrc file
The cqlshrc file passes default configuration information to cqlsh.
The cqlshrc file can pass default configuration information to cqlsh. Use the cqlshrc file to configure SSL encryption instead of overriding the SSL_CERTFILE environmental variables repeatedly. To help you create this file, Apache Cassandra™ includes a cqlshrc.sample file. Copy this file to the hidden .cassandra directory in your user home folder and rename it to cqlshrc.
Options for cqlshrc
You configure the cqlshrc file by setting these options in the following sections:
[authentication] options
- username
- Authenticate as user.
- password
- Authenticate using password.
- keyspace
- Use the given keyspace. Equivalent to issuing a USE keyspace command immediately after starting cqlsh.
[ui] options
- color
- Always use color output.
- datetimeformat
- Configure the format of timestamps using Python strftime syntax and reading them with COPY.
- float_precision
- Sets the number of digits displayed after the decimal point.Note: Increasing this to large numbers can result in unusual values.
- completekey
- Set the key for automatic completion of a cqlsh shell entry. Default is the tab key.
[connection] option (Cassandra 2.1.1+)
- hostname
- The host for the cqlsh connection.
- port
- The connection port. Default:
9042
(native protocol). - timeout
- Configures timeout in seconds for opening new connections.
- request_timeout
- Configures the request timeout in seconds for executing queries. Set to the number of seconds of inactivity.
[csv] option (Cassandra 2.0.15+, 2.1.5+)
- field_size_limit
- Configures the cqlsh field size. Set to a particular field size. For instance, field_size_limit (1000000000).
[ssl] options
- certfile
- The path to the cassandra certificate. See Using cqlsh with SSL encryption in the Cassandra documentation.
- validate
- Optional. Default:
true
. - userkey
- Must be provided when
require_client_auth=true
in cassandra.yaml. - usercert
- Must be provided when
require_client_auth=true
in cassandra.yaml.
Overrides default certfiles
in [ssl] section.
Common COPY TO and COPY FROM options
Also see the Common COPY options for TO and FROM table.
- nullval
- The string placeholder for null values.
- header
- For COPY TO, controls whether the first line in the CSV output file contains the column names.
- decimalsep
- Set a separator for decimal values.
- thousandssep
- Set a separator for thousands digit groups. Default: empty string.
- boolstyle
- Set a representation for boolean values for True and False. The values are case insensitive. Example: yes,no or 1,0.
- numprocesses
- Set the number of worker processes. Maximum value is 16.
- maxattempts
- Set the maximum number of attempts for errors.
- reportfrequency
- Set the frequency with which status is displayed, in seconds.
- ratefile
- Specify a file for printing output statistics.
Also see the COPY TO table.
- maxrequests
- Set the maximum number of requests each worker process can work on in parallel.
- pagesize
- Set the page size for fetching results.
- pagetimeout
- Set the page timeout for fetching results.
- begintoken
- Set the minimum token string for exporting data.
- endtoken
- Set the maximum token string for exporting data.
- Set the maximum size of the output file, measured in number of lines. If a value is set, the output file will be split into segment when the value is exceeded. "-1" sets no maximum.
- encoding
- Set the COPY TO command to output unicode strings.
Also see the COPY FROM table.
- ingestrate
- Set an approximate ingest rate in rows per second. Must be set to a greater value than chunk size.
- errfile
- Set a file to store all rows that are not imported. If no value is set, the information is stored in import_ks_table.err where <ks> is the keyspace and <table> is the table name.
Also see the COPY table.