SQL / DataFrame

Completed Queries (394)

Page:
ID Description Submitted Duration ▾ Job IDs
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]
0
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:03:27 2 s
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]
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]
14
select SUM(`elev`) as `C1` from `default`.`airports` +details
2025/06/12 22:04:23 0.4 s [4][5]
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]
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]
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]
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]
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]
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]
120
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 +details
2025/06/12 23:04:02 0.3 s [28]
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]
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]
140
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 +details
2025/06/12 23:39:22 0.2 s [30]
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]
164
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 +details
2025/06/13 06:57:08 0.2 s [32]
193
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 +details
2025/06/13 22:18:18 0.2 s [35]
365
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 +details
2025/06/14 06:13:09 0.2 s [47]
337
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 +details
2025/06/14 01:23:35 0.1 s [43]
358
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 +details
2025/06/14 05:46:27 0.1 s [46]
372
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 +details
2025/06/14 06:31:59 0.1 s [48]
379
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 +details
2025/06/15 06:43:49 0.1 s [49]
55
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:38:21 0.1 s
147
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 +details
2025/06/12 23:40:41 0.1 s [31]
171
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 +details
2025/06/13 07:16:52 0.1 s [33]
217
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 +details
2025/06/13 22:44:56 97 ms [37]
326
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 +details
2025/06/13 23:38:37 92 ms [42]
88
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:53:10 90 ms
178
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 +details
2025/06/13 07:55:32 90 ms [34]
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]
298
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 +details
2025/06/13 23:29:59 86 ms [40]
344
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 +details
2025/06/14 01:46:19 85 ms [44]
200
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 +details
2025/06/13 22:37:48 84 ms [36]
386
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 +details
2025/06/15 06:45:39 83 ms [50]
254
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 +details
2025/06/13 23:20:56 82 ms [38]
351
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 +details
2025/06/14 01:47:48 81 ms [45]
393
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 +details
2025/06/15 06:48:31 78 ms [51]
10
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:03:47 72 ms
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]
89
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:53:10 62 ms
94
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:58:21 56 ms
20
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:13:49 49 ms
45
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:38:02 48 ms
35
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:16:53 47 ms
47
SHOW TABLES IN `default` +details
2025/06/12 22:38:03 47 ms
24
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:13:50 46 ms
64
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:52:15 46 ms
32
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:14:13 42 ms
114
set -v +details
2025/06/12 23:04:00 42 ms
30
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:14:13 41 ms
1
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 22:03:29 40 ms
80
SHOW TABLES IN `default` +details
2025/06/12 22:53:02 40 ms
106
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:58:33 40 ms
2
SHOW TABLES IN `default` +details
2025/06/12 22:03:29 38 ms
74
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:52:27 38 ms
98
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:58:22 38 ms
255
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/13 23:21:10 37 ms
57
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:38:22 36 ms
59
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:38:22 36 ms
148
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/12 23:51:11 36 ms
228
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/13 22:54:10 36 ms
304
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/13 23:34:50 36 ms
4
SHOW TABLES IN `onetableschema` +details
2025/06/12 22:03:30 35 ms
116
DESCRIBE default.airports +details
2025/06/12 23:04:01 35 ms
257
SHOW TABLES IN `default` +details
2025/06/13 23:21:11 35 ms
110
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:58:34 34 ms
152
SHOW TABLES IN `onetableschema` +details
2025/06/12 23:51:12 34 ms
203
SHOW TABLES IN `default` +details
2025/06/13 22:39:06 34 ms
220
SHOW TABLES IN `default` +details
2025/06/13 22:51:52 34 ms
230
SHOW TABLES IN `default` +details
2025/06/13 22:54:11 34 ms
347
DESCRIBE default.airports +details
2025/06/14 01:47:47 34 ms
76
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:52:27 32 ms
121
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 23:05:11 32 ms
61
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:38:23 30 ms
104
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:58:32 30 ms
132
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 23:18:09 30 ms
108
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 22:58:33 29 ms
215
DESCRIBE default.airports +details
2025/06/13 22:44:55 29 ms
288
SHOW TABLES IN `test` +details
2025/06/13 23:27:03 29 ms
314
set -v +details
2025/06/13 23:35:49 29 ms
118
DESCRIBE default.airports +details
2025/06/12 23:04:01 28 ms
123
DESCRIBE TABLE `default`.`alltypes` +details
2025/06/12 23:05:11 28 ms
138
DESCRIBE default.airports +details
2025/06/12 23:39:22 28 ms
128
DESCRIBE default.alltypes +details
2025/06/12 23:07:01 27 ms
238
DESCRIBE TABLE `default`.`AllTypes` +details
2025/06/13 23:12:39 27 ms
11
DESCRIBE TABLE `default`.`airports` +details
2025/06/12 22:03:47 26 ms
130
DESCRIBE default.alltypes +details
2025/06/12 23:07:01 26 ms
136
DESCRIBE default.airports +details
2025/06/12 23:39:21 26 ms
160
DESCRIBE default.airports +details
2025/06/13 06:57:07 26 ms
167
DESCRIBE default.airports +details
2025/06/13 07:16:51 26 ms
213
DESCRIBE default.airports +details
2025/06/13 22:44:55 26 ms
292
set -v +details
2025/06/13 23:29:58 26 ms
349
DESCRIBE default.airports +details
2025/06/14 01:47:47 26 ms
375
DESCRIBE default.airports +details
2025/06/15 06:43:48 26 ms
162
DESCRIBE default.airports +details
2025/06/13 06:57:07 25 ms
174
DESCRIBE default.airports +details
2025/06/13 07:55:31 25 ms
201
SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e` +details
2025/06/13 22:39:05 25 ms
Page: