Database Reference
In-Depth Information
Cassandra is a column-family-oriented database. Column family, as the name sug-
gests is “family of columns.” Each row in Cassandra may contain one or more
columns. A column is the smallest unit of data containing a name, value, and time
stamp (see
Figure 2-1
)
.
Figure 2-1
.
Cassandra column definition
By default Cassandra distribution comes with cqlsh and Cassandra-cli command
line clients to manipulate.
Cassandra-cli
and
cqlsh
(
.sh
and
.bat
) are available un-
der
bin
folder. Running these command line clients over Linux, Windows, or Mac is
fairly easy. Running shell files over Linux and Mac box requires simply running
cql.sh
. However running cqlsh over Windows would require Python to be installed.
To install cqlsh on Windows, follow these steps:
1.
First, download Python from
https://www.python.org/ftp/
2.
Add
python.exe
to
PATH
under environment variable
3.
Run
setup.py
, available under
$CASSANDRA_HOME/pylib
dir-
ectory:
python setup.py install
4.
python cqlsh
Figure 2-2
.
successfully connected to cql shell