SQL / DataFrame

Completed Queries (394)

Page:
ID Description ▾ Submitted Duration Job IDs
114
set -v +details
2025/06/12 23:04:00 42 ms
115
set -v +details
2025/06/12 23:04:00 14 ms
126
set -v +details
2025/06/12 23:07:00 23 ms
127
set -v +details
2025/06/12 23:07:00 5 ms
134
set -v +details
2025/06/12 23:39:21 22 ms
135
set -v +details
2025/06/12 23:39:21 6 ms
141
set -v +details
2025/06/12 23:40:40 22 ms
142
set -v +details
2025/06/12 23:40:40 4 ms
158
set -v +details
2025/06/13 06:57:06 24 ms
159
set -v +details
2025/06/13 06:57:06 5 ms
165
set -v +details
2025/06/13 07:16:50 21 ms
166
set -v +details
2025/06/13 07:16:51 5 ms
172
set -v +details
2025/06/13 07:55:30 21 ms
173
set -v +details
2025/06/13 07:55:30 5 ms
187
set -v +details
2025/06/13 22:18:17 23 ms
188
set -v +details
2025/06/13 22:18:17 5 ms
194
set -v +details
2025/06/13 22:37:47 24 ms
195
set -v +details
2025/06/13 22:37:47 5 ms
211
set -v +details
2025/06/13 22:44:54 20 ms
212
set -v +details
2025/06/13 22:44:54 4 ms
248
set -v +details
2025/06/13 23:20:55 20 ms
249
set -v +details
2025/06/13 23:20:55 3 ms
292
set -v +details
2025/06/13 23:29:58 26 ms
293
set -v +details
2025/06/13 23:29:58 4 ms
314
set -v +details
2025/06/13 23:35:49 29 ms
315
set -v +details
2025/06/13 23:35:49 3 ms
320
set -v +details
2025/06/13 23:38:35 22 ms
321
set -v +details
2025/06/13 23:38:36 3 ms
331
set -v +details
2025/06/14 01:23:33 20 ms
332
set -v +details
2025/06/14 01:23:33 4 ms
338
set -v +details
2025/06/14 01:46:18 25 ms
339
set -v +details
2025/06/14 01:46:18 5 ms
345
set -v +details
2025/06/14 01:47:46 21 ms
346
set -v +details
2025/06/14 01:47:46 3 ms
352
set -v +details
2025/06/14 05:46:25 22 ms
353
set -v +details
2025/06/14 05:46:25 4 ms
359
set -v +details
2025/06/14 06:13:08 20 ms
360
set -v +details
2025/06/14 06:13:08 4 ms
366
set -v +details
2025/06/14 06:31:57 20 ms
367
set -v +details
2025/06/14 06:31:57 4 ms
373
set -v +details
2025/06/15 06:43:47 25 ms
374
set -v +details
2025/06/15 06:43:47 4 ms
380
set -v +details
2025/06/15 06:45:37 19 ms
381
set -v +details
2025/06/15 06:45:37 3 ms
387
set -v +details
2025/06/15 06:48:30 19 ms
388
set -v +details
2025/06/15 06:48:30 4 ms
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]
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]
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]
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]
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]
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]
112
select `city` from `default`.`airports` group by `city` order by `city` limit 3502 +details
2025/06/12 22:58:47 0.3 s [24][25]
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]
125
select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000 +details
2025/06/12 23:05:11 0.2 s [29]
269
select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000 +details
2025/06/13 23:21:33 90 ms [39]
303
select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000 +details
2025/06/13 23:34:48 67 ms [41]
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]
113
select `BOOLEAN` from ( select `BOOLEAN`, `C1`, case when `C1` is not null then TO_NUMBER(`C1`, '9999999999') 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:58:50 0.2 s [26][27]
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]
14
select SUM(`elev`) as `C1` from `default`.`airports` +details
2025/06/12 22:04:23 0.4 s [4][5]
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]
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
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
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
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
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
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
100
SHOW TABLES IN `test` +details
2025/06/12 22:58:22 10 ms
101
SHOW TABLES IN `test` +details
2025/06/12 22:58:22 3 ms
154
SHOW TABLES IN `test` +details
2025/06/12 23:51:12 8 ms
155
SHOW TABLES IN `test` +details
2025/06/12 23:51:12 3 ms
207
SHOW TABLES IN `test` +details
2025/06/13 22:39:07 7 ms
208
SHOW TABLES IN `test` +details
2025/06/13 22:39:07 2 ms
224
SHOW TABLES IN `test` +details
2025/06/13 22:51:53 8 ms
225
SHOW TABLES IN `test` +details
2025/06/13 22:51:53 3 ms
234
SHOW TABLES IN `test` +details
2025/06/13 22:54:12 16 ms
235
SHOW TABLES IN `test` +details
2025/06/13 22:54:12 2 ms
261
SHOW TABLES IN `test` +details
2025/06/13 23:21:12 8 ms
262
SHOW TABLES IN `test` +details
2025/06/13 23:21:12 2 ms
288
SHOW TABLES IN `test` +details
2025/06/13 23:27:03 29 ms
289
SHOW TABLES IN `test` +details
2025/06/13 23:27:03 2 ms
310
SHOW TABLES IN `test` +details
2025/06/13 23:34:51 8 ms
311
SHOW TABLES IN `test` +details
2025/06/13 23:34:51 3 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
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
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
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
68
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:52:16 16 ms
Page: