Cassandra two ways to log in Cassandra-cli/csqlsh

(1) cassandra-cli

The CASSADNRA-CLI command is discarded in cassandra2.2, and later login access Cassandra can be used Cqlsh

[Email protected] cassandra]$ cassandra-cli-h 172.16.101.59-p 9160

Connected to: "Mycluster" on 172.16.101.59/9160

Welcome to Cassandra CLI version 2.1.18

[[email protected]] Create keyspace Twissandra;

with placement_strategy = ' org.apache.cassandra.locator.SimpleStrategy '

and strategy_options = {replication_factor:1};

5200ec35-6f27-3f8f-a969-5f91b4308d40

[[email protected]] use Twissandra;

Authenticated to Keyspace:twissandra

[[email protected]] help create column family;

[[email protected]] Create column family users with comparator = Utf8type;

8eadec66-a110-32b4-b873-5bfaaac2ddf5

[[email protected]] Update column family users with

Column_metadata =

[

{Column_name:first, Validation_class:utf8type},

{column_name:last, Validation_class:utf8type},

{column_name:age, Validation_class:utf8type, Index_type:keys}

];

Ccdbe046-183a-307f-8e38-c1f44400f9fa

[[email protected]] Assume users keys as UTF8;

Assumption for column family ' users ' added successfully.

#插入数据

[[email protected]] set users[' jsmith ' [' First ']= ' John ';

[[email protected]] set users[' jsmith ' [' Last ']= ' Smith ';

[[email protected]] set users[' jsmith ' [' Age ']= ' 38 ';

#插入数据

[[email protected]] Get users[' jsmith '];

= = (Name=age, value=38, timestamp=1502764716526000)

= = (Name=first, Value=john, timestamp=1502764685559000)

= = (Name=last, Value=smith, timestamp=1502764696653000)

#修改数据值

[[email protected]] set users[' jsmith ' [' First ']= ' Jack ';

[[email protected]] Get users[' jsmith '];

= = (Name=age, value=38, timestamp=1502764716526000)

= = (Name=first, value=jack, timestamp=1502764821855000)

= = (Name=last, Value=smith, timestamp=1502764696653000)

[[email protected]] Get users where age= ' 38 ';

-------------------

Rowkey:jsmith

= = (Name=age, value=38, timestamp=1502764716526000)

= = (Name=first, value=jack, timestamp=1502764821855000)

= = (Name=last, Value=smith, timestamp=1502764696653000)

(2) Cqlsh

[Email protected] ~]$ Cqlsh-ucassandra-pcassandra localhost

#远程访问:

[Email protected] ~]$ Cqlsh 172.16.101.59

#查看版本

[Email protected]:system> show version;

[Cqlsh 5.0.1 | Cassandra 3.11.1 | CQL Spec 3.4.4 | Native Protocol V4]

[Email protected]:system> show host;

Connected to Test Cluster at 127.0.0.1:9042.

#system. Local table

[Email protected]:system> select key,cluster_name,listen_address from system.local;

Key | Cluster_Name | Listen_address

-------+--------------+-----------------

Local | Test Cluster | 192.168.163.102

#创建一个keyspace:

Cqlsh> Create Keyspace mykeyspace with replication = {' class ': ' Simplestrategy ', ' Replication_factor ': 1} and Durable_ Writes = TRUE;

#查看总共有哪些keyspace:

Cqlsh> desc keyspaces

System_traces Twissandra System Mykeyspace

#查看指定keyspace的详细信息:

Cqlsh> desc Mykeyspace

CREATE keyspace mykeyspace with replication = {' class ': ' Simplestrategy ', ' replication_factor ': ' 1 '} and durable_writes = True

#进入某个keyspace:

cqlsh> use Mykeyspace;

#创建一个users表:

Cqlsh:mykeyspace> CREATE TABLE users (user_id int primary key,fname text,lname text);

cqlsh:mykeyspace> desc tables;

Users

#查看users表信息:

cqlsh:mykeyspace> desc users;

CREATE TABLE Mykeyspace.users (

user_id int PRIMARY KEY,

fname text,

LName text

) with bloom_filter_fp_chance = 0.01

and caching = ' {' Keys ': ' All ', ' rows_per_partition ': ' NONE '} '

and comment = ' '

and compaction = {' class ': ' Org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy '}

and compression = {' sstable_compression ': ' Org.apache.cassandra.io.compress.LZ4Compressor '}

and dclocal_read_repair_chance = 0.1

and default_time_to_live = 0

and gc_grace_seconds = 864000

and Max_index_interval = 2048

and Memtable_flush_period_in_ms = 0

and min_index_interval = 128

and read_repair_chance = 0.0

and speculative_retry = ' 99.0PERCENTILE ';

#插入数据

cqlsh:mykeyspace> INSERT into users (User_id,fname,lname) values (1744, ' John ', ' Doe ');

cqlsh:mykeyspace> INSERT into users (User_id,fname,lname) values (1745, ' John ', ' Smith ');

cqlsh:mykeyspace> INSERT into users (User_id,fname,lname) values (1746, ' John ', ' Jack ');

Cqlsh:mykeyspace> select * from users;

user_id | fname | LName

---------+-------+-------

1745 | John | Smith

1744 |   John | Doe

1746 |  John | Jack

#创建索引:

Cqlsh:mykeyspace> CREATE index Users_lname_idx on users (lname);

Cqlsh:mykeyspace> SELECT * from users where lname= ' Smith ';

user_id | fname | LName

---------+-------+-------

1745 | John | Smith

Attention:

If the data created through CASSANDRA-CLI login is then viewed through the CLI, it may not be compatible:

cqlsh:mykeyspace> desc Twissandra;

CREATE keyspace Twissandra with replication = {' class ': ' Networktopologystrategy ', ' datacenter1 ': ' 1 '} and Durable_writes = true;

/*

Warning:table Twissandra.users omitted because it had constructs not compatible with CQL (was created via Legacy API). # warnings are issued here, incompatible

Approximate structure, for reference:

(This should is used to reproduce this schema)

CREATE TABLE Twissandra.users (

Key BLOB,

Column1 text,

Value Blob,

Age text,

First text,

Last text,

PRIMARY key (Key, Column1)

) with COMPACT STORAGE

and clustering ORDER by (Column1 ASC)

and caching = ' {' Keys ': ' All ', ' rows_per_partition ': ' NONE '} '

and comment = ' '

and compaction = {' class ': ' Org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy '}

and compression = {' sstable_compression ': ' Org.apache.cassandra.io.compress.LZ4Compressor '}

and dclocal_read_repair_chance = 0.1

and default_time_to_live = 0

and gc_grace_seconds = 864000

and Max_index_interval = 2048

and Memtable_flush_period_in_ms = 0

and min_index_interval = 128

and read_repair_chance = 0.0

and speculative_retry = ' NONE ';

CREATE INDEX Users_age_idx on twissandra.users (age);

*/

Cqlsh:mykeyspace> select * from Twissandra.users;

Key | Column1 | Value | Age | First | Last

----------------+---------+--------------+-------+-------+-------

0x6a736d697468 |       Age |    0x3338 |    38 |    38 | 38

0x6a736d697468 |   First |  0x4a61636b |  Jack |  Jack | Jack

0x6a736d697468 | Last | 0x536d697468 | Smith | Smith | Smith

This article is from the "Darren memos" blog, be sure to keep this source http://darrenmemos.blog.51cto.com/10979687/1980944

Cassandra two ways to log in Cassandra-cli/csqlsh