Skip to content

Instantly share code, notes, and snippets.

@OutOfBrain
Created March 14, 2018 15:02
Show Gist options
  • Save OutOfBrain/467965e6a336a96d21ceb9bcddb009ca to your computer and use it in GitHub Desktop.
Save OutOfBrain/467965e6a336a96d21ceb9bcddb009ca to your computer and use it in GitHub Desktop.
[3e26f1ec41a7:21000] > create table test(a int, b int, c int);
Query: create table test(a int, b int, c int)
Fetched 0 row(s) in 0.07s
[3e26f1ec41a7:21000] > insert into test values (1,2,3);
Query: insert into test values (1,2,3)
Query submitted at: 2018-03-14 15:01:11 (Coordinator: http://3e26f1ec41a7:25000)
select * from test;
alter table drop Query progress can be monitored at: http://3e26f1ec41a7:25000/query_plan?query_id=304d56cc61458a85:8dd41ef400000000
taModified 1 row(s) in 6.03s
[3e26f1ec41a7:21000] > select * from test;
Query: select * from test
Query submitted at: 2018-03-14 15:01:18 (Coordinator: http://3e26f1ec41a7:25000)
Query progress can be monitored at: http://3e26f1ec41a7:25000/query_plan?query_id=76414a12eca24532:c2c98ba400000000
+---+---+---+
| a | b | c |
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
Fetched 1 row(s) in 0.14s
[3e26f1ec41a7:21000] > alter table test drop column b;
Query: alter table test drop column b
Fetched 0 row(s) in 0.11s
[3e26f1ec41a7:21000] > select * from test;
Query: select * from test
Query submitted at: 2018-03-14 15:01:27 (Coordinator: http://3e26f1ec41a7:25000)
Query progress can be monitored at: http://3e26f1ec41a7:25000/query_plan?query_id=dc43b15dbe9947ce:54238b2400000000
+---+---+
| a | c |
+---+---+
| 1 | 2 |
+---+---+
Fetched 1 row(s) in 0.13s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment