Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

  1. Click List under Cassandra Keyspaces and select a keyspace to add column families to.
  2. Click Add a New Column Family to open the New Column Family window where you can enter column family details to the keyspace.
    Image RemovedImage Added

    The fields of the new column family window are described below:

    Default validator for row keys and column data
    FieldsDescription
    Name*Column Family (CF) Name is mandatory. Must not contain the character "-".
    CommentDescription of the column family.

    Used to attach additional human-readable information about the column family to its definition

    Column Type
    • Standard -Column Family
    • Super -
    ComparatorDatatype.
    Key Cache Size

    Specifies the number of keys per ssTable whose locations in memory are kept in "mostly LRU" order (Only the key locations; not any column values). Specify a fraction (value less than 1) or an absolute number of keys to cache. Defaults to 200000 keys.

    Row Cache SizeSpecifies the number of rows whose entire content is cached in memory. Not recommended to be used on Column Families with large rows or high write:read ratio. Specify a fraction (value less than 1) or an absolute number of rows to cache. The default is 0 meaning row caching is OFF by default.
    Row Cache Save Period In SecondsNumber of seconds between saving row caches. The row caches can be saved periodically. If one exists on start-up, it will be loaded.
    Garbage Collection Grace In SecondsSpecifies the time to wait before garbage collecting tombstones (deletion markers). Defaults to 864000 (10 days). Refer to http://wiki.apache.org/cassandra/DistributedDeletes.
    Minimum Compaction ThresholdThe minimum number of SSTables needed to start a minor compaction. Increasing this value causes minor compactions to start less frequently and be more intensive. Setting this to 0 disables minor compactions. The default value is 4.
    Maximum Compaction ThresholdSpecifies the maximum number of SSTables allowed before a minor compaction is forced. Decreasing this value causes minor compactions to start more frequently and be less intensive. Setting this to 0 disables minor compactions. The default value is 32.
    Default Validation Class
    • Column Family
    Key Validation ClassDatatype of Row keys
    ComparatorDatatype of Column keys
    Default Validation ClassDefault datatype of Column values
  3. Click Save after adding column family details. The Keyspace Information window opens with links to column family operations such as share with user rolesSet Permissions, edit or delete.
    Image RemovedImage Added
  4. Click on the Column the Column Family's name and then the Add New Index/Non-Index Column link to create a  to create an indexed or non-indexed column.Image Removed

    Image Added

    FieldDescriptionRequired/Optional
    NameName of the new columnRequired
    Index NameIndex NameRequired (only in case of an index column)
    Validation ClassDatatype of column valueRequired

    There are 2 ways of defining a column. 

    Validation Class

    1) Create a (non-indexed) column with a Validation class: Do not specify any values for 'Index Name'.

    2) Create an indexed column with a Validation class: Specify a name for the Index in 'Index Name'.