CREATE TABLE test(i INTEGER, j TIMESTAMP TIME INDEX);

Affected Rows: 0

DESC TABLE test;

+--------+----------------------+-----+------+---------+---------------+
| Column | Type                 | Key | Null | Default | Semantic Type |
+--------+----------------------+-----+------+---------+---------------+
| i      | Int32                |     | YES  |         | FIELD         |
| j      | TimestampMillisecond | PRI | NO   |         | TIMESTAMP     |
+--------+----------------------+-----+------+---------+---------------+

INSERT INTO test VALUES (1, 1), (2, 2);

Affected Rows: 2

ALTER TABLE test ADD COLUMN k INTEGER;

Affected Rows: 0

SELECT * FROM test;

+---+-------------------------+---+
| i | j                       | k |
+---+-------------------------+---+
| 1 | 1970-01-01T00:00:00.001 |   |
| 2 | 1970-01-01T00:00:00.002 |   |
+---+-------------------------+---+

DESC TABLE test;

+--------+----------------------+-----+------+---------+---------------+
| Column | Type                 | Key | Null | Default | Semantic Type |
+--------+----------------------+-----+------+---------+---------------+
| i      | Int32                |     | YES  |         | FIELD         |
| j      | TimestampMillisecond | PRI | NO   |         | TIMESTAMP     |
| k      | Int32                |     | YES  |         | FIELD         |
+--------+----------------------+-----+------+---------+---------------+

ALTER TABLE test ADD COLUMN host STRING PRIMARY KEY;

Affected Rows: 0

SELECT * FROM test;

+---+-------------------------+---+------+
| i | j                       | k | host |
+---+-------------------------+---+------+
| 1 | 1970-01-01T00:00:00.001 |   |      |
| 2 | 1970-01-01T00:00:00.002 |   |      |
+---+-------------------------+---+------+

DESC TABLE test;

+--------+----------------------+-----+------+---------+---------------+
| Column | Type                 | Key | Null | Default | Semantic Type |
+--------+----------------------+-----+------+---------+---------------+
| i      | Int32                |     | YES  |         | FIELD         |
| j      | TimestampMillisecond | PRI | NO   |         | TIMESTAMP     |
| k      | Int32                |     | YES  |         | FIELD         |
| host   | String               | PRI | YES  |         | TAG           |
+--------+----------------------+-----+------+---------+---------------+

ALTER TABLE test ADD COLUMN idc STRING default 'idc' PRIMARY KEY;

Affected Rows: 0

SELECT * FROM test;

+---+-------------------------+---+------+-----+
| i | j                       | k | host | idc |
+---+-------------------------+---+------+-----+
| 1 | 1970-01-01T00:00:00.001 |   |      | idc |
| 2 | 1970-01-01T00:00:00.002 |   |      | idc |
+---+-------------------------+---+------+-----+

DESC TABLE test;

+--------+----------------------+-----+------+---------+---------------+
| Column | Type                 | Key | Null | Default | Semantic Type |
+--------+----------------------+-----+------+---------+---------------+
| i      | Int32                |     | YES  |         | FIELD         |
| j      | TimestampMillisecond | PRI | NO   |         | TIMESTAMP     |
| k      | Int32                |     | YES  |         | FIELD         |
| host   | String               | PRI | YES  |         | TAG           |
| idc    | String               | PRI | YES  | idc     | TAG           |
+--------+----------------------+-----+------+---------+---------------+

ALTER TABLE test ADD COLUMN "IdC" STRING default 'idc' PRIMARY KEY;

Affected Rows: 0

DESC TABLE test;

+--------+----------------------+-----+------+---------+---------------+
| Column | Type                 | Key | Null | Default | Semantic Type |
+--------+----------------------+-----+------+---------+---------------+
| i      | Int32                |     | YES  |         | FIELD         |
| j      | TimestampMillisecond | PRI | NO   |         | TIMESTAMP     |
| k      | Int32                |     | YES  |         | FIELD         |
| host   | String               | PRI | YES  |         | TAG           |
| idc    | String               | PRI | YES  | idc     | TAG           |
| IdC    | String               | PRI | YES  | idc     | TAG           |
+--------+----------------------+-----+------+---------+---------------+

DROP TABLE test;

Affected Rows: 0