| Job Id (Job Group) | Description | Submitted | Duration ▴ | Stages: Succeeded/Total | Tasks (for all stages): Succeeded/Total |
|---|---|---|---|---|---|
| 41 (8dfd850b-e621-4e50-a84a-47507293ee16) | select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000 runInternal at Operation.java:277 | 2025/06/13 23:34:48 | 19 ms | 1/1 |
1/1
|
| 13 (62b4d0bc-a020-41d5-8603-d0aa88e0b902) | select SUM(`elev`) as `C1` from ( select `elev` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` runInternal at Operation.java:277 | 2025/06/12 22:05:51 | 22 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 26 (30370054-6961-4d9a-a5c7-36dc35377ab6) | 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 runInternal at Operation.java:277 | 2025/06/12 22:58:50 | 26 ms | 1/1 |
1/1
|
| 39 (8999cf5e-c88b-4980-aa38-13e2c37d95c1) | select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000 runInternal at Operation.java:277 | 2025/06/13 23:21:33 | 28 ms | 1/1 |
1/1
|
| 15 (08cd7483-dff7-4313-8b78-d8ccf0606e23) | select `name` from ( select `name` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` group by `name` order by `name` limit 501 runInternal at Operation.java:277 | 2025/06/12 22:05:59 | 34 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 50 (5a03ce3f-80ca-4a28-bbcf-cf5d41428bbe) | SELECT C_43 AS C_12, C_2 AS C_13, C_4 AS C_14, C_4331 AS C_17, C_4332 AS C_16, C_4333 AS C_18, C_8 AS C_19, C_5 AS C_15, C_9 AS C_20, C_6 AS C_24, C_7 AS C_21, C_11 AS C_23, C_10 AS C_22, C_0 AS C_25 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_2, C_64656661756c745f616972706f727473.`name` AS C_4, C_64656661756c745f616972706f727473.`lat` AS C_1, C_64656661756c745f616972706f727473.`lon` AS C_3, C_64656661756c745f616972706f727473.`elev` AS C_0, C_64656661756c745f616972706f727473.`continent` AS C_8, C_64656661756c745f616972706f727473.`country` AS C_5, C_64656661756c745f616972706f727473.`region` AS C_9, C_64656661756c745f616972706f727473.`city` AS C_6, C_64656661756c745f616972706f727473.`iata` AS C_7, C_64656661756c745f616972706f727473.`code` AS C_11, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_25 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/15 06:45:39 | 36 ms | 1/1 |
2/2
|
| 11 (cb61302e-d8d6-49a9-9103-6d442e56cf6e) | select `city` from ( select `city` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:05:04 | 38 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 45 (ee2b3dd1-6798-44ba-a603-2d3b58ef9f09) | SELECT C_5 AS C_13, C_43 AS C_23, C_6 AS C_15, C_4331 AS C_19, C_4332 AS C_21, C_4333 AS C_18, C_0 AS C_25, C_1 AS C_20, C_2 AS C_16, C_3 AS C_22, C_4 AS C_12, C_10 AS C_17, C_11 AS C_14, C_9 AS C_24 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_5, C_64656661756c745f616972706f727473.`type` AS C_43, C_64656661756c745f616972706f727473.`name` AS C_6, C_64656661756c745f616972706f727473.`lat` AS C_7, C_64656661756c745f616972706f727473.`lon` AS C_8, C_64656661756c745f616972706f727473.`elev` AS C_9, C_64656661756c745f616972706f727473.`continent` AS C_0, C_64656661756c745f616972706f727473.`country` AS C_1, C_64656661756c745f616972706f727473.`region` AS C_2, C_64656661756c745f616972706f727473.`city` AS C_3, C_64656661756c745f616972706f727473.`iata` AS C_4, C_64656661756c745f616972706f727473.`code` AS C_10, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_24 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/14 01:47:48 | 39 ms | 1/1 |
2/2
|
| 36 (5ee2818f-b651-41c5-ad86-413b14b0a699) | SELECT C_43 AS C_16, C_3 AS C_17, C_2 AS C_15, C_4331 AS C_21, C_4332 AS C_22, C_4333 AS C_19, C_7 AS C_18, C_6 AS C_20, C_9 AS C_23, C_8 AS C_25, C_5 AS C_24, C_11 AS C_13, C_10 AS C_12, C_1 AS C_14 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_3, C_64656661756c745f616972706f727473.`name` AS C_2, C_64656661756c745f616972706f727473.`lat` AS C_0, C_64656661756c745f616972706f727473.`lon` AS C_4, C_64656661756c745f616972706f727473.`elev` AS C_1, C_64656661756c745f616972706f727473.`continent` AS C_7, C_64656661756c745f616972706f727473.`country` AS C_6, C_64656661756c745f616972706f727473.`region` AS C_9, C_64656661756c745f616972706f727473.`city` AS C_8, C_64656661756c745f616972706f727473.`iata` AS C_5, C_64656661756c745f616972706f727473.`code` AS C_11, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_14 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 22:37:48 | 39 ms | 1/1 |
2/2
|
| 51 (a3ecd11e-5087-4d17-a30d-f68b8e8f4d8f) | SELECT C_0 AS C_12, C_1 AS C_17, C_2 AS C_14, C_4331 AS C_25, C_4332 AS C_18, C_4333 AS C_21, C_4 AS C_22, C_6 AS C_19, C_8 AS C_13, C_9 AS C_20, C_10 AS C_24, C_43 AS C_16, C_11 AS C_15, C_7 AS C_23 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_0, C_64656661756c745f616972706f727473.`type` AS C_1, C_64656661756c745f616972706f727473.`name` AS C_2, C_64656661756c745f616972706f727473.`lat` AS C_5, C_64656661756c745f616972706f727473.`lon` AS C_3, C_64656661756c745f616972706f727473.`elev` AS C_7, C_64656661756c745f616972706f727473.`continent` AS C_4, C_64656661756c745f616972706f727473.`country` AS C_6, C_64656661756c745f616972706f727473.`region` AS C_8, C_64656661756c745f616972706f727473.`city` AS C_9, C_64656661756c745f616972706f727473.`iata` AS C_10, C_64656661756c745f616972706f727473.`code` AS C_43, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_23 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/15 06:48:31 | 40 ms | 1/1 |
2/2
|
| 44 (f9847174-6e75-4840-9e85-bace463b6e36) | SELECT C_5 AS C_18, C_6 AS C_19, C_0 AS C_15, C_4331 AS C_22, C_4332 AS C_25, C_4333 AS C_20, C_4 AS C_23, C_43 AS C_14, C_11 AS C_12, C_8 AS C_17, C_7 AS C_24, C_9 AS C_21, C_10 AS C_13, C_3 AS C_16 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_5, C_64656661756c745f616972706f727473.`type` AS C_6, C_64656661756c745f616972706f727473.`name` AS C_0, C_64656661756c745f616972706f727473.`lat` AS C_1, C_64656661756c745f616972706f727473.`lon` AS C_2, C_64656661756c745f616972706f727473.`elev` AS C_3, C_64656661756c745f616972706f727473.`continent` AS C_4, C_64656661756c745f616972706f727473.`country` AS C_43, C_64656661756c745f616972706f727473.`region` AS C_11, C_64656661756c745f616972706f727473.`city` AS C_8, C_64656661756c745f616972706f727473.`iata` AS C_7, C_64656661756c745f616972706f727473.`code` AS C_9, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_16 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/14 01:46:19 | 40 ms | 1/1 |
2/2
|
| 7 (ab6a426a-aa9c-44ab-b3e2-c6c4df925c8a) | select SUM(`lat`) as `C1`, SUM(`elev`) as `C2` from `default`.`airports` runInternal at Operation.java:277 | 2025/06/12 22:04:25 | 41 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 38 (17b645b6-20fb-40fb-bd88-8bff22d539bd) | SELECT C_0 AS C_13, C_43 AS C_14, C_5 AS C_15, C_4331 AS C_16, C_4332 AS C_12, C_4333 AS C_17, C_1 AS C_18, C_6 AS C_21, C_7 AS C_19, C_8 AS C_20, C_10 AS C_23, C_9 AS C_24, C_11 AS C_25, C_4 AS C_22 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_0, C_64656661756c745f616972706f727473.`type` AS C_43, C_64656661756c745f616972706f727473.`name` AS C_5, C_64656661756c745f616972706f727473.`lat` AS C_3, C_64656661756c745f616972706f727473.`lon` AS C_2, C_64656661756c745f616972706f727473.`elev` AS C_4, C_64656661756c745f616972706f727473.`continent` AS C_1, C_64656661756c745f616972706f727473.`country` AS C_6, C_64656661756c745f616972706f727473.`region` AS C_7, C_64656661756c745f616972706f727473.`city` AS C_8, C_64656661756c745f616972706f727473.`iata` AS C_10, C_64656661756c745f616972706f727473.`code` AS C_9, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_22 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 23:20:56 | 42 ms | 1/1 |
2/2
|
| 27 (30370054-6961-4d9a-a5c7-36dc35377ab6) | 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 runInternal at Operation.java:277 | 2025/06/12 22:58:51 | 42 ms | 1/1 (1 skipped) |
1/1
(1 skipped)
|
| 40 (73e233e0-56bd-41c0-8dba-7883655f69f6) | SELECT C_1 AS C_20, C_2 AS C_18, C_3 AS C_21, C_4331 AS C_22, C_4332 AS C_25, C_4333 AS C_19, C_0 AS C_17, C_43 AS C_12, C_10 AS C_15, C_8 AS C_23, C_7 AS C_13, C_9 AS C_16, C_11 AS C_14, C_6 AS C_24 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_1, C_64656661756c745f616972706f727473.`type` AS C_2, C_64656661756c745f616972706f727473.`name` AS C_3, C_64656661756c745f616972706f727473.`lat` AS C_4, C_64656661756c745f616972706f727473.`lon` AS C_5, C_64656661756c745f616972706f727473.`elev` AS C_6, C_64656661756c745f616972706f727473.`continent` AS C_0, C_64656661756c745f616972706f727473.`country` AS C_43, C_64656661756c745f616972706f727473.`region` AS C_10, C_64656661756c745f616972706f727473.`city` AS C_8, C_64656661756c745f616972706f727473.`iata` AS C_7, C_64656661756c745f616972706f727473.`code` AS C_9, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_24 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 23:29:59 | 43 ms | 1/1 |
2/2
|
| 5 (1a4231a5-a440-4bc2-b0d3-31014beb610f) | select SUM(`elev`) as `C1` from `default`.`airports` runInternal at Operation.java:277 | 2025/06/12 22:04:23 | 43 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 37 (1f24d235-f05b-48c7-98cd-daab7569b935) | SELECT C_9 AS C_25, C_2 AS C_22, C_7 AS C_19, C_4331 AS C_16, C_4332 AS C_18, C_4333 AS C_13, C_6 AS C_21, C_8 AS C_20, C_43 AS C_17, C_0 AS C_14, C_1 AS C_12, C_11 AS C_24, C_10 AS C_15, C_5 AS C_23 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_9, C_64656661756c745f616972706f727473.`type` AS C_2, C_64656661756c745f616972706f727473.`name` AS C_7, C_64656661756c745f616972706f727473.`lat` AS C_3, C_64656661756c745f616972706f727473.`lon` AS C_4, C_64656661756c745f616972706f727473.`elev` AS C_5, C_64656661756c745f616972706f727473.`continent` AS C_6, C_64656661756c745f616972706f727473.`country` AS C_8, C_64656661756c745f616972706f727473.`region` AS C_43, C_64656661756c745f616972706f727473.`city` AS C_0, C_64656661756c745f616972706f727473.`iata` AS C_1, C_64656661756c745f616972706f727473.`code` AS C_11, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_23 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 22:44:56 | 44 ms | 1/1 |
2/2
|
| 34 (ecb3129b-9429-40bb-b1cd-f300b33f73c0) | SELECT C_43 AS C_12, C_1 AS C_16, C_2 AS C_14, C_4331 AS C_17, C_4332 AS C_13, C_4333 AS C_15, C_8 AS C_19, C_9 AS C_21, C_5 AS C_18, C_6 AS C_20, C_7 AS C_22, C_10 AS C_24, C_11 AS C_23, C_3 AS C_25 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_1, C_64656661756c745f616972706f727473.`name` AS C_2, C_64656661756c745f616972706f727473.`lat` AS C_4, C_64656661756c745f616972706f727473.`lon` AS C_0, C_64656661756c745f616972706f727473.`elev` AS C_3, C_64656661756c745f616972706f727473.`continent` AS C_8, C_64656661756c745f616972706f727473.`country` AS C_9, C_64656661756c745f616972706f727473.`region` AS C_5, C_64656661756c745f616972706f727473.`city` AS C_6, C_64656661756c745f616972706f727473.`iata` AS C_7, C_64656661756c745f616972706f727473.`code` AS C_10, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_25 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 07:55:32 | 46 ms | 1/1 |
2/2
|
| 31 (a3b91188-50a6-4fec-b0be-0445cd0a9748) | SELECT C_8 AS C_21, C_0 AS C_17, C_43 AS C_23, C_4331 AS C_24, C_4332 AS C_12, C_4333 AS C_15, C_3 AS C_13, C_7 AS C_22, C_2 AS C_18, C_11 AS C_16, C_5 AS C_14, C_4 AS C_25, C_10 AS C_20, C_6 AS C_19 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_8, C_64656661756c745f616972706f727473.`type` AS C_0, C_64656661756c745f616972706f727473.`name` AS C_43, C_64656661756c745f616972706f727473.`lat` AS C_1, C_64656661756c745f616972706f727473.`lon` AS C_9, C_64656661756c745f616972706f727473.`elev` AS C_6, C_64656661756c745f616972706f727473.`continent` AS C_3, C_64656661756c745f616972706f727473.`country` AS C_7, C_64656661756c745f616972706f727473.`region` AS C_2, C_64656661756c745f616972706f727473.`city` AS C_11, C_64656661756c745f616972706f727473.`iata` AS C_5, C_64656661756c745f616972706f727473.`code` AS C_4, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_19 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/12 23:40:41 | 47 ms | 1/1 |
2/2
|
| 42 (0fbc9c82-791c-4e57-af50-0ea0e2e1e9d6) | SELECT C_5 AS C_21, C_6 AS C_18, C_7 AS C_22, C_4331 AS C_14, C_4332 AS C_23, C_4333 AS C_17, C_0 AS C_20, C_1 AS C_13, C_43 AS C_12, C_4 AS C_19, C_2 AS C_24, C_10 AS C_15, C_11 AS C_16, C_9 AS C_25 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_5, C_64656661756c745f616972706f727473.`type` AS C_6, C_64656661756c745f616972706f727473.`name` AS C_7, C_64656661756c745f616972706f727473.`lat` AS C_8, C_64656661756c745f616972706f727473.`lon` AS C_3, C_64656661756c745f616972706f727473.`elev` AS C_9, C_64656661756c745f616972706f727473.`continent` AS C_0, C_64656661756c745f616972706f727473.`country` AS C_1, C_64656661756c745f616972706f727473.`region` AS C_43, C_64656661756c745f616972706f727473.`city` AS C_4, C_64656661756c745f616972706f727473.`iata` AS C_2, C_64656661756c745f616972706f727473.`code` AS C_10, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_25 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 23:38:37 | 49 ms | 1/1 |
2/2
|
| 10 (480a6918-1d69-43f9-b117-24dfe4935f0e) | select SUM(`elev`) as `C1`, SUM(`lat`) as `C2` from ( select `lat`, `elev` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` runInternal at Operation.java:277 | 2025/06/12 22:05:04 | 53 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 3 (aa3f01cb-b826-48ef-9e8a-6bfe18a8b471) | select `code` from `default`.`airports` group by `code` order by `code` limit 501 runInternal at Operation.java:277 | 2025/06/12 22:04:18 | 54 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 33 (dd9c74a0-d6cd-4177-80d7-a0ed129f43bf) | SELECT C_10 AS C_12, C_2 AS C_14, C_43 AS C_17, C_4331 AS C_18, C_4332 AS C_21, C_4333 AS C_19, C_9 AS C_23, C_0 AS C_16, C_3 AS C_15, C_1 AS C_22, C_4 AS C_13, C_5 AS C_24, C_11 AS C_25, C_6 AS C_20 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_10, C_64656661756c745f616972706f727473.`type` AS C_2, C_64656661756c745f616972706f727473.`name` AS C_43, C_64656661756c745f616972706f727473.`lat` AS C_7, C_64656661756c745f616972706f727473.`lon` AS C_8, C_64656661756c745f616972706f727473.`elev` AS C_6, C_64656661756c745f616972706f727473.`continent` AS C_9, C_64656661756c745f616972706f727473.`country` AS C_0, C_64656661756c745f616972706f727473.`region` AS C_3, C_64656661756c745f616972706f727473.`city` AS C_1, C_64656661756c745f616972706f727473.`iata` AS C_4, C_64656661756c745f616972706f727473.`code` AS C_5, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_20 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 07:16:52 | 55 ms | 1/1 |
2/2
|
| 19 (34e53456-078d-4d85-bae2-fc6e40d41ad7) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:38:41 | 55 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 46 (a5329af3-41e1-4fc1-a7d7-63e39fcce790) | SELECT C_43 AS C_12, C_4 AS C_13, C_1 AS C_17, C_4331 AS C_19, C_4332 AS C_18, C_4333 AS C_16, C_6 AS C_15, C_8 AS C_14, C_9 AS C_20, C_7 AS C_23, C_5 AS C_22, C_10 AS C_21, C_11 AS C_24, C_0 AS C_25 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_4, C_64656661756c745f616972706f727473.`name` AS C_1, C_64656661756c745f616972706f727473.`lat` AS C_2, C_64656661756c745f616972706f727473.`lon` AS C_3, C_64656661756c745f616972706f727473.`elev` AS C_0, C_64656661756c745f616972706f727473.`continent` AS C_6, C_64656661756c745f616972706f727473.`country` AS C_8, C_64656661756c745f616972706f727473.`region` AS C_9, C_64656661756c745f616972706f727473.`city` AS C_7, C_64656661756c745f616972706f727473.`iata` AS C_5, C_64656661756c745f616972706f727473.`code` AS C_10, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_25 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/14 05:46:27 | 59 ms | 1/1 |
2/2
|
| 49 (c5b801e3-00af-402d-acbd-beefd5e1196d) | SELECT C_43 AS C_13, C_0 AS C_12, C_8 AS C_18, C_4331 AS C_21, C_4332 AS C_17, C_4333 AS C_20, C_4 AS C_22, C_5 AS C_25, C_6 AS C_23, C_7 AS C_14, C_9 AS C_24, C_11 AS C_16, C_10 AS C_19, C_2 AS C_15 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_0, C_64656661756c745f616972706f727473.`name` AS C_8, C_64656661756c745f616972706f727473.`lat` AS C_3, C_64656661756c745f616972706f727473.`lon` AS C_1, C_64656661756c745f616972706f727473.`elev` AS C_2, C_64656661756c745f616972706f727473.`continent` AS C_4, C_64656661756c745f616972706f727473.`country` AS C_5, C_64656661756c745f616972706f727473.`region` AS C_6, C_64656661756c745f616972706f727473.`city` AS C_7, C_64656661756c745f616972706f727473.`iata` AS C_9, C_64656661756c745f616972706f727473.`code` AS C_11, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_15 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/15 06:43:49 | 60 ms | 1/1 |
2/2
|
| 43 (fb16b2b0-de8d-49bf-b0a7-b6bb85b04e2b) | SELECT C_0 AS C_14, C_1 AS C_13, C_43 AS C_12, C_4331 AS C_18, C_4332 AS C_20, C_4333 AS C_16, C_6 AS C_19, C_8 AS C_17, C_5 AS C_15, C_7 AS C_22, C_9 AS C_25, C_11 AS C_23, C_10 AS C_21, C_3 AS C_24 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_0, C_64656661756c745f616972706f727473.`type` AS C_1, C_64656661756c745f616972706f727473.`name` AS C_43, C_64656661756c745f616972706f727473.`lat` AS C_2, C_64656661756c745f616972706f727473.`lon` AS C_4, C_64656661756c745f616972706f727473.`elev` AS C_3, C_64656661756c745f616972706f727473.`continent` AS C_6, C_64656661756c745f616972706f727473.`country` AS C_8, C_64656661756c745f616972706f727473.`region` AS C_5, C_64656661756c745f616972706f727473.`city` AS C_7, C_64656661756c745f616972706f727473.`iata` AS C_9, C_64656661756c745f616972706f727473.`code` AS C_11, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_24 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/14 01:23:35 | 61 ms | 1/1 |
2/2
|
| 48 (04f41b96-5df1-4fc1-93b2-986be81617a4) | SELECT C_10 AS C_13, C_43 AS C_18, C_4 AS C_23, C_4331 AS C_16, C_4332 AS C_21, C_4333 AS C_22, C_7 AS C_20, C_2 AS C_15, C_5 AS C_25, C_8 AS C_12, C_9 AS C_24, C_3 AS C_14, C_11 AS C_19, C_1 AS C_17 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_10, C_64656661756c745f616972706f727473.`type` AS C_43, C_64656661756c745f616972706f727473.`name` AS C_4, C_64656661756c745f616972706f727473.`lat` AS C_0, C_64656661756c745f616972706f727473.`lon` AS C_6, C_64656661756c745f616972706f727473.`elev` AS C_1, C_64656661756c745f616972706f727473.`continent` AS C_7, C_64656661756c745f616972706f727473.`country` AS C_2, C_64656661756c745f616972706f727473.`region` AS C_5, C_64656661756c745f616972706f727473.`city` AS C_8, C_64656661756c745f616972706f727473.`iata` AS C_9, C_64656661756c745f616972706f727473.`code` AS C_3, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_17 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/14 06:31:59 | 63 ms | 1/1 |
2/2
|
| 25 (e3519f77-6db3-4f52-98bb-48ad5a6126da) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:58:47 | 68 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 35 (8941a51a-eff4-4b55-b556-60fcfdad821f) | SELECT C_3 AS C_18, C_0 AS C_12, C_4 AS C_19, C_4331 AS C_14, C_4332 AS C_17, C_4333 AS C_22, C_7 AS C_23, C_8 AS C_15, C_9 AS C_20, C_10 AS C_16, C_43 AS C_25, C_2 AS C_13, C_11 AS C_24, C_1 AS C_21 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_3, C_64656661756c745f616972706f727473.`type` AS C_0, C_64656661756c745f616972706f727473.`name` AS C_4, C_64656661756c745f616972706f727473.`lat` AS C_5, C_64656661756c745f616972706f727473.`lon` AS C_6, C_64656661756c745f616972706f727473.`elev` AS C_1, C_64656661756c745f616972706f727473.`continent` AS C_7, C_64656661756c745f616972706f727473.`country` AS C_8, C_64656661756c745f616972706f727473.`region` AS C_9, C_64656661756c745f616972706f727473.`city` AS C_10, C_64656661756c745f616972706f727473.`iata` AS C_43, C_64656661756c745f616972706f727473.`code` AS C_2, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_21 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 22:18:19 | 71 ms | 1/1 |
2/2
|
| 47 (12fe5c7a-924f-42f4-a7d5-c14493d2d747) | SELECT C_43 AS C_21, C_0 AS C_12, C_1 AS C_17, C_4331 AS C_16, C_4332 AS C_25, C_4333 AS C_23, C_4 AS C_19, C_5 AS C_20, C_7 AS C_14, C_8 AS C_18, C_9 AS C_22, C_11 AS C_15, C_10 AS C_13, C_3 AS C_24 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_0, C_64656661756c745f616972706f727473.`name` AS C_1, C_64656661756c745f616972706f727473.`lat` AS C_2, C_64656661756c745f616972706f727473.`lon` AS C_6, C_64656661756c745f616972706f727473.`elev` AS C_3, C_64656661756c745f616972706f727473.`continent` AS C_4, C_64656661756c745f616972706f727473.`country` AS C_5, C_64656661756c745f616972706f727473.`region` AS C_7, C_64656661756c745f616972706f727473.`city` AS C_8, C_64656661756c745f616972706f727473.`iata` AS C_9, C_64656661756c745f616972706f727473.`code` AS C_11, C_64656661756c745f616972706f727473.`gps` AS C_10, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_24 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/14 06:13:09 | 74 ms | 1/1 |
2/2
|
| 32 (03d4d9e8-6a2d-4d2d-a253-63696f36868f) | SELECT C_4 AS C_17, C_6 AS C_13, C_7 AS C_18, C_4331 AS C_21, C_4332 AS C_16, C_4333 AS C_14, C_0 AS C_12, C_8 AS C_23, C_1 AS C_15, C_9 AS C_20, C_2 AS C_22, C_10 AS C_25, C_11 AS C_24, C_5 AS C_19 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_4, C_64656661756c745f616972706f727473.`type` AS C_6, C_64656661756c745f616972706f727473.`name` AS C_7, C_64656661756c745f616972706f727473.`lat` AS C_43, C_64656661756c745f616972706f727473.`lon` AS C_3, C_64656661756c745f616972706f727473.`elev` AS C_5, C_64656661756c745f616972706f727473.`continent` AS C_0, C_64656661756c745f616972706f727473.`country` AS C_8, C_64656661756c745f616972706f727473.`region` AS C_1, C_64656661756c745f616972706f727473.`city` AS C_9, C_64656661756c745f616972706f727473.`iata` AS C_2, C_64656661756c745f616972706f727473.`code` AS C_10, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_19 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/13 06:57:08 | 85 ms | 1/1 |
2/2
|
| 23 (b1af2328-4624-49b9-8adb-2b3254a41690) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:53:25 | 87 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 21 (59faa59c-e3c9-4f0c-91f9-fc819088b1a6) | 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 runInternal at Operation.java:277 | 2025/06/12 22:53:19 | 91 ms | 1/1 (1 skipped) |
1/1
(1 skipped)
|
| 30 (61183586-d0ee-46ba-aa2f-0b06e84ff2ce) | SELECT C_4 AS C_16, C_6 AS C_23, C_43 AS C_22, C_4331 AS C_25, C_4332 AS C_24, C_4333 AS C_12, C_10 AS C_14, C_11 AS C_13, C_7 AS C_15, C_9 AS C_17, C_0 AS C_18, C_8 AS C_19, C_3 AS C_20, C_2 AS C_21 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_4, C_64656661756c745f616972706f727473.`type` AS C_6, C_64656661756c745f616972706f727473.`name` AS C_43, C_64656661756c745f616972706f727473.`lat` AS C_1, C_64656661756c745f616972706f727473.`lon` AS C_5, C_64656661756c745f616972706f727473.`elev` AS C_2, C_64656661756c745f616972706f727473.`continent` AS C_10, C_64656661756c745f616972706f727473.`country` AS C_11, C_64656661756c745f616972706f727473.`region` AS C_7, C_64656661756c745f616972706f727473.`city` AS C_9, C_64656661756c745f616972706f727473.`iata` AS C_0, C_64656661756c745f616972706f727473.`code` AS C_8, C_64656661756c745f616972706f727473.`gps` AS C_3, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_21 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/12 23:39:22 | 94 ms | 1/1 |
2/2
|
| 17 (a31e4a56-dbfd-4e35-bb0e-f113b4feb1fa) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:14:27 | 99 ms | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 14 (08cd7483-dff7-4313-8b78-d8ccf0606e23) | select `name` from ( select `name` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` group by `name` order by `name` limit 501 runInternal at Operation.java:277 | 2025/06/12 22:05:59 | 0.1 s | 1/1 |
2/2
|
| 12 (62b4d0bc-a020-41d5-8603-d0aa88e0b902) | select SUM(`elev`) as `C1` from ( select `elev` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` runInternal at Operation.java:277 | 2025/06/12 22:05:51 | 0.1 s | 1/1 |
2/2
|
| 6 (ab6a426a-aa9c-44ab-b3e2-c6c4df925c8a) | select SUM(`lat`) as `C1`, SUM(`elev`) as `C2` from `default`.`airports` runInternal at Operation.java:277 | 2025/06/12 22:04:25 | 0.1 s | 1/1 |
2/2
|
| 18 (34e53456-078d-4d85-bae2-fc6e40d41ad7) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:38:41 | 0.1 s | 1/1 |
2/2
|
| 29 (408ac867-c17d-461c-96dd-1dcd09d51c97) | select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000 runInternal at Operation.java:277 | 2025/06/12 23:05:11 | 0.1 s | 1/1 |
1/1
|
| 4 (1a4231a5-a440-4bc2-b0d3-31014beb610f) | select SUM(`elev`) as `C1` from `default`.`airports` runInternal at Operation.java:277 | 2025/06/12 22:04:23 | 0.1 s | 1/1 |
2/2
|
| 2 (aa3f01cb-b826-48ef-9e8a-6bfe18a8b471) | select `code` from `default`.`airports` group by `code` order by `code` limit 501 runInternal at Operation.java:277 | 2025/06/12 22:04:17 | 0.1 s | 1/1 |
2/2
|
| 28 (627a5046-396b-45f7-8543-3480d0a253c5) | SELECT C_43 AS C_12, C_2 AS C_13, C_0 AS C_14, C_4331 AS C_15, C_4332 AS C_18, C_4333 AS C_16, C_6 AS C_17, C_9 AS C_19, C_5 AS C_20, C_7 AS C_21, C_8 AS C_23, C_10 AS C_24, C_11 AS C_22, C_4 AS C_25 FROM (SELECT C_64656661756c745f616972706f727473.`id` AS C_43, C_64656661756c745f616972706f727473.`type` AS C_2, C_64656661756c745f616972706f727473.`name` AS C_0, C_64656661756c745f616972706f727473.`lat` AS C_3, C_64656661756c745f616972706f727473.`lon` AS C_1, C_64656661756c745f616972706f727473.`elev` AS C_4, C_64656661756c745f616972706f727473.`continent` AS C_6, C_64656661756c745f616972706f727473.`country` AS C_9, C_64656661756c745f616972706f727473.`region` AS C_5, C_64656661756c745f616972706f727473.`city` AS C_7, C_64656661756c745f616972706f727473.`iata` AS C_8, C_64656661756c745f616972706f727473.`code` AS C_10, C_64656661756c745f616972706f727473.`gps` AS C_11, (round((C_64656661756c745f616972706f727473.`lat` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4331, (round((C_64656661756c745f616972706f727473.`lon` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4332, (round((C_64656661756c745f616972706f727473.`elev` * power(1.000000000000000E+001, 3)), 0) / power(1.000000000000000E+001, 3)) AS C_4333 FROM `default`.`airports` C_64656661756c745f616972706f727473 WHERE ((C_64656661756c745f616972706f727473.`lon` <= (- 1.040500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lon` >= (- 1.110500000000000E+002)) AND (C_64656661756c745f616972706f727473.`lat` >= 4.100000000000000E+001) AND (C_64656661756c745f616972706f727473.`lat` <= 4.500000000000000E+001)) ) C_4954424c ORDER BY C_25 DESC LIMIT 5 run at AccessController.java:0 | 2025/06/12 23:04:02 | 0.2 s | 1/1 |
2/2
|
| 20 (59faa59c-e3c9-4f0c-91f9-fc819088b1a6) | 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 runInternal at Operation.java:277 | 2025/06/12 22:53:18 | 0.2 s | 1/1 |
1/1
|
| 22 (b1af2328-4624-49b9-8adb-2b3254a41690) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:53:25 | 0.2 s | 1/1 |
2/2
|
| 16 (a31e4a56-dbfd-4e35-bb0e-f113b4feb1fa) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:14:27 | 0.2 s | 1/1 |
2/2
|
| 24 (e3519f77-6db3-4f52-98bb-48ad5a6126da) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:58:47 | 0.2 s | 1/1 |
2/2
|
| 9 (cb61302e-d8d6-49a9-9103-6d442e56cf6e) | select `city` from ( select `city` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:05:04 | 0.2 s | 1/1 |
2/2
|
| 8 (480a6918-1d69-43f9-b117-24dfe4935f0e) | select SUM(`elev`) as `C1`, SUM(`lat`) as `C2` from ( select `lat`, `elev` from `default`.`airports` where `code` = '0GA2' ) as `ITBL` runInternal at Operation.java:277 | 2025/06/12 22:05:04 | 0.3 s | 1/1 |
2/2
|
| 1 (28d4323c-d37a-4c9b-81d0-a58775dd6d82) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:04:07 | 0.4 s | 1/1 (1 skipped) |
1/1
(2 skipped)
|
| 0 (28d4323c-d37a-4c9b-81d0-a58775dd6d82) | select `city` from `default`.`airports` group by `city` order by `city` limit 3502 runInternal at Operation.java:277 | 2025/06/12 22:04:06 | 2 s | 1/1 |
2/2
|