-m address of job manager which to connect -d detached mode -yd yarn detached mode -ynm yarn application name -yn number of yarn container to allocate = Number of Task Managers -ys Number of slots per TaskManager -yjm Memory for JobManager Container with optional unit (default: MB) -ytm Memory per TaskManager Container with optional unit (default: MB) -p The parallelism with which to run the program. -c class to run
CREATE ROLE IF NOT EXISTS 'root' WITH SUPERUSER = true AND LOGIN = false; CREATE ROLE IF NOT EXISTS 'root' WITH SUPERUSER = true AND PASSWORD = 'root';
修改权限
1 2 3 4 5
ALTER ROLE role_name [WITH [PASSWORD = 'password'] [LOGIN = true | false] [SUPERUSER = true | false] [OPTIONS = map_literal]]
示例
1
ALTER ROLE root WITH PASSWORD = 'NewPassword';
Key Space
查询
1 2
# 列出所有 keysapces desc keyspaces;
创建
1 2 3 4 5 6 7
CREATE KEYSPACE [IF NOTEXISTS] keyspace_name WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : N } |'class' : 'NetworkTopologyStrategy', 'dc1_name' : N [, ...] } [AND DURABLE_WRITES =true|false] ;
示例
1 2 3 4
CREATE KEYSPACE IF NOTEXISTS "trace" WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'vg' : 2 }
Table
查询
1
desc <keyspace-name>;
1 2
use <keyspace-name>; desc tables;
创建
1 2 3 4 5 6 7
CREATE TABLE [IF NOT EXISTS] [keyspace_name.]table_name ( column_definition [, ...] PRIMARY KEY (column_name [, column_name ...]) [WITH table_options | CLUSTERING ORDER BY (clustering_column_name order]) | ID = 'table_hash_tag' | COMPACT STORAGE]