SQL / DataFrame

Completed Queries (394)

Page:
ID Description Submitted ▴ Duration Job IDs
0
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:03:27 2 s
1
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:03:29 40 ms
2
SHOW TABLES IN `default` +details
2025/06/12 22:03:29 38 ms
3
SHOW TABLES IN `default` +details
2025/06/12 22:03:29 12 ms
4
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:03:30 35 ms
5
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:03:30 15 ms
6
SHOW TABLES IN `test` +details
2025/06/12 22:03:30 16 ms
7
SHOW TABLES IN `test` +details
2025/06/12 22:03:30 7 ms
8
SHOW TABLES IN `global_temp` +details
2025/06/12 22:03:30 1 ms
9
SHOW TABLES IN `global_temp` +details
2025/06/12 22:03:30 6 ms
10
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:03:47 72 ms
11
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:03:47 26 ms
12
select `city` from `default`.`airports` group by `city` order by `city` limit 3502 +details
2025/06/12 22:04:05 3 s [0][1]
13
select `code` from `default`.`airports` group by `code` order by `code` limit 501 +details
2025/06/12 22:04:17 0.3 s [2][3]
14
select SUM(`elev`) as `C1` from `default`.`airports` +details
2025/06/12 22:04:23 0.4 s [4][5]
15
select SUM(`lat`) as `C1`, SUM(`elev`) as `C2` from `default`.`airports` +details
2025/06/12 22:04:25 0.3 s [6][7]
16
select SUM(`elev`) as `C1`, SUM(`lat`) as `C2` from ( select `lat`, `elev` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` +details
2025/06/12 22:05:04 0.6 s [8][10]
17
select `city` from ( select `city` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` group by `city` order by `city` limit 3502 +details
2025/06/12 22:05:04 0.5 s [9][11]
18
select SUM(`elev`) as `C1` from ( select `elev` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` +details
2025/06/12 22:05:51 0.3 s [12][13]
19
select `name` from ( select `name` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` group by `name` order by `name` limit 501 +details
2025/06/12 22:05:59 0.3 s [14][15]
20
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:13:49 49 ms
21
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:13:49 7 ms
22
SHOW TABLES IN `default` +details
2025/06/12 22:13:50 24 ms
23
SHOW TABLES IN `default` +details
2025/06/12 22:13:50 5 ms
24
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:13:50 46 ms
25
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:13:50 5 ms
26
SHOW TABLES IN `test` +details
2025/06/12 22:13:50 18 ms
27
SHOW TABLES IN `test` +details
2025/06/12 22:13:50 4 ms
28
SHOW TABLES IN `global_temp` +details
2025/06/12 22:13:51 1 ms
29
SHOW TABLES IN `global_temp` +details
2025/06/12 22:13:51 3 ms
30
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:14:13 41 ms
31
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:14:13 5 ms
32
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:14:13 42 ms
33
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:14:14 5 ms
34
select `city` from `default`.`airports` group by `city` order by `city` limit 3502 +details
2025/06/12 22:14:27 0.4 s [16][17]
35
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:16:53 47 ms
36
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:16:53 5 ms
37
SHOW TABLES IN `default` +details
2025/06/12 22:16:53 22 ms
38
SHOW TABLES IN `default` +details
2025/06/12 22:16:53 5 ms
39
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:16:54 22 ms
40
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:16:54 4 ms
41
SHOW TABLES IN `test` +details
2025/06/12 22:16:54 10 ms
42
SHOW TABLES IN `test` +details
2025/06/12 22:16:54 3 ms
43
SHOW TABLES IN `global_temp` +details
2025/06/12 22:16:54 0 ms
44
SHOW TABLES IN `global_temp` +details
2025/06/12 22:16:55 4 ms
45
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:38:02 48 ms
46
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:38:02 4 ms
47
SHOW TABLES IN `default` +details
2025/06/12 22:38:03 47 ms
48
SHOW TABLES IN `default` +details
2025/06/12 22:38:03 5 ms
49
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:38:03 20 ms
50
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:38:03 4 ms
51
SHOW TABLES IN `test` +details
2025/06/12 22:38:04 11 ms
52
SHOW TABLES IN `test` +details
2025/06/12 22:38:04 3 ms
53
SHOW TABLES IN `global_temp` +details
2025/06/12 22:38:04 1 ms
54
SHOW TABLES IN `global_temp` +details
2025/06/12 22:38:04 3 ms
55
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:38:21 0.1 s
56
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:38:21 4 ms
57
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:38:22 36 ms
58
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:38:22 5 ms
59
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:38:22 36 ms
60
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:38:22 5 ms
61
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:38:23 30 ms
62
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:38:23 4 ms
63
select `city` from `default`.`airports` group by `city` order by `city` limit 3502 +details
2025/06/12 22:38:41 0.3 s [18][19]
64
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:52:15 46 ms
65
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:52:15 4 ms
66
SHOW TABLES IN `default` +details
2025/06/12 22:52:16 17 ms
67
SHOW TABLES IN `default` +details
2025/06/12 22:52:16 4 ms
68
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:52:16 16 ms
69
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:52:16 3 ms
70
SHOW TABLES IN `test` +details
2025/06/12 22:52:16 14 ms
71
SHOW TABLES IN `test` +details
2025/06/12 22:52:16 3 ms
72
SHOW TABLES IN `global_temp` +details
2025/06/12 22:52:17 0 ms
73
SHOW TABLES IN `global_temp` +details
2025/06/12 22:52:17 6 ms
74
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:52:27 38 ms
75
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:52:27 4 ms
76
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:52:27 32 ms
77
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:52:27 5 ms
78
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:53:01 20 ms
79
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:53:01 4 ms
80
SHOW TABLES IN `default` +details
2025/06/12 22:53:02 40 ms
81
SHOW TABLES IN `default` +details
2025/06/12 22:53:02 4 ms
82
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:53:02 16 ms
83
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:53:02 3 ms
84
SHOW TABLES IN `test` +details
2025/06/12 22:53:02 9 ms
85
SHOW TABLES IN `test` +details
2025/06/12 22:53:02 2 ms
86
SHOW TABLES IN `global_temp` +details
2025/06/12 22:53:03 0 ms
87
SHOW TABLES IN `global_temp` +details
2025/06/12 22:53:03 3 ms
88
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:53:10 90 ms
89
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:53:10 62 ms
90
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:53:10 4 ms
91
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:53:10 5 ms
92
select `BOOLEAN` from ( select `BOOLEAN`, `C1`, case when `C1` is not null then cast(`C1` as INTEGER) else CAST(0 as INTEGER) end as `C2`, case when `C1` is null then CAST(0 as INTEGER) else CAST(1 as INTEGER) end as `C3` from ( select `BOOLEAN`, `BOOLEAN` as `C1` from `default`.`alltypes` ) as `ITBL` group by `BOOLEAN`, `C1` ) as `ITBL` order by `ITBL`.`C2`, `ITBL`.`C3` limit 501 +details
2025/06/12 22:53:18 0.6 s [20][21]
93
select `city` from `default`.`airports` group by `city` order by `city` limit 3502 +details
2025/06/12 22:53:25 0.3 s [22][23]
94
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:58:21 56 ms
95
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:58:21 6 ms
96
SHOW TABLES IN `default` +details
2025/06/12 22:58:21 18 ms
97
SHOW TABLES IN `default` +details
2025/06/12 22:58:21 3 ms
98
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:58:22 38 ms
99
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:58:22 4 ms
Page: