Skip to main content

Posts

Showing posts from July, 2012

cassandra client sample

## Start Cassandra CLI ./cassandra-cli -h 127.0.0.1 ## Create, show and delete Cassandra keyspace create keyspace store with replication_factor=1 and placement_strategy='org.apache.cassandra.locator.SimpleStrategy'; ## Show Keyspaces show keyspaces; drop keyspace store; use store; ## Create a Cassandra column family create column family users with comparator = UTF8Type and    column_metadata = [{column_name: userName, validation_class:UTF8Type},                       {column_name: email, validation_class:UTF8Type}]; create column family products with comparator = UTF8Type and     column_metadata = [{column_name: skid, validation_class:UTF8Type},                       {column_name: inventory, validation_class:LongType}]; ## Out of the box Cassandra column metadata type ## BytesType ## UTF8Type ## LexicalUUIDType ## TimeUUIDType ...

cassandra create sample with cql

CREATE KEYSPACE demodb WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' AND strategy_options:replication_factor='1'; CREATE COLUMNFAMILY users (       user_name varchar PRIMARY KEY,       password varchar,       gender varchar,       session_token varchar,       state varchar,       birth_year bigint ); INSERT INTO users (user_name, password) VALUES ('ercan', '123456'); INSERT INTO users (user_name, password,state,new_col) VALUES ('can', '123123','gebze','test'); CREATE INDEX users_password ON users (password);

cassandra db single node installation

cd /home/ercan mkdir cassandra cd cassandra wget http://archive.apache.org/dist/cassandra/1.1.0/apache-cassandra-1.1.0-bin.tar.gz tar -xzvf apache-cassandra-1.1.0-bin.tar.gz mkdir lib mkdir log cd lib mkdir -p cassandra/data mkdir -p cassandra/commitlog mkdir -p cassandra/saved_caches sudo chown -R ercan:ercan /home/ercan/cassandra/lib/ sudo chown -R ercan:ercan /home/ercan/cassandra/log/ cd /home/ercan/cassandra/apache-cassandra-1.1.0/conf/ nano cassandra.yaml # change /var to /home/ercan nano cassandra.yaml # change /var to /home/ercan nano log4j-server.properties # change /var to /home/ercan cd /home/ercan/cassandra/apache-cassandra-1.1.0/bin ./cassandra

cassandra data type

Internal Type CQL Name Description BytesType blob Arbitrary hexadecimal bytes (no validation) AsciiType ascii US-ASCII character string UTF8Type text, varchar UTF-8 encoded string IntegerType varint Arbitrary-precision integer Int32Type int 4-byte integer LongType bigint 8-byte long UUIDType uuid Type 1 or type 4 UUID DateType timestamp Date plus time, encoded as 8 bytes since epoch BooleanType boolean true or false FloatType float 4-byte floating point DoubleType double 8-byte floating point DecimalType decimal Variable-precision decimal CounterColumnType counter Distributed counter value (8-byte long)