JDBC/ODBC Session

  • Started at: 2025/06/12 22:03:11
  • Time since start: 2 days 14 hours 8 minutes

User jonathon, IP 52.159.208.137, Session created at 2025/06/13 06:57:06, Total run 7 SQL

SQL Statistics

Page:
User JobID GroupID Start Time ▾ Finish Time Close Time Execution Time Duration Statement State Detail
jonathon [32] 03d4d9e8-6a2d-4d2d-a253-63696f36868f 2025/06/13 06:57:07 2025/06/13 06:57:08 2025/06/13 06:57:08 307 ms 403 ms 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 CLOSED == Parsed Logical Plan == +details
jonathon fd73230f-0d28-4938-91c3-3beae7d8300b 2025/06/13 06:57:07 2025/06/13 06:57:07 2025/06/13 06:57:07 27 ms 122 ms Listing columns 'catalog : null, schemaPattern : default, tablePattern : airports, columnName : null' CLOSED
jonathon 98618df6-635a-4bab-91c9-a30788598b2a 2025/06/13 06:57:07 2025/06/13 06:57:07 2025/06/13 06:57:07 96 ms 204 ms DESCRIBE default.airports CLOSED == Parsed Logical Plan == +details
Page: