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
== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
+- 'Sort ['C_19 DESC NULLS LAST], true
+- 'Project ['C_4 AS C_17#1976, 'C_6 AS C_13#1977, 'C_7 AS C_18#1978, 'C_4331 AS C_21#1979, 'C_4332 AS C_16#1980, 'C_4333 AS C_14#1981, 'C_0 AS C_12#1982, 'C_8 AS C_23#1983, 'C_1 AS C_15#1984, 'C_9 AS C_20#1985, 'C_2 AS C_22#1986, 'C_10 AS C_25#1987, 'C_11 AS C_24#1988, 'C_5 AS C_19#1989]
+- 'SubqueryAlias C_4954424c
+- 'Project ['C_64656661756c745f616972706f727473.id AS C_4#1960, 'C_64656661756c745f616972706f727473.type AS C_6#1961, 'C_64656661756c745f616972706f727473.name AS C_7#1962, 'C_64656661756c745f616972706f727473.lat AS C_43#1963, 'C_64656661756c745f616972706f727473.lon AS C_3#1964, 'C_64656661756c745f616972706f727473.elev AS C_5#1965, 'C_64656661756c745f616972706f727473.continent AS C_0#1966, 'C_64656661756c745f616972706f727473.country AS C_8#1967, 'C_64656661756c745f616972706f727473.region AS C_1#1968, 'C_64656661756c745f616972706f727473.city AS C_9#1969, 'C_64656661756c745f616972706f727473.iata AS C_2#1970, 'C_64656661756c745f616972706f727473.code AS C_10#1971, 'C_64656661756c745f616972706f727473.gps AS C_11#1972, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#1973, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#1974, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#1975]
+- 'Filter ((('C_64656661756c745f616972706f727473.lon <= -104.05) AND ('C_64656661756c745f616972706f727473.lon >= -111.05)) AND (('C_64656661756c745f616972706f727473.lat >= 41.0) AND ('C_64656661756c745f616972706f727473.lat <= 45.0)))
+- 'SubqueryAlias C_64656661756c745f616972706f727473
+- 'UnresolvedRelation [default, airports], [], false
== Analyzed Logical Plan ==
C_17: string, C_13: string, C_18: string, C_21: double, C_16: double, C_14: double, C_12: string, C_23: string, C_15: string, C_20: string, C_22: string, C_25: string, C_24: string, C_19: double
GlobalLimit 5
+- LocalLimit 5
+- Sort [C_19#1989 DESC NULLS LAST], true
+- Project [C_4#1960 AS C_17#1976, C_6#1961 AS C_13#1977, C_7#1962 AS C_18#1978, C_4331#1973 AS C_21#1979, C_4332#1974 AS C_16#1980, C_4333#1975 AS C_14#1981, C_0#1966 AS C_12#1982, C_8#1967 AS C_23#1983, C_1#1968 AS C_15#1984, C_9#1969 AS C_20#1985, C_2#1970 AS C_22#1986, C_10#1971 AS C_25#1987, C_11#1972 AS C_24#1988, C_5#1965 AS C_19#1989]
+- SubqueryAlias C_4954424c
+- Project [id#1990 AS C_4#1960, type#1991 AS C_6#1961, name#1992 AS C_7#1962, lat#1993 AS C_43#1963, lon#1994 AS C_3#1964, elev#1995 AS C_5#1965, continent#1996 AS C_0#1966, country#1997 AS C_8#1967, region#1998 AS C_1#1968, city#1999 AS C_9#1969, iata#2000 AS C_2#1970, code#2001 AS C_10#1971, gps#2002 AS C_11#1972, (round((lat#1993 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#1973, (round((lon#1994 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#1974, (round((elev#1995 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#1975]
+- Filter (((lon#1994 <= -104.05) AND (lon#1994 >= -111.05)) AND ((lat#1993 >= 41.0) AND (lat#1993 <= 45.0)))
+- SubqueryAlias C_64656661756c745f616972706f727473
+- SubqueryAlias spark_catalog.default.airports
+- Relation spark_catalog.default.airports[id#1990,type#1991,name#1992,lat#1993,lon#1994,elev#1995,continent#1996,country#1997,region#1998,city#1999,iata#2000,code#2001,gps#2002] parquet
== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
+- Sort [C_19#1989 DESC NULLS LAST], true
+- Project [id#1990 AS C_17#1976, type#1991 AS C_13#1977, name#1992 AS C_18#1978, (round((lat#1993 * 1000.0), 0) / 1000.0) AS C_21#1979, (round((lon#1994 * 1000.0), 0) / 1000.0) AS C_16#1980, (round((elev#1995 * 1000.0), 0) / 1000.0) AS C_14#1981, continent#1996 AS C_12#1982, country#1997 AS C_23#1983, region#1998 AS C_15#1984, city#1999 AS C_20#1985, iata#2000 AS C_22#1986, code#2001 AS C_25#1987, gps#2002 AS C_24#1988, elev#1995 AS C_19#1989]
+- Filter ((isnotnull(lon#1994) AND isnotnull(lat#1993)) AND (((lon#1994 <= -104.05) AND (lon#1994 >= -111.05)) AND ((lat#1993 >= 41.0) AND (lat#1993 <= 45.0))))
+- Relation spark_catalog.default.airports[id#1990,type#1991,name#1992,lat#1993,lon#1994,elev#1995,continent#1996,country#1997,region#1998,city#1999,iata#2000,code#2001,gps#2002] parquet
== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_19#1989 DESC NULLS LAST], output=[C_17#1976,C_13#1977,C_18#1978,C_21#1979,C_16#1980,C_14#1981,C_12#1982,C_23#1983,C_15#1984,C_20#1985,C_22#1986,C_25#1987,C_24#1988,C_19#1989])
+- *(1) Project [id#1990 AS C_17#1976, type#1991 AS C_13#1977, name#1992 AS C_18#1978, (round((lat#1993 * 1000.0), 0) / 1000.0) AS C_21#1979, (round((lon#1994 * 1000.0), 0) / 1000.0) AS C_16#1980, (round((elev#1995 * 1000.0), 0) / 1000.0) AS C_14#1981, continent#1996 AS C_12#1982, country#1997 AS C_23#1983, region#1998 AS C_15#1984, city#1999 AS C_20#1985, iata#2000 AS C_22#1986, code#2001 AS C_25#1987, gps#2002 AS C_24#1988, elev#1995 AS C_19#1989]
+- *(1) Filter (((((isnotnull(lon#1994) AND isnotnull(lat#1993)) AND (lon#1994 <= -104.05)) AND (lon#1994 >= -111.05)) AND (lat#1993 >= 41.0)) AND (lat#1993 <= 45.0))
+- *(1) ColumnarToRow
+- FileScan parquet spark_catalog.default.airports[id#1990,type#1991,name#1992,lat#1993,lon#1994,elev#1995,continent#1996,country#1997,region#1998,city#1999,iata#2000,code#2001,gps#2002] Batched: true, DataFilters: [isnotnull(lon#1994), isnotnull(lat#1993), (lon#1994 <= -104.05), (lon#1994 >= -111.05), (lat#199..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/home/acdcadmin/spark-warehouse/airports], PartitionFilters: [], PushedFilters: [IsNotNull(lon), IsNotNull(lat), LessThanOrEqual(lon,-104.05), GreaterThanOrEqual(lon,-111.05), G..., ReadSchema: struct<id:string,type:string,name:string,lat:double,lon:double,elev:double,continent:string,count...
|
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
== Parsed Logical Plan ==
'DescribeRelation false, [col_name#1937, data_type#1938, comment#1939]
+- 'UnresolvedTableOrView [default, airports], DESCRIBE TABLE, true
== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#1937, data_type#1938, comment#1939]
== Optimized Logical Plan ==
CommandResult [col_name#1937, data_type#1938, comment#1939], Execute DescribeTableCommand, [[id,string,null], [type,string,null], [name,string,null], [lat,double,null], [lon,double,null], [elev,double,null], [continent,string,null], [country,string,null], [region,string,null], [city,string,null], [iata,string,null], [code,string,null], [gps,string,null]]
+- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#1937, data_type#1938, comment#1939]
== Physical Plan ==
CommandResult [col_name#1937, data_type#1938, comment#1939]
+- Execute DescribeTableCommand
+- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#1937, data_type#1938, comment#1939]
|