bmz [ bmz_options ]

| lzo

| quicklz

| snappy

| zlib [ zlib_options ]

| none

bmz_options:

--fp-len int

| --offset int

zlib_options:

-9

| --best

| --normal

bloom_filter_spec:

rows [ bloom_filter_options ]

| rows+cols [ bloom_filter_options ]

| none

bloom_filter_options:

--false-positive float

--bits-per-item float

--num-hashes int

--max-approx-items int

DESCRIPTION

The ALTER TABLE command provides a way to alter a table by adding access groups and column families or

removing column families or renaming column families. See CREATE TABLE for a description of the column familyand access group options. Column families that are not explicitly included in an access group specification will go intothe "default" access group.

EXAMPLE

The following statements,

CREATE TABLE foo (

a MAX_VERSIONS=1,

b TTL=1 DAY,

c,

ACCESS GROUP primary BLOCKSIZE=1024 ( a ),

ACCESS GROUP secondary COMPRESSOR="zlib --best" ( b, c )

);

ALTER TABLE foo

ADD ( d MAX_VERSIONS=2 )

ADD ( ACCESS GROUP tertiary BLOOMFILTER="rows --false-positive 0.1" (d))

DROP ( c )

RENAME COLUMN FAMILY (a, e);

will produce the following output with SHOW CREATE TABLE foo;

CREATE TABLE foo (

e MAX_VERSIONS=1,

b TTL=86400,

d MAX_VERSIONS=2,

ACCESS GROUP primary BLOCKSIZE=1024 (e),

ACCESS GROUP secondary COMPRESSOR="zlib --best" (b),

ACCESS GROUP tertiary BLOOMFILTER="rows --false-positive 0.1" (d),

)

CREATE NAMESPACE

EBNF

CREATE NAMESPACE namespace_name;