输入用户名和密码登录:
[root@node-112 bin]# ./cqlsh 192.168.0.112 -u csd
#输入密码:
password:csd#2014
#进入某个库:
csd@cqlsh:test>use XXX(keyspace)
#查看库中的表:
csd@cqlsh:test> desc tables;
#创建用户:
csd@cqlsh:test> create user csd_data_user with password '' nosuperuser;
#创建数据库:
csd@cqlsh:test>CREATE KEYSPACE tmp(keyspace,库名) WITH replication = {'class':'SimpleStrategy', 'replication_factor':3}
#创建表:
CREATE TABLE app_install_20150902
(
time_id bigint PRIMARY KEY,
device_id varchar,
package_name varchar,
app_name varchar,
app_version varchar,
app_channel varchar,
action_type int,
action_time bigint,
app_id bigint,
app_key varchar,
day bigint
)