Skip to content

Instantly share code, notes, and snippets.

@OutOfBrain

OutOfBrain/gist:867f5812bb0ddf019a5fd77eea04deef

Created March 14, 2018 14:59
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save OutOfBrain/867f5812bb0ddf019a5fd77eea04deef to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save OutOfBrain/867f5812bb0ddf019a5fd77eea04deef to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
3e26f1ec41a7:21000] > create table test (a int, b int);
Query: create table test (a int, b int)
Fetched 0 row(s) in 0.77s
[3e26f1ec41a7:21000] > insert into test values (1,2), (3,4);
Query: insert into test values (1,2), (3,4)
Query submitted at: 2018-03-14 14:57:06 (Coordinator: http://3e26f1ec41a7:25000)
select * from test;
Query progress can be monitored at: http://3e26f1ec41a7:25000/query_plan?query_id=8f483cc1be99748d:be8e17e500000000
Modified 2 row(s) in 6.64s
[3e26f1ec41a7:21000] > select * from test;
Query: select * from test
Query submitted at: 2018-03-14 14:57:13 (Coordinator: http://3e26f1ec41a7:25000)
Query progress can be monitored at: http://3e26f1ec41a7:25000/query_plan?query_id=9d401919c0efcf9c:82e5eb4a00000000
+---+---+
| a | b |
+---+---+
| 1 | 2 |
| 3 | 4 |
+---+---+
Fetched 2 row(s) in 0.39s
[3e26f1ec41a7:21000] > alter table test drop column b;
Query: alter table test drop column b
Fetched 0 row(s) in 0.23s
[3e26f1ec41a7:21000] > alter table test add columns (c int);
Query: alter table test add columns (c int)
Fetched 0 row(s) in 0.11s
[3e26f1ec41a7:21000] > select * from test;
Query: select * from test
Query submitted at: 2018-03-14 14:58:15 (Coordinator: http://3e26f1ec41a7:25000)
Query progress can be monitored at: http://3e26f1ec41a7:25000/query_plan?query_id=a14717d4dcb1e06d:d4e9f14500000000
+---+---+
| a | c |
+---+---+
| 1 | 2 |
| 3 | 4 |
+---+---+
Fetched 2 row(s) in 0.13s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment