Repository: cassandra Updated Branches: refs/heads/cassandra-3.0 0663ebbd7 -> 11bddad51
Add entries for all options to cqlsh.sample Patch by Tyler Hobbs; reviewed by Lorina Poland for CASSANDRA-10622 Project: http://git-wip-us.apache.org/repos/asf/cassandra/repo Commit: http://git-wip-us.apache.org/repos/asf/cassandra/commit/26aa19e5 Tree: http://git-wip-us.apache.org/repos/asf/cassandra/tree/26aa19e5 Diff: http://git-wip-us.apache.org/repos/asf/cassandra/diff/26aa19e5 Branch: refs/heads/cassandra-3.0 Commit: 26aa19e583529a9f80018779249e426fd9054d7f Parents: 165f586 Author: Tyler Hobbs <[email protected]> Authored: Fri Feb 5 16:33:19 2016 -0600 Committer: Tyler Hobbs <[email protected]> Committed: Fri Feb 5 16:33:19 2016 -0600 ---------------------------------------------------------------------- conf/cqlshrc.sample | 199 ++++++++++++++++++++++++++++++++++++++++------- 1 file changed, 172 insertions(+), 27 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cassandra/blob/26aa19e5/conf/cqlshrc.sample ---------------------------------------------------------------------- diff --git a/conf/cqlshrc.sample b/conf/cqlshrc.sample index fb3f3af..5a33a2f 100644 --- a/conf/cqlshrc.sample +++ b/conf/cqlshrc.sample @@ -18,51 +18,196 @@ ; Sample ~/.cqlshrc file. [authentication] -username = fred -password = !!bang!!$ +;; If Cassandra has auth enabled, fill out these options +; username = fred +; password = !!bang!!$ +; keyspace = ks1 + + [ui] -color = on -completekey = tab +;; Whether or not to display query results with colors +; color = on + +;; Used for displaying timestamps (and reading them with COPY) +; datetimeformat = %Y-%m-%d %H:%M:%S%z + +;; The number of digits displayed after the decimal point +;; (note that increasing this to large numbers can result in unusual values) +; float_precision = 5 + +;; Used for automatic completion and suggestions +; completekey = tab + + [cql] -version = 3.2.1 +;; A version of CQL to use (this should almost never be set) +; version = 3.2.1 + + [connection] + +;; The host to connect to hostname = 127.0.0.1 + +;; The port to connect to (9042 is the native protocol default) port = 9042 +;; A timeout in seconds for opening new connections +; timeout = 10 + +;; A timeout in seconds for executing queries +; request_timeout = 10 + + + +[csv] +;; The size limit for parsed fields +; field_size_limit = 131072 + + + [tracing] -max_trace_wait = 10.0 +;; The max number of seconds to wait for a trace to complete +; max_trace_wait = 10.0 + + ;[ssl] -;certfile = ~/keys/cassandra.cert -;; optional - true by default. +; certfile = ~/keys/cassandra.cert + +;; Optional - true by default. ;validate = true -;; to be provided when require_client_auth=true + +;; To be provided when require_client_auth=true ;userkey = ~/key.pem -;; to be provided when require_client_auth=true + +;; To be provided when require_client_auth=true ;usercert = ~/cert.pem -;; optional section, overrides default certfile in [ssl] section, if present -;[certfiles] -;192.168.1.3 = ~/keys/cassandra01.cert -;192.168.1.4 = ~/keys/cassandra02.cert -; vim: set ft=dosini : +;; Optional section, overrides default certfile in [ssl] section, if present +; [certfiles] +; 192.168.1.3 = ~/keys/cassandra01.cert +; 192.168.1.4 = ~/keys/cassandra02.cert + + + +;; Options that are common to both COPY TO and COPY FROM +; [copy] + +;; The string placeholder for null values +; nullval = null + +;; For COPY TO, controls whether the first line in the CSV output file will +;; contain the column names. For COPY FROM, specifies whether the first +;; line in the CSV file contains column names. +; header = false + +;; The character that is used as the decimal point separator +; decimalsep = . + +;; The character that is used to separate thousands +;; (defaults to the empty string) +; thousandssep = + +;; The string literal format for boolean values +; boolstyle = True,False + +;; The number of child worker processes to create for +;; COPY tasks. Defaults to a max of 4 for COPY FROM and 16 +;; for COPY TO. However, at most (num_cores - 1) processes +;; will be created. +; numprocesses = + +;; The maximum number of failed attempts to fetch a range of data (when using +;; COPY TO) or insert a chunk of data (when using COPY FROM) before giving up +; maxattempts = 5 + +;; How often status updates are refreshed, in seconds +; reportfrequency = 0.25 + +;; An optional file to output rate statistics to +; ratefile = + + + +;; Options specific to COPY TO +; [copy-to] + +;; The maximum number token ranges to fetch simultaneously +; maxrequests = 6 + +;; The number of rows to fetch in a single page +; pagesize = 1000 + +;; By default the page timeout is 10 seconds per 1000 entries +;; in the page size or 10 seconds if pagesize is smaller +; pagetimeout = 10 + +;; Token range to export. Defaults to exporting the full ring. +; begintoken = +; endtoken = + +; The maximum size of the output file measured in number of lines; +; beyond this maximum the output file will be split into segments. +; -1 means unlimited. +; maxoutputsize = -1 + +;; The encoding used for characters +; encoding = utf8 + + + +;; Options specific to COPY FROM +; [copy-from] + +;; The maximum number of rows to process per second +; ingestrate = 100000 + +;; The maximum number of rows to import (-1 means unlimited) +; maxrows = -1 + +;; A number of initial rows to skip +; skiprows = 0 + +;; A comma-separated list of column names to ignore +; skipcols = + +;; The maximum global number of parsing errors to ignore, -1 means unlimited +; maxparseerrors = -1 + +;; The maximum global number of insert errors to ignore, -1 means unlimited +; maxinserterrors = -1 + +;; A file to store all rows that could not be imported, by default this is +;; import_<ks>_<table>.err where <ks> is your keyspace and <table> is your table name. +; errfile = + +;; The min and max number of rows inserted in a single batch +; maxbatchsize = 20 +; minbatchsize = 2 + +;; The number of rows that are passed to child worker processes from +;; the main process at a time +; chunksize = 1000 + + + +;; The options for COPY can also be specified per-table. The following +;; three sections demonstrate this. -;; optional options for COPY TO and COPY FROM -;[copy] -;maxattempts=10 -;numprocesses=4 +;; Optional table-specific options for COPY +; [copy:mykeyspace.mytable] +; chunksize = 1000 -;; optional options for COPY FROM -;[copy-from] -;chunksize=5000 -;ingestrate=50000 +;; Optional table-specific options for COPY FROM +; [copy-from:mykeyspace.mytable] +; ingestrate = 20000 -;; optional options for COPY TO -;[copy-to] -;pagesize=2000 -;pagetimeout=20 +;; Optional table-specific options for COPY TO +; [copy-to:mykeyspace.mytable] +; pagetimeout = 30
