config.yaml

#
# Copyright (C) 2015-2017, Zhichun Wu
#
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.
#

# JDBC driver version
version: ${version}
# general configuration
locale : en_US

# the configuration below for the driver is pretty much same as the following connection url:
# jdbc:c*:datastax://localhost:-1/system_auth?user=cassandra&password=cassandra&quiet=true&sqlFriendly=true&...
driver :
  # DataStax Java driver as primary, and possiblly astyanax for Cassandra 2.0.x later
  provider : datastax
  # comma separated hosts(port is optional there and only the first one will be considered)
  hosts : localhost
  # non-positive port implies the default port will be used in the provider, which is datastax in this case
  port : -1
  # by default everyone has access to system_auth keyspace
  keyspace : system_auth
  user : cassandra
  password : cassandra

  # be quiet for unsupported JDBC features
  quiet : true
  # this enables SQL parser, which tries to translate SQL into equivalent CQL(s) - think about MDX to SQL
  sqlFriendly : true
  # if you turn tracing read/write requests on, you'll see more logs(DEBUG level) in backend on how it goes
  # more on https://docs.datastax.com/en/cql/3.3/cql/cql_reference/tracing_r.html
  tracing : false

  readConsistencyLevel : &CL LOCAL_ONE
  # you may use ANY for better write performance, if hinted handoff is not going to be an issue in your case
  # also please be aware of that counter table does not support ANY at the moment
  writeConsistencyLevel : *CL
  consistencyLevel : *CL

  # LOGGED or UNLOGGED, you may set COUNTER in magic comments
  batch : UNLOGGED
  # parsing SQL / CQL is not free hence we cache what we did before
  cqlCacheSize : 1000
  # set 0 to let the provider the decide what's the best
  fetchSize : 100
  # append "LIMIT 10000" to all queries by default, set 0 to disable this
  rowLimit : 10000
  readTimeout : 30 # in seconds
  connectionTimeout : 5 # in seconds
  keepAlive : true
  compression : LZ4 # NONE, LZ4 or SNAPPY

# logging configuration for tinylog(http://www.tinylog.org/configuration)
logger :
  level : INFO
  stacktrace : -1
  format : "{date:yyyy-MM-dd HH:mm:ss} [{thread}] {class_name}.{method}({line}) {level}: {message}"