== 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_21 DESC NULLS LAST], true
      +- 'Project ['C_3 AS C_18#2516, 'C_0 AS C_12#2517, 'C_4 AS C_19#2518, 'C_4331 AS C_14#2519, 'C_4332 AS C_17#2520, 'C_4333 AS C_22#2521, 'C_7 AS C_23#2522, 'C_8 AS C_15#2523, 'C_9 AS C_20#2524, 'C_10 AS C_16#2525, 'C_43 AS C_25#2526, 'C_2 AS C_13#2527, 'C_11 AS C_24#2528, 'C_1 AS C_21#2529]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_3#2500, 'C_64656661756c745f616972706f727473.type AS C_0#2501, 'C_64656661756c745f616972706f727473.name AS C_4#2502, 'C_64656661756c745f616972706f727473.lat AS C_5#2503, 'C_64656661756c745f616972706f727473.lon AS C_6#2504, 'C_64656661756c745f616972706f727473.elev AS C_1#2505, 'C_64656661756c745f616972706f727473.continent AS C_7#2506, 'C_64656661756c745f616972706f727473.country AS C_8#2507, 'C_64656661756c745f616972706f727473.region AS C_9#2508, 'C_64656661756c745f616972706f727473.city AS C_10#2509, 'C_64656661756c745f616972706f727473.iata AS C_43#2510, 'C_64656661756c745f616972706f727473.code AS C_2#2511, 'C_64656661756c745f616972706f727473.gps AS C_11#2512, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#2513, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#2514, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#2515]
               +- '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_18: string, C_12: string, C_19: string, C_14: double, C_17: double, C_22: double, C_23: string, C_15: string, C_20: string, C_16: string, C_25: string, C_13: string, C_24: string, C_21: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_21#2529 DESC NULLS LAST], true
      +- Project [C_3#2500 AS C_18#2516, C_0#2501 AS C_12#2517, C_4#2502 AS C_19#2518, C_4331#2513 AS C_14#2519, C_4332#2514 AS C_17#2520, C_4333#2515 AS C_22#2521, C_7#2506 AS C_23#2522, C_8#2507 AS C_15#2523, C_9#2508 AS C_20#2524, C_10#2509 AS C_16#2525, C_43#2510 AS C_25#2526, C_2#2511 AS C_13#2527, C_11#2512 AS C_24#2528, C_1#2505 AS C_21#2529]
         +- SubqueryAlias C_4954424c
            +- Project [id#2530 AS C_3#2500, type#2531 AS C_0#2501, name#2532 AS C_4#2502, lat#2533 AS C_5#2503, lon#2534 AS C_6#2504, elev#2535 AS C_1#2505, continent#2536 AS C_7#2506, country#2537 AS C_8#2507, region#2538 AS C_9#2508, city#2539 AS C_10#2509, iata#2540 AS C_43#2510, code#2541 AS C_2#2511, gps#2542 AS C_11#2512, (round((lat#2533 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#2513, (round((lon#2534 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#2514, (round((elev#2535 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#2515]
               +- Filter (((lon#2534 <= -104.05) AND (lon#2534 >= -111.05)) AND ((lat#2533 >= 41.0) AND (lat#2533 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#2530,type#2531,name#2532,lat#2533,lon#2534,elev#2535,continent#2536,country#2537,region#2538,city#2539,iata#2540,code#2541,gps#2542] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_21#2529 DESC NULLS LAST], true
      +- Project [id#2530 AS C_18#2516, type#2531 AS C_12#2517, name#2532 AS C_19#2518, (round((lat#2533 * 1000.0), 0) / 1000.0) AS C_14#2519, (round((lon#2534 * 1000.0), 0) / 1000.0) AS C_17#2520, (round((elev#2535 * 1000.0), 0) / 1000.0) AS C_22#2521, continent#2536 AS C_23#2522, country#2537 AS C_15#2523, region#2538 AS C_20#2524, city#2539 AS C_16#2525, iata#2540 AS C_25#2526, code#2541 AS C_13#2527, gps#2542 AS C_24#2528, elev#2535 AS C_21#2529]
         +- Filter ((isnotnull(lon#2534) AND isnotnull(lat#2533)) AND (((lon#2534 <= -104.05) AND (lon#2534 >= -111.05)) AND ((lat#2533 >= 41.0) AND (lat#2533 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#2530,type#2531,name#2532,lat#2533,lon#2534,elev#2535,continent#2536,country#2537,region#2538,city#2539,iata#2540,code#2541,gps#2542] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_21#2529 DESC NULLS LAST], output=[C_18#2516,C_12#2517,C_19#2518,C_14#2519,C_17#2520,C_22#2521,C_23#2522,C_15#2523,C_20#2524,C_16#2525,C_25#2526,C_13#2527,C_24#2528,C_21#2529])
+- *(1) Project [id#2530 AS C_18#2516, type#2531 AS C_12#2517, name#2532 AS C_19#2518, (round((lat#2533 * 1000.0), 0) / 1000.0) AS C_14#2519, (round((lon#2534 * 1000.0), 0) / 1000.0) AS C_17#2520, (round((elev#2535 * 1000.0), 0) / 1000.0) AS C_22#2521, continent#2536 AS C_23#2522, country#2537 AS C_15#2523, region#2538 AS C_20#2524, city#2539 AS C_16#2525, iata#2540 AS C_25#2526, code#2541 AS C_13#2527, gps#2542 AS C_24#2528, elev#2535 AS C_21#2529]
   +- *(1) Filter (((((isnotnull(lon#2534) AND isnotnull(lat#2533)) AND (lon#2534 <= -104.05)) AND (lon#2534 >= -111.05)) AND (lat#2533 >= 41.0)) AND (lat#2533 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#2530,type#2531,name#2532,lat#2533,lon#2534,elev#2535,continent#2536,country#2537,region#2538,city#2539,iata#2540,code#2541,gps#2542] Batched: true, DataFilters: [isnotnull(lon#2534), isnotnull(lat#2533), (lon#2534 <= -104.05), (lon#2534 >= -111.05), (lat#253..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_24 DESC NULLS LAST], true
      +- 'Project ['C_43 AS C_21#5078, 'C_0 AS C_12#5079, 'C_1 AS C_17#5080, 'C_4331 AS C_16#5081, 'C_4332 AS C_25#5082, 'C_4333 AS C_23#5083, 'C_4 AS C_19#5084, 'C_5 AS C_20#5085, 'C_7 AS C_14#5086, 'C_8 AS C_18#5087, 'C_9 AS C_22#5088, 'C_11 AS C_15#5089, 'C_10 AS C_13#5090, 'C_3 AS C_24#5091]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_43#5062, 'C_64656661756c745f616972706f727473.type AS C_0#5063, 'C_64656661756c745f616972706f727473.name AS C_1#5064, 'C_64656661756c745f616972706f727473.lat AS C_2#5065, 'C_64656661756c745f616972706f727473.lon AS C_6#5066, 'C_64656661756c745f616972706f727473.elev AS C_3#5067, 'C_64656661756c745f616972706f727473.continent AS C_4#5068, 'C_64656661756c745f616972706f727473.country AS C_5#5069, 'C_64656661756c745f616972706f727473.region AS C_7#5070, 'C_64656661756c745f616972706f727473.city AS C_8#5071, 'C_64656661756c745f616972706f727473.iata AS C_9#5072, 'C_64656661756c745f616972706f727473.code AS C_11#5073, 'C_64656661756c745f616972706f727473.gps AS C_10#5074, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#5075, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#5076, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#5077]
               +- '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_21: string, C_12: string, C_17: string, C_16: double, C_25: double, C_23: double, C_19: string, C_20: string, C_14: string, C_18: string, C_22: string, C_15: string, C_13: string, C_24: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#5091 DESC NULLS LAST], true
      +- Project [C_43#5062 AS C_21#5078, C_0#5063 AS C_12#5079, C_1#5064 AS C_17#5080, C_4331#5075 AS C_16#5081, C_4332#5076 AS C_25#5082, C_4333#5077 AS C_23#5083, C_4#5068 AS C_19#5084, C_5#5069 AS C_20#5085, C_7#5070 AS C_14#5086, C_8#5071 AS C_18#5087, C_9#5072 AS C_22#5088, C_11#5073 AS C_15#5089, C_10#5074 AS C_13#5090, C_3#5067 AS C_24#5091]
         +- SubqueryAlias C_4954424c
            +- Project [id#5092 AS C_43#5062, type#5093 AS C_0#5063, name#5094 AS C_1#5064, lat#5095 AS C_2#5065, lon#5096 AS C_6#5066, elev#5097 AS C_3#5067, continent#5098 AS C_4#5068, country#5099 AS C_5#5069, region#5100 AS C_7#5070, city#5101 AS C_8#5071, iata#5102 AS C_9#5072, code#5103 AS C_11#5073, gps#5104 AS C_10#5074, (round((lat#5095 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#5075, (round((lon#5096 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#5076, (round((elev#5097 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#5077]
               +- Filter (((lon#5096 <= -104.05) AND (lon#5096 >= -111.05)) AND ((lat#5095 >= 41.0) AND (lat#5095 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#5092,type#5093,name#5094,lat#5095,lon#5096,elev#5097,continent#5098,country#5099,region#5100,city#5101,iata#5102,code#5103,gps#5104] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#5091 DESC NULLS LAST], true
      +- Project [id#5092 AS C_21#5078, type#5093 AS C_12#5079, name#5094 AS C_17#5080, (round((lat#5095 * 1000.0), 0) / 1000.0) AS C_16#5081, (round((lon#5096 * 1000.0), 0) / 1000.0) AS C_25#5082, (round((elev#5097 * 1000.0), 0) / 1000.0) AS C_23#5083, continent#5098 AS C_19#5084, country#5099 AS C_20#5085, region#5100 AS C_14#5086, city#5101 AS C_18#5087, iata#5102 AS C_22#5088, code#5103 AS C_15#5089, gps#5104 AS C_13#5090, elev#5097 AS C_24#5091]
         +- Filter ((isnotnull(lon#5096) AND isnotnull(lat#5095)) AND (((lon#5096 <= -104.05) AND (lon#5096 >= -111.05)) AND ((lat#5095 >= 41.0) AND (lat#5095 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#5092,type#5093,name#5094,lat#5095,lon#5096,elev#5097,continent#5098,country#5099,region#5100,city#5101,iata#5102,code#5103,gps#5104] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_24#5091 DESC NULLS LAST], output=[C_21#5078,C_12#5079,C_17#5080,C_16#5081,C_25#5082,C_23#5083,C_19#5084,C_20#5085,C_14#5086,C_18#5087,C_22#5088,C_15#5089,C_13#5090,C_24#5091])
+- *(1) Project [id#5092 AS C_21#5078, type#5093 AS C_12#5079, name#5094 AS C_17#5080, (round((lat#5095 * 1000.0), 0) / 1000.0) AS C_16#5081, (round((lon#5096 * 1000.0), 0) / 1000.0) AS C_25#5082, (round((elev#5097 * 1000.0), 0) / 1000.0) AS C_23#5083, continent#5098 AS C_19#5084, country#5099 AS C_20#5085, region#5100 AS C_14#5086, city#5101 AS C_18#5087, iata#5102 AS C_22#5088, code#5103 AS C_15#5089, gps#5104 AS C_13#5090, elev#5097 AS C_24#5091]
   +- *(1) Filter (((((isnotnull(lon#5096) AND isnotnull(lat#5095)) AND (lon#5096 <= -104.05)) AND (lon#5096 >= -111.05)) AND (lat#5095 >= 41.0)) AND (lat#5095 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#5092,type#5093,name#5094,lat#5095,lon#5096,elev#5097,continent#5098,country#5099,region#5100,city#5101,iata#5102,code#5103,gps#5104] Batched: true, DataFilters: [isnotnull(lon#5096), isnotnull(lat#5095), (lon#5096 <= -104.05), (lon#5096 >= -111.05), (lat#509..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_17 DESC NULLS LAST], true
      +- 'Project ['C_10 AS C_13#5222, 'C_43 AS C_18#5223, 'C_4 AS C_23#5224, 'C_4331 AS C_16#5225, 'C_4332 AS C_21#5226, 'C_4333 AS C_22#5227, 'C_7 AS C_20#5228, 'C_2 AS C_15#5229, 'C_5 AS C_25#5230, 'C_8 AS C_12#5231, 'C_9 AS C_24#5232, 'C_3 AS C_14#5233, 'C_11 AS C_19#5234, 'C_1 AS C_17#5235]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_10#5206, 'C_64656661756c745f616972706f727473.type AS C_43#5207, 'C_64656661756c745f616972706f727473.name AS C_4#5208, 'C_64656661756c745f616972706f727473.lat AS C_0#5209, 'C_64656661756c745f616972706f727473.lon AS C_6#5210, 'C_64656661756c745f616972706f727473.elev AS C_1#5211, 'C_64656661756c745f616972706f727473.continent AS C_7#5212, 'C_64656661756c745f616972706f727473.country AS C_2#5213, 'C_64656661756c745f616972706f727473.region AS C_5#5214, 'C_64656661756c745f616972706f727473.city AS C_8#5215, 'C_64656661756c745f616972706f727473.iata AS C_9#5216, 'C_64656661756c745f616972706f727473.code AS C_3#5217, 'C_64656661756c745f616972706f727473.gps AS C_11#5218, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#5219, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#5220, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#5221]
               +- '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_13: string, C_18: string, C_23: string, C_16: double, C_21: double, C_22: double, C_20: string, C_15: string, C_25: string, C_12: string, C_24: string, C_14: string, C_19: string, C_17: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_17#5235 DESC NULLS LAST], true
      +- Project [C_10#5206 AS C_13#5222, C_43#5207 AS C_18#5223, C_4#5208 AS C_23#5224, C_4331#5219 AS C_16#5225, C_4332#5220 AS C_21#5226, C_4333#5221 AS C_22#5227, C_7#5212 AS C_20#5228, C_2#5213 AS C_15#5229, C_5#5214 AS C_25#5230, C_8#5215 AS C_12#5231, C_9#5216 AS C_24#5232, C_3#5217 AS C_14#5233, C_11#5218 AS C_19#5234, C_1#5211 AS C_17#5235]
         +- SubqueryAlias C_4954424c
            +- Project [id#5236 AS C_10#5206, type#5237 AS C_43#5207, name#5238 AS C_4#5208, lat#5239 AS C_0#5209, lon#5240 AS C_6#5210, elev#5241 AS C_1#5211, continent#5242 AS C_7#5212, country#5243 AS C_2#5213, region#5244 AS C_5#5214, city#5245 AS C_8#5215, iata#5246 AS C_9#5216, code#5247 AS C_3#5217, gps#5248 AS C_11#5218, (round((lat#5239 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#5219, (round((lon#5240 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#5220, (round((elev#5241 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#5221]
               +- Filter (((lon#5240 <= -104.05) AND (lon#5240 >= -111.05)) AND ((lat#5239 >= 41.0) AND (lat#5239 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#5236,type#5237,name#5238,lat#5239,lon#5240,elev#5241,continent#5242,country#5243,region#5244,city#5245,iata#5246,code#5247,gps#5248] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_17#5235 DESC NULLS LAST], true
      +- Project [id#5236 AS C_13#5222, type#5237 AS C_18#5223, name#5238 AS C_23#5224, (round((lat#5239 * 1000.0), 0) / 1000.0) AS C_16#5225, (round((lon#5240 * 1000.0), 0) / 1000.0) AS C_21#5226, (round((elev#5241 * 1000.0), 0) / 1000.0) AS C_22#5227, continent#5242 AS C_20#5228, country#5243 AS C_15#5229, region#5244 AS C_25#5230, city#5245 AS C_12#5231, iata#5246 AS C_24#5232, code#5247 AS C_14#5233, gps#5248 AS C_19#5234, elev#5241 AS C_17#5235]
         +- Filter ((isnotnull(lon#5240) AND isnotnull(lat#5239)) AND (((lon#5240 <= -104.05) AND (lon#5240 >= -111.05)) AND ((lat#5239 >= 41.0) AND (lat#5239 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#5236,type#5237,name#5238,lat#5239,lon#5240,elev#5241,continent#5242,country#5243,region#5244,city#5245,iata#5246,code#5247,gps#5248] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_17#5235 DESC NULLS LAST], output=[C_13#5222,C_18#5223,C_23#5224,C_16#5225,C_21#5226,C_22#5227,C_20#5228,C_15#5229,C_25#5230,C_12#5231,C_24#5232,C_14#5233,C_19#5234,C_17#5235])
+- *(1) Project [id#5236 AS C_13#5222, type#5237 AS C_18#5223, name#5238 AS C_23#5224, (round((lat#5239 * 1000.0), 0) / 1000.0) AS C_16#5225, (round((lon#5240 * 1000.0), 0) / 1000.0) AS C_21#5226, (round((elev#5241 * 1000.0), 0) / 1000.0) AS C_22#5227, continent#5242 AS C_20#5228, country#5243 AS C_15#5229, region#5244 AS C_25#5230, city#5245 AS C_12#5231, iata#5246 AS C_24#5232, code#5247 AS C_14#5233, gps#5248 AS C_19#5234, elev#5241 AS C_17#5235]
   +- *(1) Filter (((((isnotnull(lon#5240) AND isnotnull(lat#5239)) AND (lon#5240 <= -104.05)) AND (lon#5240 >= -111.05)) AND (lat#5239 >= 41.0)) AND (lat#5239 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#5236,type#5237,name#5238,lat#5239,lon#5240,elev#5241,continent#5242,country#5243,region#5244,city#5245,iata#5246,code#5247,gps#5248] Batched: true, DataFilters: [isnotnull(lon#5240), isnotnull(lat#5239), (lon#5240 <= -104.05), (lon#5240 >= -111.05), (lat#523..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_24 DESC NULLS LAST], true
      +- 'Project ['C_0 AS C_14#4502, 'C_1 AS C_13#4503, 'C_43 AS C_12#4504, 'C_4331 AS C_18#4505, 'C_4332 AS C_20#4506, 'C_4333 AS C_16#4507, 'C_6 AS C_19#4508, 'C_8 AS C_17#4509, 'C_5 AS C_15#4510, 'C_7 AS C_22#4511, 'C_9 AS C_25#4512, 'C_11 AS C_23#4513, 'C_10 AS C_21#4514, 'C_3 AS C_24#4515]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_0#4486, 'C_64656661756c745f616972706f727473.type AS C_1#4487, 'C_64656661756c745f616972706f727473.name AS C_43#4488, 'C_64656661756c745f616972706f727473.lat AS C_2#4489, 'C_64656661756c745f616972706f727473.lon AS C_4#4490, 'C_64656661756c745f616972706f727473.elev AS C_3#4491, 'C_64656661756c745f616972706f727473.continent AS C_6#4492, 'C_64656661756c745f616972706f727473.country AS C_8#4493, 'C_64656661756c745f616972706f727473.region AS C_5#4494, 'C_64656661756c745f616972706f727473.city AS C_7#4495, 'C_64656661756c745f616972706f727473.iata AS C_9#4496, 'C_64656661756c745f616972706f727473.code AS C_11#4497, 'C_64656661756c745f616972706f727473.gps AS C_10#4498, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#4499, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#4500, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#4501]
               +- '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_14: string, C_13: string, C_12: string, C_18: double, C_20: double, C_16: double, C_19: string, C_17: string, C_15: string, C_22: string, C_25: string, C_23: string, C_21: string, C_24: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#4515 DESC NULLS LAST], true
      +- Project [C_0#4486 AS C_14#4502, C_1#4487 AS C_13#4503, C_43#4488 AS C_12#4504, C_4331#4499 AS C_18#4505, C_4332#4500 AS C_20#4506, C_4333#4501 AS C_16#4507, C_6#4492 AS C_19#4508, C_8#4493 AS C_17#4509, C_5#4494 AS C_15#4510, C_7#4495 AS C_22#4511, C_9#4496 AS C_25#4512, C_11#4497 AS C_23#4513, C_10#4498 AS C_21#4514, C_3#4491 AS C_24#4515]
         +- SubqueryAlias C_4954424c
            +- Project [id#4516 AS C_0#4486, type#4517 AS C_1#4487, name#4518 AS C_43#4488, lat#4519 AS C_2#4489, lon#4520 AS C_4#4490, elev#4521 AS C_3#4491, continent#4522 AS C_6#4492, country#4523 AS C_8#4493, region#4524 AS C_5#4494, city#4525 AS C_7#4495, iata#4526 AS C_9#4496, code#4527 AS C_11#4497, gps#4528 AS C_10#4498, (round((lat#4519 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#4499, (round((lon#4520 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#4500, (round((elev#4521 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#4501]
               +- Filter (((lon#4520 <= -104.05) AND (lon#4520 >= -111.05)) AND ((lat#4519 >= 41.0) AND (lat#4519 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#4516,type#4517,name#4518,lat#4519,lon#4520,elev#4521,continent#4522,country#4523,region#4524,city#4525,iata#4526,code#4527,gps#4528] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#4515 DESC NULLS LAST], true
      +- Project [id#4516 AS C_14#4502, type#4517 AS C_13#4503, name#4518 AS C_12#4504, (round((lat#4519 * 1000.0), 0) / 1000.0) AS C_18#4505, (round((lon#4520 * 1000.0), 0) / 1000.0) AS C_20#4506, (round((elev#4521 * 1000.0), 0) / 1000.0) AS C_16#4507, continent#4522 AS C_19#4508, country#4523 AS C_17#4509, region#4524 AS C_15#4510, city#4525 AS C_22#4511, iata#4526 AS C_25#4512, code#4527 AS C_23#4513, gps#4528 AS C_21#4514, elev#4521 AS C_24#4515]
         +- Filter ((isnotnull(lon#4520) AND isnotnull(lat#4519)) AND (((lon#4520 <= -104.05) AND (lon#4520 >= -111.05)) AND ((lat#4519 >= 41.0) AND (lat#4519 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#4516,type#4517,name#4518,lat#4519,lon#4520,elev#4521,continent#4522,country#4523,region#4524,city#4525,iata#4526,code#4527,gps#4528] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_24#4515 DESC NULLS LAST], output=[C_14#4502,C_13#4503,C_12#4504,C_18#4505,C_20#4506,C_16#4507,C_19#4508,C_17#4509,C_15#4510,C_22#4511,C_25#4512,C_23#4513,C_21#4514,C_24#4515])
+- *(1) Project [id#4516 AS C_14#4502, type#4517 AS C_13#4503, name#4518 AS C_12#4504, (round((lat#4519 * 1000.0), 0) / 1000.0) AS C_18#4505, (round((lon#4520 * 1000.0), 0) / 1000.0) AS C_20#4506, (round((elev#4521 * 1000.0), 0) / 1000.0) AS C_16#4507, continent#4522 AS C_19#4508, country#4523 AS C_17#4509, region#4524 AS C_15#4510, city#4525 AS C_22#4511, iata#4526 AS C_25#4512, code#4527 AS C_23#4513, gps#4528 AS C_21#4514, elev#4521 AS C_24#4515]
   +- *(1) Filter (((((isnotnull(lon#4520) AND isnotnull(lat#4519)) AND (lon#4520 <= -104.05)) AND (lon#4520 >= -111.05)) AND (lat#4519 >= 41.0)) AND (lat#4519 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#4516,type#4517,name#4518,lat#4519,lon#4520,elev#4521,continent#4522,country#4523,region#4524,city#4525,iata#4526,code#4527,gps#4528] Batched: true, DataFilters: [isnotnull(lon#4520), isnotnull(lat#4519), (lon#4520 <= -104.05), (lon#4520 >= -111.05), (lat#451..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_25 DESC NULLS LAST], true
      +- 'Project ['C_43 AS C_12#4934, 'C_4 AS C_13#4935, 'C_1 AS C_17#4936, 'C_4331 AS C_19#4937, 'C_4332 AS C_18#4938, 'C_4333 AS C_16#4939, 'C_6 AS C_15#4940, 'C_8 AS C_14#4941, 'C_9 AS C_20#4942, 'C_7 AS C_23#4943, 'C_5 AS C_22#4944, 'C_10 AS C_21#4945, 'C_11 AS C_24#4946, 'C_0 AS C_25#4947]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_43#4918, 'C_64656661756c745f616972706f727473.type AS C_4#4919, 'C_64656661756c745f616972706f727473.name AS C_1#4920, 'C_64656661756c745f616972706f727473.lat AS C_2#4921, 'C_64656661756c745f616972706f727473.lon AS C_3#4922, 'C_64656661756c745f616972706f727473.elev AS C_0#4923, 'C_64656661756c745f616972706f727473.continent AS C_6#4924, 'C_64656661756c745f616972706f727473.country AS C_8#4925, 'C_64656661756c745f616972706f727473.region AS C_9#4926, 'C_64656661756c745f616972706f727473.city AS C_7#4927, 'C_64656661756c745f616972706f727473.iata AS C_5#4928, 'C_64656661756c745f616972706f727473.code AS C_10#4929, 'C_64656661756c745f616972706f727473.gps AS C_11#4930, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#4931, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#4932, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#4933]
               +- '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_12: string, C_13: string, C_17: string, C_19: double, C_18: double, C_16: double, C_15: string, C_14: string, C_20: string, C_23: string, C_22: string, C_21: string, C_24: string, C_25: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#4947 DESC NULLS LAST], true
      +- Project [C_43#4918 AS C_12#4934, C_4#4919 AS C_13#4935, C_1#4920 AS C_17#4936, C_4331#4931 AS C_19#4937, C_4332#4932 AS C_18#4938, C_4333#4933 AS C_16#4939, C_6#4924 AS C_15#4940, C_8#4925 AS C_14#4941, C_9#4926 AS C_20#4942, C_7#4927 AS C_23#4943, C_5#4928 AS C_22#4944, C_10#4929 AS C_21#4945, C_11#4930 AS C_24#4946, C_0#4923 AS C_25#4947]
         +- SubqueryAlias C_4954424c
            +- Project [id#4948 AS C_43#4918, type#4949 AS C_4#4919, name#4950 AS C_1#4920, lat#4951 AS C_2#4921, lon#4952 AS C_3#4922, elev#4953 AS C_0#4923, continent#4954 AS C_6#4924, country#4955 AS C_8#4925, region#4956 AS C_9#4926, city#4957 AS C_7#4927, iata#4958 AS C_5#4928, code#4959 AS C_10#4929, gps#4960 AS C_11#4930, (round((lat#4951 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#4931, (round((lon#4952 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#4932, (round((elev#4953 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#4933]
               +- Filter (((lon#4952 <= -104.05) AND (lon#4952 >= -111.05)) AND ((lat#4951 >= 41.0) AND (lat#4951 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#4948,type#4949,name#4950,lat#4951,lon#4952,elev#4953,continent#4954,country#4955,region#4956,city#4957,iata#4958,code#4959,gps#4960] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#4947 DESC NULLS LAST], true
      +- Project [id#4948 AS C_12#4934, type#4949 AS C_13#4935, name#4950 AS C_17#4936, (round((lat#4951 * 1000.0), 0) / 1000.0) AS C_19#4937, (round((lon#4952 * 1000.0), 0) / 1000.0) AS C_18#4938, (round((elev#4953 * 1000.0), 0) / 1000.0) AS C_16#4939, continent#4954 AS C_15#4940, country#4955 AS C_14#4941, region#4956 AS C_20#4942, city#4957 AS C_23#4943, iata#4958 AS C_22#4944, code#4959 AS C_21#4945, gps#4960 AS C_24#4946, elev#4953 AS C_25#4947]
         +- Filter ((isnotnull(lon#4952) AND isnotnull(lat#4951)) AND (((lon#4952 <= -104.05) AND (lon#4952 >= -111.05)) AND ((lat#4951 >= 41.0) AND (lat#4951 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#4948,type#4949,name#4950,lat#4951,lon#4952,elev#4953,continent#4954,country#4955,region#4956,city#4957,iata#4958,code#4959,gps#4960] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_25#4947 DESC NULLS LAST], output=[C_12#4934,C_13#4935,C_17#4936,C_19#4937,C_18#4938,C_16#4939,C_15#4940,C_14#4941,C_20#4942,C_23#4943,C_22#4944,C_21#4945,C_24#4946,C_25#4947])
+- *(1) Project [id#4948 AS C_12#4934, type#4949 AS C_13#4935, name#4950 AS C_17#4936, (round((lat#4951 * 1000.0), 0) / 1000.0) AS C_19#4937, (round((lon#4952 * 1000.0), 0) / 1000.0) AS C_18#4938, (round((elev#4953 * 1000.0), 0) / 1000.0) AS C_16#4939, continent#4954 AS C_15#4940, country#4955 AS C_14#4941, region#4956 AS C_20#4942, city#4957 AS C_23#4943, iata#4958 AS C_22#4944, code#4959 AS C_21#4945, gps#4960 AS C_24#4946, elev#4953 AS C_25#4947]
   +- *(1) Filter (((((isnotnull(lon#4952) AND isnotnull(lat#4951)) AND (lon#4952 <= -104.05)) AND (lon#4952 >= -111.05)) AND (lat#4951 >= 41.0)) AND (lat#4951 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#4948,type#4949,name#4950,lat#4951,lon#4952,elev#4953,continent#4954,country#4955,region#4956,city#4957,iata#4958,code#4959,gps#4960] Batched: true, DataFilters: [isnotnull(lon#4952), isnotnull(lat#4951), (lon#4952 <= -104.05), (lon#4952 >= -111.05), (lat#495..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_15 DESC NULLS LAST], true
      +- 'Project ['C_43 AS C_13#5366, 'C_0 AS C_12#5367, 'C_8 AS C_18#5368, 'C_4331 AS C_21#5369, 'C_4332 AS C_17#5370, 'C_4333 AS C_20#5371, 'C_4 AS C_22#5372, 'C_5 AS C_25#5373, 'C_6 AS C_23#5374, 'C_7 AS C_14#5375, 'C_9 AS C_24#5376, 'C_11 AS C_16#5377, 'C_10 AS C_19#5378, 'C_2 AS C_15#5379]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_43#5350, 'C_64656661756c745f616972706f727473.type AS C_0#5351, 'C_64656661756c745f616972706f727473.name AS C_8#5352, 'C_64656661756c745f616972706f727473.lat AS C_3#5353, 'C_64656661756c745f616972706f727473.lon AS C_1#5354, 'C_64656661756c745f616972706f727473.elev AS C_2#5355, 'C_64656661756c745f616972706f727473.continent AS C_4#5356, 'C_64656661756c745f616972706f727473.country AS C_5#5357, 'C_64656661756c745f616972706f727473.region AS C_6#5358, 'C_64656661756c745f616972706f727473.city AS C_7#5359, 'C_64656661756c745f616972706f727473.iata AS C_9#5360, 'C_64656661756c745f616972706f727473.code AS C_11#5361, 'C_64656661756c745f616972706f727473.gps AS C_10#5362, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#5363, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#5364, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#5365]
               +- '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_13: string, C_12: string, C_18: string, C_21: double, C_17: double, C_20: double, C_22: string, C_25: string, C_23: string, C_14: string, C_24: string, C_16: string, C_19: string, C_15: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_15#5379 DESC NULLS LAST], true
      +- Project [C_43#5350 AS C_13#5366, C_0#5351 AS C_12#5367, C_8#5352 AS C_18#5368, C_4331#5363 AS C_21#5369, C_4332#5364 AS C_17#5370, C_4333#5365 AS C_20#5371, C_4#5356 AS C_22#5372, C_5#5357 AS C_25#5373, C_6#5358 AS C_23#5374, C_7#5359 AS C_14#5375, C_9#5360 AS C_24#5376, C_11#5361 AS C_16#5377, C_10#5362 AS C_19#5378, C_2#5355 AS C_15#5379]
         +- SubqueryAlias C_4954424c
            +- Project [id#5380 AS C_43#5350, type#5381 AS C_0#5351, name#5382 AS C_8#5352, lat#5383 AS C_3#5353, lon#5384 AS C_1#5354, elev#5385 AS C_2#5355, continent#5386 AS C_4#5356, country#5387 AS C_5#5357, region#5388 AS C_6#5358, city#5389 AS C_7#5359, iata#5390 AS C_9#5360, code#5391 AS C_11#5361, gps#5392 AS C_10#5362, (round((lat#5383 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#5363, (round((lon#5384 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#5364, (round((elev#5385 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#5365]
               +- Filter (((lon#5384 <= -104.05) AND (lon#5384 >= -111.05)) AND ((lat#5383 >= 41.0) AND (lat#5383 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#5380,type#5381,name#5382,lat#5383,lon#5384,elev#5385,continent#5386,country#5387,region#5388,city#5389,iata#5390,code#5391,gps#5392] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_15#5379 DESC NULLS LAST], true
      +- Project [id#5380 AS C_13#5366, type#5381 AS C_12#5367, name#5382 AS C_18#5368, (round((lat#5383 * 1000.0), 0) / 1000.0) AS C_21#5369, (round((lon#5384 * 1000.0), 0) / 1000.0) AS C_17#5370, (round((elev#5385 * 1000.0), 0) / 1000.0) AS C_20#5371, continent#5386 AS C_22#5372, country#5387 AS C_25#5373, region#5388 AS C_23#5374, city#5389 AS C_14#5375, iata#5390 AS C_24#5376, code#5391 AS C_16#5377, gps#5392 AS C_19#5378, elev#5385 AS C_15#5379]
         +- Filter ((isnotnull(lon#5384) AND isnotnull(lat#5383)) AND (((lon#5384 <= -104.05) AND (lon#5384 >= -111.05)) AND ((lat#5383 >= 41.0) AND (lat#5383 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#5380,type#5381,name#5382,lat#5383,lon#5384,elev#5385,continent#5386,country#5387,region#5388,city#5389,iata#5390,code#5391,gps#5392] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_15#5379 DESC NULLS LAST], output=[C_13#5366,C_12#5367,C_18#5368,C_21#5369,C_17#5370,C_20#5371,C_22#5372,C_25#5373,C_23#5374,C_14#5375,C_24#5376,C_16#5377,C_19#5378,C_15#5379])
+- *(1) Project [id#5380 AS C_13#5366, type#5381 AS C_12#5367, name#5382 AS C_18#5368, (round((lat#5383 * 1000.0), 0) / 1000.0) AS C_21#5369, (round((lon#5384 * 1000.0), 0) / 1000.0) AS C_17#5370, (round((elev#5385 * 1000.0), 0) / 1000.0) AS C_20#5371, continent#5386 AS C_22#5372, country#5387 AS C_25#5373, region#5388 AS C_23#5374, city#5389 AS C_14#5375, iata#5390 AS C_24#5376, code#5391 AS C_16#5377, gps#5392 AS C_19#5378, elev#5385 AS C_15#5379]
   +- *(1) Filter (((((isnotnull(lon#5384) AND isnotnull(lat#5383)) AND (lon#5384 <= -104.05)) AND (lon#5384 >= -111.05)) AND (lat#5383 >= 41.0)) AND (lat#5383 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#5380,type#5381,name#5382,lat#5383,lon#5384,elev#5385,continent#5386,country#5387,region#5388,city#5389,iata#5390,code#5391,gps#5392] Batched: true, DataFilters: [isnotnull(lon#5384), isnotnull(lat#5383), (lon#5384 <= -104.05), (lon#5384 >= -111.05), (lat#538..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_20 DESC NULLS LAST], true
      +- 'Project ['C_10 AS C_12#2120, 'C_2 AS C_14#2121, 'C_43 AS C_17#2122, 'C_4331 AS C_18#2123, 'C_4332 AS C_21#2124, 'C_4333 AS C_19#2125, 'C_9 AS C_23#2126, 'C_0 AS C_16#2127, 'C_3 AS C_15#2128, 'C_1 AS C_22#2129, 'C_4 AS C_13#2130, 'C_5 AS C_24#2131, 'C_11 AS C_25#2132, 'C_6 AS C_20#2133]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_10#2104, 'C_64656661756c745f616972706f727473.type AS C_2#2105, 'C_64656661756c745f616972706f727473.name AS C_43#2106, 'C_64656661756c745f616972706f727473.lat AS C_7#2107, 'C_64656661756c745f616972706f727473.lon AS C_8#2108, 'C_64656661756c745f616972706f727473.elev AS C_6#2109, 'C_64656661756c745f616972706f727473.continent AS C_9#2110, 'C_64656661756c745f616972706f727473.country AS C_0#2111, 'C_64656661756c745f616972706f727473.region AS C_3#2112, 'C_64656661756c745f616972706f727473.city AS C_1#2113, 'C_64656661756c745f616972706f727473.iata AS C_4#2114, 'C_64656661756c745f616972706f727473.code AS C_5#2115, 'C_64656661756c745f616972706f727473.gps AS C_11#2116, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#2117, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#2118, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#2119]
               +- '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_12: string, C_14: string, C_17: string, C_18: double, C_21: double, C_19: double, C_23: string, C_16: string, C_15: string, C_22: string, C_13: string, C_24: string, C_25: string, C_20: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_20#2133 DESC NULLS LAST], true
      +- Project [C_10#2104 AS C_12#2120, C_2#2105 AS C_14#2121, C_43#2106 AS C_17#2122, C_4331#2117 AS C_18#2123, C_4332#2118 AS C_21#2124, C_4333#2119 AS C_19#2125, C_9#2110 AS C_23#2126, C_0#2111 AS C_16#2127, C_3#2112 AS C_15#2128, C_1#2113 AS C_22#2129, C_4#2114 AS C_13#2130, C_5#2115 AS C_24#2131, C_11#2116 AS C_25#2132, C_6#2109 AS C_20#2133]
         +- SubqueryAlias C_4954424c
            +- Project [id#2134 AS C_10#2104, type#2135 AS C_2#2105, name#2136 AS C_43#2106, lat#2137 AS C_7#2107, lon#2138 AS C_8#2108, elev#2139 AS C_6#2109, continent#2140 AS C_9#2110, country#2141 AS C_0#2111, region#2142 AS C_3#2112, city#2143 AS C_1#2113, iata#2144 AS C_4#2114, code#2145 AS C_5#2115, gps#2146 AS C_11#2116, (round((lat#2137 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#2117, (round((lon#2138 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#2118, (round((elev#2139 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#2119]
               +- Filter (((lon#2138 <= -104.05) AND (lon#2138 >= -111.05)) AND ((lat#2137 >= 41.0) AND (lat#2137 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#2134,type#2135,name#2136,lat#2137,lon#2138,elev#2139,continent#2140,country#2141,region#2142,city#2143,iata#2144,code#2145,gps#2146] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_20#2133 DESC NULLS LAST], true
      +- Project [id#2134 AS C_12#2120, type#2135 AS C_14#2121, name#2136 AS C_17#2122, (round((lat#2137 * 1000.0), 0) / 1000.0) AS C_18#2123, (round((lon#2138 * 1000.0), 0) / 1000.0) AS C_21#2124, (round((elev#2139 * 1000.0), 0) / 1000.0) AS C_19#2125, continent#2140 AS C_23#2126, country#2141 AS C_16#2127, region#2142 AS C_15#2128, city#2143 AS C_22#2129, iata#2144 AS C_13#2130, code#2145 AS C_24#2131, gps#2146 AS C_25#2132, elev#2139 AS C_20#2133]
         +- Filter ((isnotnull(lon#2138) AND isnotnull(lat#2137)) AND (((lon#2138 <= -104.05) AND (lon#2138 >= -111.05)) AND ((lat#2137 >= 41.0) AND (lat#2137 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#2134,type#2135,name#2136,lat#2137,lon#2138,elev#2139,continent#2140,country#2141,region#2142,city#2143,iata#2144,code#2145,gps#2146] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_20#2133 DESC NULLS LAST], output=[C_12#2120,C_14#2121,C_17#2122,C_18#2123,C_21#2124,C_19#2125,C_23#2126,C_16#2127,C_15#2128,C_22#2129,C_13#2130,C_24#2131,C_25#2132,C_20#2133])
+- *(1) Project [id#2134 AS C_12#2120, type#2135 AS C_14#2121, name#2136 AS C_17#2122, (round((lat#2137 * 1000.0), 0) / 1000.0) AS C_18#2123, (round((lon#2138 * 1000.0), 0) / 1000.0) AS C_21#2124, (round((elev#2139 * 1000.0), 0) / 1000.0) AS C_19#2125, continent#2140 AS C_23#2126, country#2141 AS C_16#2127, region#2142 AS C_15#2128, city#2143 AS C_22#2129, iata#2144 AS C_13#2130, code#2145 AS C_24#2131, gps#2146 AS C_25#2132, elev#2139 AS C_20#2133]
   +- *(1) Filter (((((isnotnull(lon#2138) AND isnotnull(lat#2137)) AND (lon#2138 <= -104.05)) AND (lon#2138 >= -111.05)) AND (lat#2137 >= 41.0)) AND (lat#2137 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#2134,type#2135,name#2136,lat#2137,lon#2138,elev#2139,continent#2140,country#2141,region#2142,city#2143,iata#2144,code#2145,gps#2146] Batched: true, DataFilters: [isnotnull(lon#2138), isnotnull(lat#2137), (lon#2138 <= -104.05), (lon#2138 >= -111.05), (lat#213..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_25 DESC NULLS LAST], true
      +- 'Project ['C_43 AS C_12#2264, 'C_1 AS C_16#2265, 'C_2 AS C_14#2266, 'C_4331 AS C_17#2267, 'C_4332 AS C_13#2268, 'C_4333 AS C_15#2269, 'C_8 AS C_19#2270, 'C_9 AS C_21#2271, 'C_5 AS C_18#2272, 'C_6 AS C_20#2273, 'C_7 AS C_22#2274, 'C_10 AS C_24#2275, 'C_11 AS C_23#2276, 'C_3 AS C_25#2277]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_43#2248, 'C_64656661756c745f616972706f727473.type AS C_1#2249, 'C_64656661756c745f616972706f727473.name AS C_2#2250, 'C_64656661756c745f616972706f727473.lat AS C_4#2251, 'C_64656661756c745f616972706f727473.lon AS C_0#2252, 'C_64656661756c745f616972706f727473.elev AS C_3#2253, 'C_64656661756c745f616972706f727473.continent AS C_8#2254, 'C_64656661756c745f616972706f727473.country AS C_9#2255, 'C_64656661756c745f616972706f727473.region AS C_5#2256, 'C_64656661756c745f616972706f727473.city AS C_6#2257, 'C_64656661756c745f616972706f727473.iata AS C_7#2258, 'C_64656661756c745f616972706f727473.code AS C_10#2259, 'C_64656661756c745f616972706f727473.gps AS C_11#2260, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#2261, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#2262, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#2263]
               +- '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_12: string, C_16: string, C_14: string, C_17: double, C_13: double, C_15: double, C_19: string, C_21: string, C_18: string, C_20: string, C_22: string, C_24: string, C_23: string, C_25: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#2277 DESC NULLS LAST], true
      +- Project [C_43#2248 AS C_12#2264, C_1#2249 AS C_16#2265, C_2#2250 AS C_14#2266, C_4331#2261 AS C_17#2267, C_4332#2262 AS C_13#2268, C_4333#2263 AS C_15#2269, C_8#2254 AS C_19#2270, C_9#2255 AS C_21#2271, C_5#2256 AS C_18#2272, C_6#2257 AS C_20#2273, C_7#2258 AS C_22#2274, C_10#2259 AS C_24#2275, C_11#2260 AS C_23#2276, C_3#2253 AS C_25#2277]
         +- SubqueryAlias C_4954424c
            +- Project [id#2278 AS C_43#2248, type#2279 AS C_1#2249, name#2280 AS C_2#2250, lat#2281 AS C_4#2251, lon#2282 AS C_0#2252, elev#2283 AS C_3#2253, continent#2284 AS C_8#2254, country#2285 AS C_9#2255, region#2286 AS C_5#2256, city#2287 AS C_6#2257, iata#2288 AS C_7#2258, code#2289 AS C_10#2259, gps#2290 AS C_11#2260, (round((lat#2281 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#2261, (round((lon#2282 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#2262, (round((elev#2283 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#2263]
               +- Filter (((lon#2282 <= -104.05) AND (lon#2282 >= -111.05)) AND ((lat#2281 >= 41.0) AND (lat#2281 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#2278,type#2279,name#2280,lat#2281,lon#2282,elev#2283,continent#2284,country#2285,region#2286,city#2287,iata#2288,code#2289,gps#2290] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#2277 DESC NULLS LAST], true
      +- Project [id#2278 AS C_12#2264, type#2279 AS C_16#2265, name#2280 AS C_14#2266, (round((lat#2281 * 1000.0), 0) / 1000.0) AS C_17#2267, (round((lon#2282 * 1000.0), 0) / 1000.0) AS C_13#2268, (round((elev#2283 * 1000.0), 0) / 1000.0) AS C_15#2269, continent#2284 AS C_19#2270, country#2285 AS C_21#2271, region#2286 AS C_18#2272, city#2287 AS C_20#2273, iata#2288 AS C_22#2274, code#2289 AS C_24#2275, gps#2290 AS C_23#2276, elev#2283 AS C_25#2277]
         +- Filter ((isnotnull(lon#2282) AND isnotnull(lat#2281)) AND (((lon#2282 <= -104.05) AND (lon#2282 >= -111.05)) AND ((lat#2281 >= 41.0) AND (lat#2281 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#2278,type#2279,name#2280,lat#2281,lon#2282,elev#2283,continent#2284,country#2285,region#2286,city#2287,iata#2288,code#2289,gps#2290] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_25#2277 DESC NULLS LAST], output=[C_12#2264,C_16#2265,C_14#2266,C_17#2267,C_13#2268,C_15#2269,C_19#2270,C_21#2271,C_18#2272,C_20#2273,C_22#2274,C_24#2275,C_23#2276,C_25#2277])
+- *(1) Project [id#2278 AS C_12#2264, type#2279 AS C_16#2265, name#2280 AS C_14#2266, (round((lat#2281 * 1000.0), 0) / 1000.0) AS C_17#2267, (round((lon#2282 * 1000.0), 0) / 1000.0) AS C_13#2268, (round((elev#2283 * 1000.0), 0) / 1000.0) AS C_15#2269, continent#2284 AS C_19#2270, country#2285 AS C_21#2271, region#2286 AS C_18#2272, city#2287 AS C_20#2273, iata#2288 AS C_22#2274, code#2289 AS C_24#2275, gps#2290 AS C_23#2276, elev#2283 AS C_25#2277]
   +- *(1) Filter (((((isnotnull(lon#2282) AND isnotnull(lat#2281)) AND (lon#2282 <= -104.05)) AND (lon#2282 >= -111.05)) AND (lat#2281 >= 41.0)) AND (lat#2281 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#2278,type#2279,name#2280,lat#2281,lon#2282,elev#2283,continent#2284,country#2285,region#2286,city#2287,iata#2288,code#2289,gps#2290] Batched: true, DataFilters: [isnotnull(lon#2282), isnotnull(lat#2281), (lon#2282 <= -104.05), (lon#2282 >= -111.05), (lat#228..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_24 DESC NULLS LAST], true
      +- 'Project ['C_1 AS C_20#3895, 'C_2 AS C_18#3896, 'C_3 AS C_21#3897, 'C_4331 AS C_22#3898, 'C_4332 AS C_25#3899, 'C_4333 AS C_19#3900, 'C_0 AS C_17#3901, 'C_43 AS C_12#3902, 'C_10 AS C_15#3903, 'C_8 AS C_23#3904, 'C_7 AS C_13#3905, 'C_9 AS C_16#3906, 'C_11 AS C_14#3907, 'C_6 AS C_24#3908]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_1#3879, 'C_64656661756c745f616972706f727473.type AS C_2#3880, 'C_64656661756c745f616972706f727473.name AS C_3#3881, 'C_64656661756c745f616972706f727473.lat AS C_4#3882, 'C_64656661756c745f616972706f727473.lon AS C_5#3883, 'C_64656661756c745f616972706f727473.elev AS C_6#3884, 'C_64656661756c745f616972706f727473.continent AS C_0#3885, 'C_64656661756c745f616972706f727473.country AS C_43#3886, 'C_64656661756c745f616972706f727473.region AS C_10#3887, 'C_64656661756c745f616972706f727473.city AS C_8#3888, 'C_64656661756c745f616972706f727473.iata AS C_7#3889, 'C_64656661756c745f616972706f727473.code AS C_9#3890, 'C_64656661756c745f616972706f727473.gps AS C_11#3891, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#3892, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#3893, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#3894]
               +- '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_20: string, C_18: string, C_21: string, C_22: double, C_25: double, C_19: double, C_17: string, C_12: string, C_15: string, C_23: string, C_13: string, C_16: string, C_14: string, C_24: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#3908 DESC NULLS LAST], true
      +- Project [C_1#3879 AS C_20#3895, C_2#3880 AS C_18#3896, C_3#3881 AS C_21#3897, C_4331#3892 AS C_22#3898, C_4332#3893 AS C_25#3899, C_4333#3894 AS C_19#3900, C_0#3885 AS C_17#3901, C_43#3886 AS C_12#3902, C_10#3887 AS C_15#3903, C_8#3888 AS C_23#3904, C_7#3889 AS C_13#3905, C_9#3890 AS C_16#3906, C_11#3891 AS C_14#3907, C_6#3884 AS C_24#3908]
         +- SubqueryAlias C_4954424c
            +- Project [id#3909 AS C_1#3879, type#3910 AS C_2#3880, name#3911 AS C_3#3881, lat#3912 AS C_4#3882, lon#3913 AS C_5#3883, elev#3914 AS C_6#3884, continent#3915 AS C_0#3885, country#3916 AS C_43#3886, region#3917 AS C_10#3887, city#3918 AS C_8#3888, iata#3919 AS C_7#3889, code#3920 AS C_9#3890, gps#3921 AS C_11#3891, (round((lat#3912 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#3892, (round((lon#3913 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#3893, (round((elev#3914 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#3894]
               +- Filter (((lon#3913 <= -104.05) AND (lon#3913 >= -111.05)) AND ((lat#3912 >= 41.0) AND (lat#3912 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#3909,type#3910,name#3911,lat#3912,lon#3913,elev#3914,continent#3915,country#3916,region#3917,city#3918,iata#3919,code#3920,gps#3921] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#3908 DESC NULLS LAST], true
      +- Project [id#3909 AS C_20#3895, type#3910 AS C_18#3896, name#3911 AS C_21#3897, (round((lat#3912 * 1000.0), 0) / 1000.0) AS C_22#3898, (round((lon#3913 * 1000.0), 0) / 1000.0) AS C_25#3899, (round((elev#3914 * 1000.0), 0) / 1000.0) AS C_19#3900, continent#3915 AS C_17#3901, country#3916 AS C_12#3902, region#3917 AS C_15#3903, city#3918 AS C_23#3904, iata#3919 AS C_13#3905, code#3920 AS C_16#3906, gps#3921 AS C_14#3907, elev#3914 AS C_24#3908]
         +- Filter ((isnotnull(lon#3913) AND isnotnull(lat#3912)) AND (((lon#3913 <= -104.05) AND (lon#3913 >= -111.05)) AND ((lat#3912 >= 41.0) AND (lat#3912 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#3909,type#3910,name#3911,lat#3912,lon#3913,elev#3914,continent#3915,country#3916,region#3917,city#3918,iata#3919,code#3920,gps#3921] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_24#3908 DESC NULLS LAST], output=[C_20#3895,C_18#3896,C_21#3897,C_22#3898,C_25#3899,C_19#3900,C_17#3901,C_12#3902,C_15#3903,C_23#3904,C_13#3905,C_16#3906,C_14#3907,C_24#3908])
+- *(1) Project [id#3909 AS C_20#3895, type#3910 AS C_18#3896, name#3911 AS C_21#3897, (round((lat#3912 * 1000.0), 0) / 1000.0) AS C_22#3898, (round((lon#3913 * 1000.0), 0) / 1000.0) AS C_25#3899, (round((elev#3914 * 1000.0), 0) / 1000.0) AS C_19#3900, continent#3915 AS C_17#3901, country#3916 AS C_12#3902, region#3917 AS C_15#3903, city#3918 AS C_23#3904, iata#3919 AS C_13#3905, code#3920 AS C_16#3906, gps#3921 AS C_14#3907, elev#3914 AS C_24#3908]
   +- *(1) Filter (((((isnotnull(lon#3913) AND isnotnull(lat#3912)) AND (lon#3913 <= -104.05)) AND (lon#3913 >= -111.05)) AND (lat#3912 >= 41.0)) AND (lat#3912 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#3909,type#3910,name#3911,lat#3912,lon#3913,elev#3914,continent#3915,country#3916,region#3917,city#3918,iata#3919,code#3920,gps#3921] Batched: true, DataFilters: [isnotnull(lon#3913), isnotnull(lat#3912), (lon#3913 <= -104.05), (lon#3913 >= -111.05), (lat#391..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_23 DESC NULLS LAST], true
      +- 'Project ['C_9 AS C_25#2884, 'C_2 AS C_22#2885, 'C_7 AS C_19#2886, 'C_4331 AS C_16#2887, 'C_4332 AS C_18#2888, 'C_4333 AS C_13#2889, 'C_6 AS C_21#2890, 'C_8 AS C_20#2891, 'C_43 AS C_17#2892, 'C_0 AS C_14#2893, 'C_1 AS C_12#2894, 'C_11 AS C_24#2895, 'C_10 AS C_15#2896, 'C_5 AS C_23#2897]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_9#2868, 'C_64656661756c745f616972706f727473.type AS C_2#2869, 'C_64656661756c745f616972706f727473.name AS C_7#2870, 'C_64656661756c745f616972706f727473.lat AS C_3#2871, 'C_64656661756c745f616972706f727473.lon AS C_4#2872, 'C_64656661756c745f616972706f727473.elev AS C_5#2873, 'C_64656661756c745f616972706f727473.continent AS C_6#2874, 'C_64656661756c745f616972706f727473.country AS C_8#2875, 'C_64656661756c745f616972706f727473.region AS C_43#2876, 'C_64656661756c745f616972706f727473.city AS C_0#2877, 'C_64656661756c745f616972706f727473.iata AS C_1#2878, 'C_64656661756c745f616972706f727473.code AS C_11#2879, 'C_64656661756c745f616972706f727473.gps AS C_10#2880, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#2881, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#2882, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#2883]
               +- '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_25: string, C_22: string, C_19: string, C_16: double, C_18: double, C_13: double, C_21: string, C_20: string, C_17: string, C_14: string, C_12: string, C_24: string, C_15: string, C_23: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_23#2897 DESC NULLS LAST], true
      +- Project [C_9#2868 AS C_25#2884, C_2#2869 AS C_22#2885, C_7#2870 AS C_19#2886, C_4331#2881 AS C_16#2887, C_4332#2882 AS C_18#2888, C_4333#2883 AS C_13#2889, C_6#2874 AS C_21#2890, C_8#2875 AS C_20#2891, C_43#2876 AS C_17#2892, C_0#2877 AS C_14#2893, C_1#2878 AS C_12#2894, C_11#2879 AS C_24#2895, C_10#2880 AS C_15#2896, C_5#2873 AS C_23#2897]
         +- SubqueryAlias C_4954424c
            +- Project [id#2898 AS C_9#2868, type#2899 AS C_2#2869, name#2900 AS C_7#2870, lat#2901 AS C_3#2871, lon#2902 AS C_4#2872, elev#2903 AS C_5#2873, continent#2904 AS C_6#2874, country#2905 AS C_8#2875, region#2906 AS C_43#2876, city#2907 AS C_0#2877, iata#2908 AS C_1#2878, code#2909 AS C_11#2879, gps#2910 AS C_10#2880, (round((lat#2901 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#2881, (round((lon#2902 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#2882, (round((elev#2903 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#2883]
               +- Filter (((lon#2902 <= -104.05) AND (lon#2902 >= -111.05)) AND ((lat#2901 >= 41.0) AND (lat#2901 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#2898,type#2899,name#2900,lat#2901,lon#2902,elev#2903,continent#2904,country#2905,region#2906,city#2907,iata#2908,code#2909,gps#2910] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_23#2897 DESC NULLS LAST], true
      +- Project [id#2898 AS C_25#2884, type#2899 AS C_22#2885, name#2900 AS C_19#2886, (round((lat#2901 * 1000.0), 0) / 1000.0) AS C_16#2887, (round((lon#2902 * 1000.0), 0) / 1000.0) AS C_18#2888, (round((elev#2903 * 1000.0), 0) / 1000.0) AS C_13#2889, continent#2904 AS C_21#2890, country#2905 AS C_20#2891, region#2906 AS C_17#2892, city#2907 AS C_14#2893, iata#2908 AS C_12#2894, code#2909 AS C_24#2895, gps#2910 AS C_15#2896, elev#2903 AS C_23#2897]
         +- Filter ((isnotnull(lon#2902) AND isnotnull(lat#2901)) AND (((lon#2902 <= -104.05) AND (lon#2902 >= -111.05)) AND ((lat#2901 >= 41.0) AND (lat#2901 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#2898,type#2899,name#2900,lat#2901,lon#2902,elev#2903,continent#2904,country#2905,region#2906,city#2907,iata#2908,code#2909,gps#2910] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_23#2897 DESC NULLS LAST], output=[C_25#2884,C_22#2885,C_19#2886,C_16#2887,C_18#2888,C_13#2889,C_21#2890,C_20#2891,C_17#2892,C_14#2893,C_12#2894,C_24#2895,C_15#2896,C_23#2897])
+- *(1) Project [id#2898 AS C_25#2884, type#2899 AS C_22#2885, name#2900 AS C_19#2886, (round((lat#2901 * 1000.0), 0) / 1000.0) AS C_16#2887, (round((lon#2902 * 1000.0), 0) / 1000.0) AS C_18#2888, (round((elev#2903 * 1000.0), 0) / 1000.0) AS C_13#2889, continent#2904 AS C_21#2890, country#2905 AS C_20#2891, region#2906 AS C_17#2892, city#2907 AS C_14#2893, iata#2908 AS C_12#2894, code#2909 AS C_24#2895, gps#2910 AS C_15#2896, elev#2903 AS C_23#2897]
   +- *(1) Filter (((((isnotnull(lon#2902) AND isnotnull(lat#2901)) AND (lon#2902 <= -104.05)) AND (lon#2902 >= -111.05)) AND (lat#2901 >= 41.0)) AND (lat#2901 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#2898,type#2899,name#2900,lat#2901,lon#2902,elev#2903,continent#2904,country#2905,region#2906,city#2907,iata#2908,code#2909,gps#2910] Batched: true, DataFilters: [isnotnull(lon#2902), isnotnull(lat#2901), (lon#2902 <= -104.05), (lon#2902 >= -111.05), (lat#290..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_14 DESC NULLS LAST], true
      +- 'Project ['C_43 AS C_16#2660, 'C_3 AS C_17#2661, 'C_2 AS C_15#2662, 'C_4331 AS C_21#2663, 'C_4332 AS C_22#2664, 'C_4333 AS C_19#2665, 'C_7 AS C_18#2666, 'C_6 AS C_20#2667, 'C_9 AS C_23#2668, 'C_8 AS C_25#2669, 'C_5 AS C_24#2670, 'C_11 AS C_13#2671, 'C_10 AS C_12#2672, 'C_1 AS C_14#2673]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_43#2644, 'C_64656661756c745f616972706f727473.type AS C_3#2645, 'C_64656661756c745f616972706f727473.name AS C_2#2646, 'C_64656661756c745f616972706f727473.lat AS C_0#2647, 'C_64656661756c745f616972706f727473.lon AS C_4#2648, 'C_64656661756c745f616972706f727473.elev AS C_1#2649, 'C_64656661756c745f616972706f727473.continent AS C_7#2650, 'C_64656661756c745f616972706f727473.country AS C_6#2651, 'C_64656661756c745f616972706f727473.region AS C_9#2652, 'C_64656661756c745f616972706f727473.city AS C_8#2653, 'C_64656661756c745f616972706f727473.iata AS C_5#2654, 'C_64656661756c745f616972706f727473.code AS C_11#2655, 'C_64656661756c745f616972706f727473.gps AS C_10#2656, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#2657, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#2658, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#2659]
               +- '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_16: string, C_17: string, C_15: string, C_21: double, C_22: double, C_19: double, C_18: string, C_20: string, C_23: string, C_25: string, C_24: string, C_13: string, C_12: string, C_14: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_14#2673 DESC NULLS LAST], true
      +- Project [C_43#2644 AS C_16#2660, C_3#2645 AS C_17#2661, C_2#2646 AS C_15#2662, C_4331#2657 AS C_21#2663, C_4332#2658 AS C_22#2664, C_4333#2659 AS C_19#2665, C_7#2650 AS C_18#2666, C_6#2651 AS C_20#2667, C_9#2652 AS C_23#2668, C_8#2653 AS C_25#2669, C_5#2654 AS C_24#2670, C_11#2655 AS C_13#2671, C_10#2656 AS C_12#2672, C_1#2649 AS C_14#2673]
         +- SubqueryAlias C_4954424c
            +- Project [id#2674 AS C_43#2644, type#2675 AS C_3#2645, name#2676 AS C_2#2646, lat#2677 AS C_0#2647, lon#2678 AS C_4#2648, elev#2679 AS C_1#2649, continent#2680 AS C_7#2650, country#2681 AS C_6#2651, region#2682 AS C_9#2652, city#2683 AS C_8#2653, iata#2684 AS C_5#2654, code#2685 AS C_11#2655, gps#2686 AS C_10#2656, (round((lat#2677 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#2657, (round((lon#2678 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#2658, (round((elev#2679 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#2659]
               +- Filter (((lon#2678 <= -104.05) AND (lon#2678 >= -111.05)) AND ((lat#2677 >= 41.0) AND (lat#2677 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#2674,type#2675,name#2676,lat#2677,lon#2678,elev#2679,continent#2680,country#2681,region#2682,city#2683,iata#2684,code#2685,gps#2686] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_14#2673 DESC NULLS LAST], true
      +- Project [id#2674 AS C_16#2660, type#2675 AS C_17#2661, name#2676 AS C_15#2662, (round((lat#2677 * 1000.0), 0) / 1000.0) AS C_21#2663, (round((lon#2678 * 1000.0), 0) / 1000.0) AS C_22#2664, (round((elev#2679 * 1000.0), 0) / 1000.0) AS C_19#2665, continent#2680 AS C_18#2666, country#2681 AS C_20#2667, region#2682 AS C_23#2668, city#2683 AS C_25#2669, iata#2684 AS C_24#2670, code#2685 AS C_13#2671, gps#2686 AS C_12#2672, elev#2679 AS C_14#2673]
         +- Filter ((isnotnull(lon#2678) AND isnotnull(lat#2677)) AND (((lon#2678 <= -104.05) AND (lon#2678 >= -111.05)) AND ((lat#2677 >= 41.0) AND (lat#2677 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#2674,type#2675,name#2676,lat#2677,lon#2678,elev#2679,continent#2680,country#2681,region#2682,city#2683,iata#2684,code#2685,gps#2686] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_14#2673 DESC NULLS LAST], output=[C_16#2660,C_17#2661,C_15#2662,C_21#2663,C_22#2664,C_19#2665,C_18#2666,C_20#2667,C_23#2668,C_25#2669,C_24#2670,C_13#2671,C_12#2672,C_14#2673])
+- *(1) Project [id#2674 AS C_16#2660, type#2675 AS C_17#2661, name#2676 AS C_15#2662, (round((lat#2677 * 1000.0), 0) / 1000.0) AS C_21#2663, (round((lon#2678 * 1000.0), 0) / 1000.0) AS C_22#2664, (round((elev#2679 * 1000.0), 0) / 1000.0) AS C_19#2665, continent#2680 AS C_18#2666, country#2681 AS C_20#2667, region#2682 AS C_23#2668, city#2683 AS C_25#2669, iata#2684 AS C_24#2670, code#2685 AS C_13#2671, gps#2686 AS C_12#2672, elev#2679 AS C_14#2673]
   +- *(1) Filter (((((isnotnull(lon#2678) AND isnotnull(lat#2677)) AND (lon#2678 <= -104.05)) AND (lon#2678 >= -111.05)) AND (lat#2677 >= 41.0)) AND (lat#2677 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#2674,type#2675,name#2676,lat#2677,lon#2678,elev#2679,continent#2680,country#2681,region#2682,city#2683,iata#2684,code#2685,gps#2686] Batched: true, DataFilters: [isnotnull(lon#2678), isnotnull(lat#2677), (lon#2678 <= -104.05), (lon#2678 >= -111.05), (lat#267..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_22 DESC NULLS LAST], true
      +- 'Project ['C_0 AS C_13#3323, 'C_43 AS C_14#3324, 'C_5 AS C_15#3325, 'C_4331 AS C_16#3326, 'C_4332 AS C_12#3327, 'C_4333 AS C_17#3328, 'C_1 AS C_18#3329, 'C_6 AS C_21#3330, 'C_7 AS C_19#3331, 'C_8 AS C_20#3332, 'C_10 AS C_23#3333, 'C_9 AS C_24#3334, 'C_11 AS C_25#3335, 'C_4 AS C_22#3336]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_0#3307, 'C_64656661756c745f616972706f727473.type AS C_43#3308, 'C_64656661756c745f616972706f727473.name AS C_5#3309, 'C_64656661756c745f616972706f727473.lat AS C_3#3310, 'C_64656661756c745f616972706f727473.lon AS C_2#3311, 'C_64656661756c745f616972706f727473.elev AS C_4#3312, 'C_64656661756c745f616972706f727473.continent AS C_1#3313, 'C_64656661756c745f616972706f727473.country AS C_6#3314, 'C_64656661756c745f616972706f727473.region AS C_7#3315, 'C_64656661756c745f616972706f727473.city AS C_8#3316, 'C_64656661756c745f616972706f727473.iata AS C_10#3317, 'C_64656661756c745f616972706f727473.code AS C_9#3318, 'C_64656661756c745f616972706f727473.gps AS C_11#3319, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#3320, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#3321, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#3322]
               +- '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_13: string, C_14: string, C_15: string, C_16: double, C_12: double, C_17: double, C_18: string, C_21: string, C_19: string, C_20: string, C_23: string, C_24: string, C_25: string, C_22: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_22#3336 DESC NULLS LAST], true
      +- Project [C_0#3307 AS C_13#3323, C_43#3308 AS C_14#3324, C_5#3309 AS C_15#3325, C_4331#3320 AS C_16#3326, C_4332#3321 AS C_12#3327, C_4333#3322 AS C_17#3328, C_1#3313 AS C_18#3329, C_6#3314 AS C_21#3330, C_7#3315 AS C_19#3331, C_8#3316 AS C_20#3332, C_10#3317 AS C_23#3333, C_9#3318 AS C_24#3334, C_11#3319 AS C_25#3335, C_4#3312 AS C_22#3336]
         +- SubqueryAlias C_4954424c
            +- Project [id#3337 AS C_0#3307, type#3338 AS C_43#3308, name#3339 AS C_5#3309, lat#3340 AS C_3#3310, lon#3341 AS C_2#3311, elev#3342 AS C_4#3312, continent#3343 AS C_1#3313, country#3344 AS C_6#3314, region#3345 AS C_7#3315, city#3346 AS C_8#3316, iata#3347 AS C_10#3317, code#3348 AS C_9#3318, gps#3349 AS C_11#3319, (round((lat#3340 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#3320, (round((lon#3341 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#3321, (round((elev#3342 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#3322]
               +- Filter (((lon#3341 <= -104.05) AND (lon#3341 >= -111.05)) AND ((lat#3340 >= 41.0) AND (lat#3340 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#3337,type#3338,name#3339,lat#3340,lon#3341,elev#3342,continent#3343,country#3344,region#3345,city#3346,iata#3347,code#3348,gps#3349] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_22#3336 DESC NULLS LAST], true
      +- Project [id#3337 AS C_13#3323, type#3338 AS C_14#3324, name#3339 AS C_15#3325, (round((lat#3340 * 1000.0), 0) / 1000.0) AS C_16#3326, (round((lon#3341 * 1000.0), 0) / 1000.0) AS C_12#3327, (round((elev#3342 * 1000.0), 0) / 1000.0) AS C_17#3328, continent#3343 AS C_18#3329, country#3344 AS C_21#3330, region#3345 AS C_19#3331, city#3346 AS C_20#3332, iata#3347 AS C_23#3333, code#3348 AS C_24#3334, gps#3349 AS C_25#3335, elev#3342 AS C_22#3336]
         +- Filter ((isnotnull(lon#3341) AND isnotnull(lat#3340)) AND (((lon#3341 <= -104.05) AND (lon#3341 >= -111.05)) AND ((lat#3340 >= 41.0) AND (lat#3340 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#3337,type#3338,name#3339,lat#3340,lon#3341,elev#3342,continent#3343,country#3344,region#3345,city#3346,iata#3347,code#3348,gps#3349] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_22#3336 DESC NULLS LAST], output=[C_13#3323,C_14#3324,C_15#3325,C_16#3326,C_12#3327,C_17#3328,C_18#3329,C_21#3330,C_19#3331,C_20#3332,C_23#3333,C_24#3334,C_25#3335,C_22#3336])
+- *(1) Project [id#3337 AS C_13#3323, type#3338 AS C_14#3324, name#3339 AS C_15#3325, (round((lat#3340 * 1000.0), 0) / 1000.0) AS C_16#3326, (round((lon#3341 * 1000.0), 0) / 1000.0) AS C_12#3327, (round((elev#3342 * 1000.0), 0) / 1000.0) AS C_17#3328, continent#3343 AS C_18#3329, country#3344 AS C_21#3330, region#3345 AS C_19#3331, city#3346 AS C_20#3332, iata#3347 AS C_23#3333, code#3348 AS C_24#3334, gps#3349 AS C_25#3335, elev#3342 AS C_22#3336]
   +- *(1) Filter (((((isnotnull(lon#3341) AND isnotnull(lat#3340)) AND (lon#3341 <= -104.05)) AND (lon#3341 >= -111.05)) AND (lat#3340 >= 41.0)) AND (lat#3340 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#3337,type#3338,name#3339,lat#3340,lon#3341,elev#3342,continent#3343,country#3344,region#3345,city#3346,iata#3347,code#3348,gps#3349] Batched: true, DataFilters: [isnotnull(lon#3341), isnotnull(lat#3340), (lon#3341 <= -104.05), (lon#3341 >= -111.05), (lat#334..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_25 DESC NULLS LAST], true
      +- 'Project ['C_5 AS C_21#4304, 'C_6 AS C_18#4305, 'C_7 AS C_22#4306, 'C_4331 AS C_14#4307, 'C_4332 AS C_23#4308, 'C_4333 AS C_17#4309, 'C_0 AS C_20#4310, 'C_1 AS C_13#4311, 'C_43 AS C_12#4312, 'C_4 AS C_19#4313, 'C_2 AS C_24#4314, 'C_10 AS C_15#4315, 'C_11 AS C_16#4316, 'C_9 AS C_25#4317]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_5#4288, 'C_64656661756c745f616972706f727473.type AS C_6#4289, 'C_64656661756c745f616972706f727473.name AS C_7#4290, 'C_64656661756c745f616972706f727473.lat AS C_8#4291, 'C_64656661756c745f616972706f727473.lon AS C_3#4292, 'C_64656661756c745f616972706f727473.elev AS C_9#4293, 'C_64656661756c745f616972706f727473.continent AS C_0#4294, 'C_64656661756c745f616972706f727473.country AS C_1#4295, 'C_64656661756c745f616972706f727473.region AS C_43#4296, 'C_64656661756c745f616972706f727473.city AS C_4#4297, 'C_64656661756c745f616972706f727473.iata AS C_2#4298, 'C_64656661756c745f616972706f727473.code AS C_10#4299, 'C_64656661756c745f616972706f727473.gps AS C_11#4300, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#4301, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#4302, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#4303]
               +- '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_21: string, C_18: string, C_22: string, C_14: double, C_23: double, C_17: double, C_20: string, C_13: string, C_12: string, C_19: string, C_24: string, C_15: string, C_16: string, C_25: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#4317 DESC NULLS LAST], true
      +- Project [C_5#4288 AS C_21#4304, C_6#4289 AS C_18#4305, C_7#4290 AS C_22#4306, C_4331#4301 AS C_14#4307, C_4332#4302 AS C_23#4308, C_4333#4303 AS C_17#4309, C_0#4294 AS C_20#4310, C_1#4295 AS C_13#4311, C_43#4296 AS C_12#4312, C_4#4297 AS C_19#4313, C_2#4298 AS C_24#4314, C_10#4299 AS C_15#4315, C_11#4300 AS C_16#4316, C_9#4293 AS C_25#4317]
         +- SubqueryAlias C_4954424c
            +- Project [id#4318 AS C_5#4288, type#4319 AS C_6#4289, name#4320 AS C_7#4290, lat#4321 AS C_8#4291, lon#4322 AS C_3#4292, elev#4323 AS C_9#4293, continent#4324 AS C_0#4294, country#4325 AS C_1#4295, region#4326 AS C_43#4296, city#4327 AS C_4#4297, iata#4328 AS C_2#4298, code#4329 AS C_10#4299, gps#4330 AS C_11#4300, (round((lat#4321 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#4301, (round((lon#4322 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#4302, (round((elev#4323 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#4303]
               +- Filter (((lon#4322 <= -104.05) AND (lon#4322 >= -111.05)) AND ((lat#4321 >= 41.0) AND (lat#4321 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#4318,type#4319,name#4320,lat#4321,lon#4322,elev#4323,continent#4324,country#4325,region#4326,city#4327,iata#4328,code#4329,gps#4330] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#4317 DESC NULLS LAST], true
      +- Project [id#4318 AS C_21#4304, type#4319 AS C_18#4305, name#4320 AS C_22#4306, (round((lat#4321 * 1000.0), 0) / 1000.0) AS C_14#4307, (round((lon#4322 * 1000.0), 0) / 1000.0) AS C_23#4308, (round((elev#4323 * 1000.0), 0) / 1000.0) AS C_17#4309, continent#4324 AS C_20#4310, country#4325 AS C_13#4311, region#4326 AS C_12#4312, city#4327 AS C_19#4313, iata#4328 AS C_24#4314, code#4329 AS C_15#4315, gps#4330 AS C_16#4316, elev#4323 AS C_25#4317]
         +- Filter ((isnotnull(lon#4322) AND isnotnull(lat#4321)) AND (((lon#4322 <= -104.05) AND (lon#4322 >= -111.05)) AND ((lat#4321 >= 41.0) AND (lat#4321 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#4318,type#4319,name#4320,lat#4321,lon#4322,elev#4323,continent#4324,country#4325,region#4326,city#4327,iata#4328,code#4329,gps#4330] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_25#4317 DESC NULLS LAST], output=[C_21#4304,C_18#4305,C_22#4306,C_14#4307,C_23#4308,C_17#4309,C_20#4310,C_13#4311,C_12#4312,C_19#4313,C_24#4314,C_15#4315,C_16#4316,C_25#4317])
+- *(1) Project [id#4318 AS C_21#4304, type#4319 AS C_18#4305, name#4320 AS C_22#4306, (round((lat#4321 * 1000.0), 0) / 1000.0) AS C_14#4307, (round((lon#4322 * 1000.0), 0) / 1000.0) AS C_23#4308, (round((elev#4323 * 1000.0), 0) / 1000.0) AS C_17#4309, continent#4324 AS C_20#4310, country#4325 AS C_13#4311, region#4326 AS C_12#4312, city#4327 AS C_19#4313, iata#4328 AS C_24#4314, code#4329 AS C_15#4315, gps#4330 AS C_16#4316, elev#4323 AS C_25#4317]
   +- *(1) Filter (((((isnotnull(lon#4322) AND isnotnull(lat#4321)) AND (lon#4322 <= -104.05)) AND (lon#4322 >= -111.05)) AND (lat#4321 >= 41.0)) AND (lat#4321 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#4318,type#4319,name#4320,lat#4321,lon#4322,elev#4323,continent#4324,country#4325,region#4326,city#4327,iata#4328,code#4329,gps#4330] Batched: true, DataFilters: [isnotnull(lon#4322), isnotnull(lat#4321), (lon#4322 <= -104.05), (lon#4322 >= -111.05), (lat#432..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_16 DESC NULLS LAST], true
      +- 'Project ['C_5 AS C_18#4646, 'C_6 AS C_19#4647, 'C_0 AS C_15#4648, 'C_4331 AS C_22#4649, 'C_4332 AS C_25#4650, 'C_4333 AS C_20#4651, 'C_4 AS C_23#4652, 'C_43 AS C_14#4653, 'C_11 AS C_12#4654, 'C_8 AS C_17#4655, 'C_7 AS C_24#4656, 'C_9 AS C_21#4657, 'C_10 AS C_13#4658, 'C_3 AS C_16#4659]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_5#4630, 'C_64656661756c745f616972706f727473.type AS C_6#4631, 'C_64656661756c745f616972706f727473.name AS C_0#4632, 'C_64656661756c745f616972706f727473.lat AS C_1#4633, 'C_64656661756c745f616972706f727473.lon AS C_2#4634, 'C_64656661756c745f616972706f727473.elev AS C_3#4635, 'C_64656661756c745f616972706f727473.continent AS C_4#4636, 'C_64656661756c745f616972706f727473.country AS C_43#4637, 'C_64656661756c745f616972706f727473.region AS C_11#4638, 'C_64656661756c745f616972706f727473.city AS C_8#4639, 'C_64656661756c745f616972706f727473.iata AS C_7#4640, 'C_64656661756c745f616972706f727473.code AS C_9#4641, 'C_64656661756c745f616972706f727473.gps AS C_10#4642, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#4643, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#4644, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#4645]
               +- '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_18: string, C_19: string, C_15: string, C_22: double, C_25: double, C_20: double, C_23: string, C_14: string, C_12: string, C_17: string, C_24: string, C_21: string, C_13: string, C_16: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_16#4659 DESC NULLS LAST], true
      +- Project [C_5#4630 AS C_18#4646, C_6#4631 AS C_19#4647, C_0#4632 AS C_15#4648, C_4331#4643 AS C_22#4649, C_4332#4644 AS C_25#4650, C_4333#4645 AS C_20#4651, C_4#4636 AS C_23#4652, C_43#4637 AS C_14#4653, C_11#4638 AS C_12#4654, C_8#4639 AS C_17#4655, C_7#4640 AS C_24#4656, C_9#4641 AS C_21#4657, C_10#4642 AS C_13#4658, C_3#4635 AS C_16#4659]
         +- SubqueryAlias C_4954424c
            +- Project [id#4660 AS C_5#4630, type#4661 AS C_6#4631, name#4662 AS C_0#4632, lat#4663 AS C_1#4633, lon#4664 AS C_2#4634, elev#4665 AS C_3#4635, continent#4666 AS C_4#4636, country#4667 AS C_43#4637, region#4668 AS C_11#4638, city#4669 AS C_8#4639, iata#4670 AS C_7#4640, code#4671 AS C_9#4641, gps#4672 AS C_10#4642, (round((lat#4663 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#4643, (round((lon#4664 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#4644, (round((elev#4665 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#4645]
               +- Filter (((lon#4664 <= -104.05) AND (lon#4664 >= -111.05)) AND ((lat#4663 >= 41.0) AND (lat#4663 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#4660,type#4661,name#4662,lat#4663,lon#4664,elev#4665,continent#4666,country#4667,region#4668,city#4669,iata#4670,code#4671,gps#4672] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_16#4659 DESC NULLS LAST], true
      +- Project [id#4660 AS C_18#4646, type#4661 AS C_19#4647, name#4662 AS C_15#4648, (round((lat#4663 * 1000.0), 0) / 1000.0) AS C_22#4649, (round((lon#4664 * 1000.0), 0) / 1000.0) AS C_25#4650, (round((elev#4665 * 1000.0), 0) / 1000.0) AS C_20#4651, continent#4666 AS C_23#4652, country#4667 AS C_14#4653, region#4668 AS C_12#4654, city#4669 AS C_17#4655, iata#4670 AS C_24#4656, code#4671 AS C_21#4657, gps#4672 AS C_13#4658, elev#4665 AS C_16#4659]
         +- Filter ((isnotnull(lon#4664) AND isnotnull(lat#4663)) AND (((lon#4664 <= -104.05) AND (lon#4664 >= -111.05)) AND ((lat#4663 >= 41.0) AND (lat#4663 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#4660,type#4661,name#4662,lat#4663,lon#4664,elev#4665,continent#4666,country#4667,region#4668,city#4669,iata#4670,code#4671,gps#4672] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_16#4659 DESC NULLS LAST], output=[C_18#4646,C_19#4647,C_15#4648,C_22#4649,C_25#4650,C_20#4651,C_23#4652,C_14#4653,C_12#4654,C_17#4655,C_24#4656,C_21#4657,C_13#4658,C_16#4659])
+- *(1) Project [id#4660 AS C_18#4646, type#4661 AS C_19#4647, name#4662 AS C_15#4648, (round((lat#4663 * 1000.0), 0) / 1000.0) AS C_22#4649, (round((lon#4664 * 1000.0), 0) / 1000.0) AS C_25#4650, (round((elev#4665 * 1000.0), 0) / 1000.0) AS C_20#4651, continent#4666 AS C_23#4652, country#4667 AS C_14#4653, region#4668 AS C_12#4654, city#4669 AS C_17#4655, iata#4670 AS C_24#4656, code#4671 AS C_21#4657, gps#4672 AS C_13#4658, elev#4665 AS C_16#4659]
   +- *(1) Filter (((((isnotnull(lon#4664) AND isnotnull(lat#4663)) AND (lon#4664 <= -104.05)) AND (lon#4664 >= -111.05)) AND (lat#4663 >= 41.0)) AND (lat#4663 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#4660,type#4661,name#4662,lat#4663,lon#4664,elev#4665,continent#4666,country#4667,region#4668,city#4669,iata#4670,code#4671,gps#4672] Batched: true, DataFilters: [isnotnull(lon#4664), isnotnull(lat#4663), (lon#4664 <= -104.05), (lon#4664 >= -111.05), (lat#466..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_25 DESC NULLS LAST], true
      +- 'Project ['C_43 AS C_12#5510, 'C_2 AS C_13#5511, 'C_4 AS C_14#5512, 'C_4331 AS C_17#5513, 'C_4332 AS C_16#5514, 'C_4333 AS C_18#5515, 'C_8 AS C_19#5516, 'C_5 AS C_15#5517, 'C_9 AS C_20#5518, 'C_6 AS C_24#5519, 'C_7 AS C_21#5520, 'C_11 AS C_23#5521, 'C_10 AS C_22#5522, 'C_0 AS C_25#5523]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_43#5494, 'C_64656661756c745f616972706f727473.type AS C_2#5495, 'C_64656661756c745f616972706f727473.name AS C_4#5496, 'C_64656661756c745f616972706f727473.lat AS C_1#5497, 'C_64656661756c745f616972706f727473.lon AS C_3#5498, 'C_64656661756c745f616972706f727473.elev AS C_0#5499, 'C_64656661756c745f616972706f727473.continent AS C_8#5500, 'C_64656661756c745f616972706f727473.country AS C_5#5501, 'C_64656661756c745f616972706f727473.region AS C_9#5502, 'C_64656661756c745f616972706f727473.city AS C_6#5503, 'C_64656661756c745f616972706f727473.iata AS C_7#5504, 'C_64656661756c745f616972706f727473.code AS C_11#5505, 'C_64656661756c745f616972706f727473.gps AS C_10#5506, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#5507, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#5508, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#5509]
               +- '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_12: string, C_13: string, C_14: string, C_17: double, C_16: double, C_18: double, C_19: string, C_15: string, C_20: string, C_24: string, C_21: string, C_23: string, C_22: string, C_25: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#5523 DESC NULLS LAST], true
      +- Project [C_43#5494 AS C_12#5510, C_2#5495 AS C_13#5511, C_4#5496 AS C_14#5512, C_4331#5507 AS C_17#5513, C_4332#5508 AS C_16#5514, C_4333#5509 AS C_18#5515, C_8#5500 AS C_19#5516, C_5#5501 AS C_15#5517, C_9#5502 AS C_20#5518, C_6#5503 AS C_24#5519, C_7#5504 AS C_21#5520, C_11#5505 AS C_23#5521, C_10#5506 AS C_22#5522, C_0#5499 AS C_25#5523]
         +- SubqueryAlias C_4954424c
            +- Project [id#5524 AS C_43#5494, type#5525 AS C_2#5495, name#5526 AS C_4#5496, lat#5527 AS C_1#5497, lon#5528 AS C_3#5498, elev#5529 AS C_0#5499, continent#5530 AS C_8#5500, country#5531 AS C_5#5501, region#5532 AS C_9#5502, city#5533 AS C_6#5503, iata#5534 AS C_7#5504, code#5535 AS C_11#5505, gps#5536 AS C_10#5506, (round((lat#5527 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#5507, (round((lon#5528 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#5508, (round((elev#5529 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#5509]
               +- Filter (((lon#5528 <= -104.05) AND (lon#5528 >= -111.05)) AND ((lat#5527 >= 41.0) AND (lat#5527 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#5524,type#5525,name#5526,lat#5527,lon#5528,elev#5529,continent#5530,country#5531,region#5532,city#5533,iata#5534,code#5535,gps#5536] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_25#5523 DESC NULLS LAST], true
      +- Project [id#5524 AS C_12#5510, type#5525 AS C_13#5511, name#5526 AS C_14#5512, (round((lat#5527 * 1000.0), 0) / 1000.0) AS C_17#5513, (round((lon#5528 * 1000.0), 0) / 1000.0) AS C_16#5514, (round((elev#5529 * 1000.0), 0) / 1000.0) AS C_18#5515, continent#5530 AS C_19#5516, country#5531 AS C_15#5517, region#5532 AS C_20#5518, city#5533 AS C_24#5519, iata#5534 AS C_21#5520, code#5535 AS C_23#5521, gps#5536 AS C_22#5522, elev#5529 AS C_25#5523]
         +- Filter ((isnotnull(lon#5528) AND isnotnull(lat#5527)) AND (((lon#5528 <= -104.05) AND (lon#5528 >= -111.05)) AND ((lat#5527 >= 41.0) AND (lat#5527 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#5524,type#5525,name#5526,lat#5527,lon#5528,elev#5529,continent#5530,country#5531,region#5532,city#5533,iata#5534,code#5535,gps#5536] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_25#5523 DESC NULLS LAST], output=[C_12#5510,C_13#5511,C_14#5512,C_17#5513,C_16#5514,C_18#5515,C_19#5516,C_15#5517,C_20#5518,C_24#5519,C_21#5520,C_23#5521,C_22#5522,C_25#5523])
+- *(1) Project [id#5524 AS C_12#5510, type#5525 AS C_13#5511, name#5526 AS C_14#5512, (round((lat#5527 * 1000.0), 0) / 1000.0) AS C_17#5513, (round((lon#5528 * 1000.0), 0) / 1000.0) AS C_16#5514, (round((elev#5529 * 1000.0), 0) / 1000.0) AS C_18#5515, continent#5530 AS C_19#5516, country#5531 AS C_15#5517, region#5532 AS C_20#5518, city#5533 AS C_24#5519, iata#5534 AS C_21#5520, code#5535 AS C_23#5521, gps#5536 AS C_22#5522, elev#5529 AS C_25#5523]
   +- *(1) Filter (((((isnotnull(lon#5528) AND isnotnull(lat#5527)) AND (lon#5528 <= -104.05)) AND (lon#5528 >= -111.05)) AND (lat#5527 >= 41.0)) AND (lat#5527 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#5524,type#5525,name#5526,lat#5527,lon#5528,elev#5529,continent#5530,country#5531,region#5532,city#5533,iata#5534,code#5535,gps#5536] Batched: true, DataFilters: [isnotnull(lon#5528), isnotnull(lat#5527), (lon#5528 <= -104.05), (lon#5528 >= -111.05), (lat#552..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_24 DESC NULLS LAST], true
      +- 'Project ['C_5 AS C_13#4790, 'C_43 AS C_23#4791, 'C_6 AS C_15#4792, 'C_4331 AS C_19#4793, 'C_4332 AS C_21#4794, 'C_4333 AS C_18#4795, 'C_0 AS C_25#4796, 'C_1 AS C_20#4797, 'C_2 AS C_16#4798, 'C_3 AS C_22#4799, 'C_4 AS C_12#4800, 'C_10 AS C_17#4801, 'C_11 AS C_14#4802, 'C_9 AS C_24#4803]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_5#4774, 'C_64656661756c745f616972706f727473.type AS C_43#4775, 'C_64656661756c745f616972706f727473.name AS C_6#4776, 'C_64656661756c745f616972706f727473.lat AS C_7#4777, 'C_64656661756c745f616972706f727473.lon AS C_8#4778, 'C_64656661756c745f616972706f727473.elev AS C_9#4779, 'C_64656661756c745f616972706f727473.continent AS C_0#4780, 'C_64656661756c745f616972706f727473.country AS C_1#4781, 'C_64656661756c745f616972706f727473.region AS C_2#4782, 'C_64656661756c745f616972706f727473.city AS C_3#4783, 'C_64656661756c745f616972706f727473.iata AS C_4#4784, 'C_64656661756c745f616972706f727473.code AS C_10#4785, 'C_64656661756c745f616972706f727473.gps AS C_11#4786, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#4787, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#4788, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#4789]
               +- '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_13: string, C_23: string, C_15: string, C_19: double, C_21: double, C_18: double, C_25: string, C_20: string, C_16: string, C_22: string, C_12: string, C_17: string, C_14: string, C_24: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#4803 DESC NULLS LAST], true
      +- Project [C_5#4774 AS C_13#4790, C_43#4775 AS C_23#4791, C_6#4776 AS C_15#4792, C_4331#4787 AS C_19#4793, C_4332#4788 AS C_21#4794, C_4333#4789 AS C_18#4795, C_0#4780 AS C_25#4796, C_1#4781 AS C_20#4797, C_2#4782 AS C_16#4798, C_3#4783 AS C_22#4799, C_4#4784 AS C_12#4800, C_10#4785 AS C_17#4801, C_11#4786 AS C_14#4802, C_9#4779 AS C_24#4803]
         +- SubqueryAlias C_4954424c
            +- Project [id#4804 AS C_5#4774, type#4805 AS C_43#4775, name#4806 AS C_6#4776, lat#4807 AS C_7#4777, lon#4808 AS C_8#4778, elev#4809 AS C_9#4779, continent#4810 AS C_0#4780, country#4811 AS C_1#4781, region#4812 AS C_2#4782, city#4813 AS C_3#4783, iata#4814 AS C_4#4784, code#4815 AS C_10#4785, gps#4816 AS C_11#4786, (round((lat#4807 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#4787, (round((lon#4808 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#4788, (round((elev#4809 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#4789]
               +- Filter (((lon#4808 <= -104.05) AND (lon#4808 >= -111.05)) AND ((lat#4807 >= 41.0) AND (lat#4807 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#4804,type#4805,name#4806,lat#4807,lon#4808,elev#4809,continent#4810,country#4811,region#4812,city#4813,iata#4814,code#4815,gps#4816] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_24#4803 DESC NULLS LAST], true
      +- Project [id#4804 AS C_13#4790, type#4805 AS C_23#4791, name#4806 AS C_15#4792, (round((lat#4807 * 1000.0), 0) / 1000.0) AS C_19#4793, (round((lon#4808 * 1000.0), 0) / 1000.0) AS C_21#4794, (round((elev#4809 * 1000.0), 0) / 1000.0) AS C_18#4795, continent#4810 AS C_25#4796, country#4811 AS C_20#4797, region#4812 AS C_16#4798, city#4813 AS C_22#4799, iata#4814 AS C_12#4800, code#4815 AS C_17#4801, gps#4816 AS C_14#4802, elev#4809 AS C_24#4803]
         +- Filter ((isnotnull(lon#4808) AND isnotnull(lat#4807)) AND (((lon#4808 <= -104.05) AND (lon#4808 >= -111.05)) AND ((lat#4807 >= 41.0) AND (lat#4807 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#4804,type#4805,name#4806,lat#4807,lon#4808,elev#4809,continent#4810,country#4811,region#4812,city#4813,iata#4814,code#4815,gps#4816] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_24#4803 DESC NULLS LAST], output=[C_13#4790,C_23#4791,C_15#4792,C_19#4793,C_21#4794,C_18#4795,C_25#4796,C_20#4797,C_16#4798,C_22#4799,C_12#4800,C_17#4801,C_14#4802,C_24#4803])
+- *(1) Project [id#4804 AS C_13#4790, type#4805 AS C_23#4791, name#4806 AS C_15#4792, (round((lat#4807 * 1000.0), 0) / 1000.0) AS C_19#4793, (round((lon#4808 * 1000.0), 0) / 1000.0) AS C_21#4794, (round((elev#4809 * 1000.0), 0) / 1000.0) AS C_18#4795, continent#4810 AS C_25#4796, country#4811 AS C_20#4797, region#4812 AS C_16#4798, city#4813 AS C_22#4799, iata#4814 AS C_12#4800, code#4815 AS C_17#4801, gps#4816 AS C_14#4802, elev#4809 AS C_24#4803]
   +- *(1) Filter (((((isnotnull(lon#4808) AND isnotnull(lat#4807)) AND (lon#4808 <= -104.05)) AND (lon#4808 >= -111.05)) AND (lat#4807 >= 41.0)) AND (lat#4807 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#4804,type#4805,name#4806,lat#4807,lon#4808,elev#4809,continent#4810,country#4811,region#4812,city#4813,iata#4814,code#4815,gps#4816] Batched: true, DataFilters: [isnotnull(lon#4808), isnotnull(lat#4807), (lon#4808 <= -104.05), (lon#4808 >= -111.05), (lat#480..., 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...

== Parsed Logical Plan ==
'GlobalLimit 5
+- 'LocalLimit 5
   +- 'Sort ['C_23 DESC NULLS LAST], true
      +- 'Project ['C_0 AS C_12#5654, 'C_1 AS C_17#5655, 'C_2 AS C_14#5656, 'C_4331 AS C_25#5657, 'C_4332 AS C_18#5658, 'C_4333 AS C_21#5659, 'C_4 AS C_22#5660, 'C_6 AS C_19#5661, 'C_8 AS C_13#5662, 'C_9 AS C_20#5663, 'C_10 AS C_24#5664, 'C_43 AS C_16#5665, 'C_11 AS C_15#5666, 'C_7 AS C_23#5667]
         +- 'SubqueryAlias C_4954424c
            +- 'Project ['C_64656661756c745f616972706f727473.id AS C_0#5638, 'C_64656661756c745f616972706f727473.type AS C_1#5639, 'C_64656661756c745f616972706f727473.name AS C_2#5640, 'C_64656661756c745f616972706f727473.lat AS C_5#5641, 'C_64656661756c745f616972706f727473.lon AS C_3#5642, 'C_64656661756c745f616972706f727473.elev AS C_7#5643, 'C_64656661756c745f616972706f727473.continent AS C_4#5644, 'C_64656661756c745f616972706f727473.country AS C_6#5645, 'C_64656661756c745f616972706f727473.region AS C_8#5646, 'C_64656661756c745f616972706f727473.city AS C_9#5647, 'C_64656661756c745f616972706f727473.iata AS C_10#5648, 'C_64656661756c745f616972706f727473.code AS C_43#5649, 'C_64656661756c745f616972706f727473.gps AS C_11#5650, ('round(('C_64656661756c745f616972706f727473.lat * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4331#5651, ('round(('C_64656661756c745f616972706f727473.lon * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4332#5652, ('round(('C_64656661756c745f616972706f727473.elev * 'power(10.0, 3)), 0) / 'power(10.0, 3)) AS C_4333#5653]
               +- '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_12: string, C_17: string, C_14: string, C_25: double, C_18: double, C_21: double, C_22: string, C_19: string, C_13: string, C_20: string, C_24: string, C_16: string, C_15: string, C_23: double
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_23#5667 DESC NULLS LAST], true
      +- Project [C_0#5638 AS C_12#5654, C_1#5639 AS C_17#5655, C_2#5640 AS C_14#5656, C_4331#5651 AS C_25#5657, C_4332#5652 AS C_18#5658, C_4333#5653 AS C_21#5659, C_4#5644 AS C_22#5660, C_6#5645 AS C_19#5661, C_8#5646 AS C_13#5662, C_9#5647 AS C_20#5663, C_10#5648 AS C_24#5664, C_43#5649 AS C_16#5665, C_11#5650 AS C_15#5666, C_7#5643 AS C_23#5667]
         +- SubqueryAlias C_4954424c
            +- Project [id#5668 AS C_0#5638, type#5669 AS C_1#5639, name#5670 AS C_2#5640, lat#5671 AS C_5#5641, lon#5672 AS C_3#5642, elev#5673 AS C_7#5643, continent#5674 AS C_4#5644, country#5675 AS C_6#5645, region#5676 AS C_8#5646, city#5677 AS C_9#5647, iata#5678 AS C_10#5648, code#5679 AS C_43#5649, gps#5680 AS C_11#5650, (round((lat#5671 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4331#5651, (round((lon#5672 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4332#5652, (round((elev#5673 * POWER(10.0, cast(3 as double))), 0) / POWER(10.0, cast(3 as double))) AS C_4333#5653]
               +- Filter (((lon#5672 <= -104.05) AND (lon#5672 >= -111.05)) AND ((lat#5671 >= 41.0) AND (lat#5671 <= 45.0)))
                  +- SubqueryAlias C_64656661756c745f616972706f727473
                     +- SubqueryAlias spark_catalog.default.airports
                        +- Relation spark_catalog.default.airports[id#5668,type#5669,name#5670,lat#5671,lon#5672,elev#5673,continent#5674,country#5675,region#5676,city#5677,iata#5678,code#5679,gps#5680] parquet

== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
   +- Sort [C_23#5667 DESC NULLS LAST], true
      +- Project [id#5668 AS C_12#5654, type#5669 AS C_17#5655, name#5670 AS C_14#5656, (round((lat#5671 * 1000.0), 0) / 1000.0) AS C_25#5657, (round((lon#5672 * 1000.0), 0) / 1000.0) AS C_18#5658, (round((elev#5673 * 1000.0), 0) / 1000.0) AS C_21#5659, continent#5674 AS C_22#5660, country#5675 AS C_19#5661, region#5676 AS C_13#5662, city#5677 AS C_20#5663, iata#5678 AS C_24#5664, code#5679 AS C_16#5665, gps#5680 AS C_15#5666, elev#5673 AS C_23#5667]
         +- Filter ((isnotnull(lon#5672) AND isnotnull(lat#5671)) AND (((lon#5672 <= -104.05) AND (lon#5672 >= -111.05)) AND ((lat#5671 >= 41.0) AND (lat#5671 <= 45.0))))
            +- Relation spark_catalog.default.airports[id#5668,type#5669,name#5670,lat#5671,lon#5672,elev#5673,continent#5674,country#5675,region#5676,city#5677,iata#5678,code#5679,gps#5680] parquet

== Physical Plan ==
TakeOrderedAndProject(limit=5, orderBy=[C_23#5667 DESC NULLS LAST], output=[C_12#5654,C_17#5655,C_14#5656,C_25#5657,C_18#5658,C_21#5659,C_22#5660,C_19#5661,C_13#5662,C_20#5663,C_24#5664,C_16#5665,C_15#5666,C_23#5667])
+- *(1) Project [id#5668 AS C_12#5654, type#5669 AS C_17#5655, name#5670 AS C_14#5656, (round((lat#5671 * 1000.0), 0) / 1000.0) AS C_25#5657, (round((lon#5672 * 1000.0), 0) / 1000.0) AS C_18#5658, (round((elev#5673 * 1000.0), 0) / 1000.0) AS C_21#5659, continent#5674 AS C_22#5660, country#5675 AS C_19#5661, region#5676 AS C_13#5662, city#5677 AS C_20#5663, iata#5678 AS C_24#5664, code#5679 AS C_16#5665, gps#5680 AS C_15#5666, elev#5673 AS C_23#5667]
   +- *(1) Filter (((((isnotnull(lon#5672) AND isnotnull(lat#5671)) AND (lon#5672 <= -104.05)) AND (lon#5672 >= -111.05)) AND (lat#5671 >= 41.0)) AND (lat#5671 <= 45.0))
      +- *(1) ColumnarToRow
         +- FileScan parquet spark_catalog.default.airports[id#5668,type#5669,name#5670,lat#5671,lon#5672,elev#5673,continent#5674,country#5675,region#5676,city#5677,iata#5678,code#5679,gps#5680] Batched: true, DataFilters: [isnotnull(lon#5672), isnotnull(lat#5671), (lon#5672 <= -104.05), (lon#5672 >= -111.05), (lat#567..., 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...

== Parsed Logical Plan ==
'GlobalLimit 1000
+- 'LocalLimit 1000
   +- 'Project ['STRING, 'DOUBLE, 'INTEGER, 'BIGINT, 'FLOAT, 'DECIMAL, 'NUMBER, 'BOOLEAN, 'DATE, 'TIMESTAMP, 'DATETIME, 'BINARY, 'ARRAY, 'MAP, 'STRUCT, 'VARCHAR, 'CHAR]
      +- 'UnresolvedRelation [default, alltypes], [], false

== Analyzed Logical Plan ==
STRING: string, DOUBLE: double, INTEGER: int, BIGINT: bigint, FLOAT: float, DECIMAL: decimal(10,2), NUMBER: decimal(10,2), BOOLEAN: boolean, DATE: date, TIMESTAMP: timestamp, DATETIME: timestamp, BINARY: binary, ARRAY: array<int>, MAP: map<string,string>, STRUCT: struct<field1:string,field2:int>, VARCHAR: string, CHAR: string
GlobalLimit 1000
+- LocalLimit 1000
   +- Project [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOOLEAN#3521, DATE#3522, TIMESTAMP#3523, DATETIME#3524, BINARY#3525, ARRAY#3526, MAP#3527, STRUCT#3528, VARCHAR#3529, CHAR#3530]
      +- SubqueryAlias spark_catalog.default.alltypes
         +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]

== Optimized Logical Plan ==
GlobalLimit 1000
+- LocalLimit 1000
   +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]

== Physical Plan ==
CollectLimit 1000
+- Scan hive spark_catalog.default.alltypes [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOOLEAN#3521, DATE#3522, TIMESTAMP#3523, DATETIME#3524, BINARY#3525, ARRAY#3526, MAP#3527, STRUCT#3528, VARCHAR#3529, CHAR#3530], HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]

== Parsed Logical Plan ==
'GlobalLimit 1000
+- 'LocalLimit 1000
   +- 'Project ['STRING, 'DOUBLE, 'INTEGER, 'BIGINT, 'FLOAT, 'DECIMAL, 'NUMBER, 'BOOLEAN, 'DATE, 'TIMESTAMP, 'DATETIME, 'BINARY, 'ARRAY, 'MAP, 'STRUCT, 'VARCHAR, 'CHAR]
      +- 'UnresolvedRelation [default, alltypes], [], false

== Analyzed Logical Plan ==
STRING: string, DOUBLE: double, INTEGER: int, BIGINT: bigint, FLOAT: float, DECIMAL: decimal(10,2), NUMBER: decimal(10,2), BOOLEAN: boolean, DATE: date, TIMESTAMP: timestamp, DATETIME: timestamp, BINARY: binary, ARRAY: array<int>, MAP: map<string,string>, STRUCT: struct<field1:string,field2:int>, VARCHAR: string, CHAR: string
GlobalLimit 1000
+- LocalLimit 1000
   +- Project [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOOLEAN#4013, DATE#4014, TIMESTAMP#4015, DATETIME#4016, BINARY#4017, ARRAY#4018, MAP#4019, STRUCT#4020, VARCHAR#4021, CHAR#4022]
      +- SubqueryAlias spark_catalog.default.alltypes
         +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []]

== Optimized Logical Plan ==
GlobalLimit 1000
+- LocalLimit 1000
   +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []]

== Physical Plan ==
CollectLimit 1000
+- Scan hive spark_catalog.default.alltypes [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOOLEAN#4013, DATE#4014, TIMESTAMP#4015, DATETIME#4016, BINARY#4017, ARRAY#4018, MAP#4019, STRUCT#4020, VARCHAR#4021, CHAR#4022], HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2321, data_type#2322, comment#2323]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2321, data_type#2322, comment#2323]

== Optimized Logical Plan ==
CommandResult [col_name#2321, data_type#2322, comment#2323], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2321, data_type#2322, comment#2323]

== Physical Plan ==
CommandResult [col_name#2321, data_type#2322, comment#2323]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2321, data_type#2322, comment#2323]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2822, data_type#2823, comment#2824]
+- '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#2822, data_type#2823, comment#2824]

== Optimized Logical Plan ==
CommandResult [col_name#2822, data_type#2823, comment#2824], 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#2822, data_type#2823, comment#2824]

== Physical Plan ==
CommandResult [col_name#2822, data_type#2823, comment#2824]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2822, data_type#2823, comment#2824]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2375, data_type#2376, comment#2377]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2375, data_type#2376, comment#2377]

== Optimized Logical Plan ==
CommandResult [col_name#2375, data_type#2376, comment#2377], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2375, data_type#2376, comment#2377]

== Physical Plan ==
CommandResult [col_name#2375, data_type#2376, comment#2377]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2375, data_type#2376, comment#2377]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2225, data_type#2226, comment#2227]
+- '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#2225, data_type#2226, comment#2227]

== Optimized Logical Plan ==
CommandResult [col_name#2225, data_type#2226, comment#2227], 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#2225, data_type#2226, comment#2227]

== Physical Plan ==
CommandResult [col_name#2225, data_type#2226, comment#2227]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2225, data_type#2226, comment#2227]

== 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]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2081, data_type#2082, comment#2083]
+- '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#2081, data_type#2082, comment#2083]

== Optimized Logical Plan ==
CommandResult [col_name#2081, data_type#2082, comment#2083], 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#2081, data_type#2082, comment#2083]

== Physical Plan ==
CommandResult [col_name#2081, data_type#2082, comment#2083]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2081, data_type#2082, comment#2083]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2598, data_type#2599, comment#2600]
+- '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#2598, data_type#2599, comment#2600]

== Optimized Logical Plan ==
CommandResult [col_name#2598, data_type#2599, comment#2600], 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#2598, data_type#2599, comment#2600]

== Physical Plan ==
CommandResult [col_name#2598, data_type#2599, comment#2600]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2598, data_type#2599, comment#2600]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4584, data_type#4585, comment#4586]
+- '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#4584, data_type#4585, comment#4586]

== Optimized Logical Plan ==
CommandResult [col_name#4584, data_type#4585, comment#4586], 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#4584, data_type#4585, comment#4586]

== Physical Plan ==
CommandResult [col_name#4584, data_type#4585, comment#4586]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4584, data_type#4585, comment#4586]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3460, data_type#3461, comment#3462]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3460, data_type#3461, comment#3462]

== Optimized Logical Plan ==
CommandResult [col_name#3460, data_type#3461, comment#3462], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3460, data_type#3461, comment#3462]

== Physical Plan ==
CommandResult [col_name#3460, data_type#3461, comment#3462]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3460, data_type#3461, comment#3462]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2202, data_type#2203, comment#2204]
+- '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#2202, data_type#2203, comment#2204]

== Optimized Logical Plan ==
CommandResult [col_name#2202, data_type#2203, comment#2204], 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#2202, data_type#2203, comment#2204]

== Physical Plan ==
CommandResult [col_name#2202, data_type#2203, comment#2204]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2202, data_type#2203, comment#2204]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2845, data_type#2846, comment#2847]
+- '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#2845, data_type#2846, comment#2847]

== Optimized Logical Plan ==
CommandResult [col_name#2845, data_type#2846, comment#2847], 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#2845, data_type#2846, comment#2847]

== Physical Plan ==
CommandResult [col_name#2845, data_type#2846, comment#2847]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2845, data_type#2846, comment#2847]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4440, data_type#4441, comment#4442]
+- '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#4440, data_type#4441, comment#4442]

== Optimized Logical Plan ==
CommandResult [col_name#4440, data_type#4441, comment#4442], 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#4440, data_type#4441, comment#4442]

== Physical Plan ==
CommandResult [col_name#4440, data_type#4441, comment#4442]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4440, data_type#4441, comment#4442]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4728, data_type#4729, comment#4730]
+- '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#4728, data_type#4729, comment#4730]

== Optimized Logical Plan ==
CommandResult [col_name#4728, data_type#4729, comment#4730], 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#4728, data_type#4729, comment#4730]

== Physical Plan ==
CommandResult [col_name#4728, data_type#4729, comment#4730]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4728, data_type#4729, comment#4730]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4463, data_type#4464, comment#4465]
+- '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#4463, data_type#4464, comment#4465]

== Optimized Logical Plan ==
CommandResult [col_name#4463, data_type#4464, comment#4465], 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#4463, data_type#4464, comment#4465]

== Physical Plan ==
CommandResult [col_name#4463, data_type#4464, comment#4465]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4463, data_type#4464, comment#4465]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2477, data_type#2478, comment#2479]
+- '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#2477, data_type#2478, comment#2479]

== Optimized Logical Plan ==
CommandResult [col_name#2477, data_type#2478, comment#2479], 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#2477, data_type#2478, comment#2479]

== Physical Plan ==
CommandResult [col_name#2477, data_type#2478, comment#2479]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2477, data_type#2478, comment#2479]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2058, data_type#2059, comment#2060]
+- '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#2058, data_type#2059, comment#2060]

== Optimized Logical Plan ==
CommandResult [col_name#2058, data_type#2059, comment#2060], 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#2058, data_type#2059, comment#2060]

== Physical Plan ==
CommandResult [col_name#2058, data_type#2059, comment#2060]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2058, data_type#2059, comment#2060]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4163, data_type#4164, comment#4165]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4163, data_type#4164, comment#4165]

== Optimized Logical Plan ==
CommandResult [col_name#4163, data_type#4164, comment#4165], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4163, data_type#4164, comment#4165]

== Physical Plan ==
CommandResult [col_name#4163, data_type#4164, comment#4165]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4163, data_type#4164, comment#4165]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5471, data_type#5472, comment#5473]
+- '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#5471, data_type#5472, comment#5473]

== Optimized Logical Plan ==
CommandResult [col_name#5471, data_type#5472, comment#5473], 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#5471, data_type#5472, comment#5473]

== Physical Plan ==
CommandResult [col_name#5471, data_type#5472, comment#5473]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5471, data_type#5472, comment#5473]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2621, data_type#2622, comment#2623]
+- '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#2621, data_type#2622, comment#2623]

== Optimized Logical Plan ==
CommandResult [col_name#2621, data_type#2622, comment#2623], 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#2621, data_type#2622, comment#2623]

== Physical Plan ==
CommandResult [col_name#2621, data_type#2622, comment#2623]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2621, data_type#2622, comment#2623]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3856, data_type#3857, comment#3858]
+- '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#3856, data_type#3857, comment#3858]

== Optimized Logical Plan ==
CommandResult [col_name#3856, data_type#3857, comment#3858], 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#3856, data_type#3857, comment#3858]

== Physical Plan ==
CommandResult [col_name#3856, data_type#3857, comment#3858]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#3856, data_type#3857, comment#3858]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2454, data_type#2455, comment#2456]
+- '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#2454, data_type#2455, comment#2456]

== Optimized Logical Plan ==
CommandResult [col_name#2454, data_type#2455, comment#2456], 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#2454, data_type#2455, comment#2456]

== Physical Plan ==
CommandResult [col_name#2454, data_type#2455, comment#2456]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#2454, data_type#2455, comment#2456]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5304, data_type#5305, comment#5306]
+- '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#5304, data_type#5305, comment#5306]

== Optimized Logical Plan ==
CommandResult [col_name#5304, data_type#5305, comment#5306], 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#5304, data_type#5305, comment#5306]

== Physical Plan ==
CommandResult [col_name#5304, data_type#5305, comment#5306]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5304, data_type#5305, comment#5306]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5160, data_type#5161, comment#5162]
+- '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#5160, data_type#5161, comment#5162]

== Optimized Logical Plan ==
CommandResult [col_name#5160, data_type#5161, comment#5162], 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#5160, data_type#5161, comment#5162]

== Physical Plan ==
CommandResult [col_name#5160, data_type#5161, comment#5162]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5160, data_type#5161, comment#5162]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5016, data_type#5017, comment#5018]
+- '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#5016, data_type#5017, comment#5018]

== Optimized Logical Plan ==
CommandResult [col_name#5016, data_type#5017, comment#5018], 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#5016, data_type#5017, comment#5018]

== Physical Plan ==
CommandResult [col_name#5016, data_type#5017, comment#5018]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5016, data_type#5017, comment#5018]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2402, data_type#2403, comment#2404]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2402, data_type#2403, comment#2404]

== Optimized Logical Plan ==
CommandResult [col_name#2402, data_type#2403, comment#2404], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2402, data_type#2403, comment#2404]

== Physical Plan ==
CommandResult [col_name#2402, data_type#2403, comment#2404]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2402, data_type#2403, comment#2404]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3566, data_type#3567, comment#3568]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3566, data_type#3567, comment#3568]

== Optimized Logical Plan ==
CommandResult [col_name#3566, data_type#3567, comment#3568], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3566, data_type#3567, comment#3568]

== Physical Plan ==
CommandResult [col_name#3566, data_type#3567, comment#3568]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3566, data_type#3567, comment#3568]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3261, data_type#3262, comment#3263]
+- '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#3261, data_type#3262, comment#3263]

== Optimized Logical Plan ==
CommandResult [col_name#3261, data_type#3262, comment#3263], 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#3261, data_type#3262, comment#3263]

== Physical Plan ==
CommandResult [col_name#3261, data_type#3262, comment#3263]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#3261, data_type#3262, comment#3263]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4190, data_type#4191, comment#4192]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4190, data_type#4191, comment#4192]

== Optimized Logical Plan ==
CommandResult [col_name#4190, data_type#4191, comment#4192], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4190, data_type#4191, comment#4192]

== Physical Plan ==
CommandResult [col_name#4190, data_type#4191, comment#4192]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4190, data_type#4191, comment#4192]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3620, data_type#3621, comment#3622]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3620, data_type#3621, comment#3622]

== Optimized Logical Plan ==
CommandResult [col_name#3620, data_type#3621, comment#3622], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3620, data_type#3621, comment#3622]

== Physical Plan ==
CommandResult [col_name#3620, data_type#3621, comment#3622]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3620, data_type#3621, comment#3622]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5327, data_type#5328, comment#5329]
+- '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#5327, data_type#5328, comment#5329]

== Optimized Logical Plan ==
CommandResult [col_name#5327, data_type#5328, comment#5329], 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#5327, data_type#5328, comment#5329]

== Physical Plan ==
CommandResult [col_name#5327, data_type#5328, comment#5329]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5327, data_type#5328, comment#5329]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4895, data_type#4896, comment#4897]
+- '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#4895, data_type#4896, comment#4897]

== Optimized Logical Plan ==
CommandResult [col_name#4895, data_type#4896, comment#4897], 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#4895, data_type#4896, comment#4897]

== Physical Plan ==
CommandResult [col_name#4895, data_type#4896, comment#4897]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4895, data_type#4896, comment#4897]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5039, data_type#5040, comment#5041]
+- '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#5039, data_type#5040, comment#5041]

== Optimized Logical Plan ==
CommandResult [col_name#5039, data_type#5040, comment#5041], 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#5039, data_type#5040, comment#5041]

== Physical Plan ==
CommandResult [col_name#5039, data_type#5040, comment#5041]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5039, data_type#5040, comment#5041]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3182, data_type#3183, comment#3184]
+- 'UnresolvedTableOrView [default, AllTypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3182, data_type#3183, comment#3184]

== Optimized Logical Plan ==
CommandResult [col_name#3182, data_type#3183, comment#3184], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3182, data_type#3183, comment#3184]

== Physical Plan ==
CommandResult [col_name#3182, data_type#3183, comment#3184]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3182, data_type#3183, comment#3184]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4265, data_type#4266, comment#4267]
+- '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#4265, data_type#4266, comment#4267]

== Optimized Logical Plan ==
CommandResult [col_name#4265, data_type#4266, comment#4267], 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#4265, data_type#4266, comment#4267]

== Physical Plan ==
CommandResult [col_name#4265, data_type#4266, comment#4267]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4265, data_type#4266, comment#4267]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3833, data_type#3834, comment#3835]
+- '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#3833, data_type#3834, comment#3835]

== Optimized Logical Plan ==
CommandResult [col_name#3833, data_type#3834, comment#3835], 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#3833, data_type#3834, comment#3835]

== Physical Plan ==
CommandResult [col_name#3833, data_type#3834, comment#3835]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#3833, data_type#3834, comment#3835]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3101, data_type#3102, comment#3103]
+- 'UnresolvedTableOrView [default, AllTypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3101, data_type#3102, comment#3103]

== Optimized Logical Plan ==
CommandResult [col_name#3101, data_type#3102, comment#3103], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3101, data_type#3102, comment#3103]

== Physical Plan ==
CommandResult [col_name#3101, data_type#3102, comment#3103]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3101, data_type#3102, comment#3103]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4751, data_type#4752, comment#4753]
+- '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#4751, data_type#4752, comment#4753]

== Optimized Logical Plan ==
CommandResult [col_name#4751, data_type#4752, comment#4753], 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#4751, data_type#4752, comment#4753]

== Physical Plan ==
CommandResult [col_name#4751, data_type#4752, comment#4753]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4751, data_type#4752, comment#4753]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4607, data_type#4608, comment#4609]
+- '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#4607, data_type#4608, comment#4609]

== Optimized Logical Plan ==
CommandResult [col_name#4607, data_type#4608, comment#4609], 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#4607, data_type#4608, comment#4609]

== Physical Plan ==
CommandResult [col_name#4607, data_type#4608, comment#4609]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4607, data_type#4608, comment#4609]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4872, data_type#4873, comment#4874]
+- '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#4872, data_type#4873, comment#4874]

== Optimized Logical Plan ==
CommandResult [col_name#4872, data_type#4873, comment#4874], 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#4872, data_type#4873, comment#4874]

== Physical Plan ==
CommandResult [col_name#4872, data_type#4873, comment#4874]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4872, data_type#4873, comment#4874]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5183, data_type#5184, comment#5185]
+- '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#5183, data_type#5184, comment#5185]

== Optimized Logical Plan ==
CommandResult [col_name#5183, data_type#5184, comment#5185], 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#5183, data_type#5184, comment#5185]

== Physical Plan ==
CommandResult [col_name#5183, data_type#5184, comment#5185]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5183, data_type#5184, comment#5185]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3284, data_type#3285, comment#3286]
+- '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#3284, data_type#3285, comment#3286]

== Optimized Logical Plan ==
CommandResult [col_name#3284, data_type#3285, comment#3286], 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#3284, data_type#3285, comment#3286]

== Physical Plan ==
CommandResult [col_name#3284, data_type#3285, comment#3286]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#3284, data_type#3285, comment#3286]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4242, data_type#4243, comment#4244]
+- '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#4242, data_type#4243, comment#4244]

== Optimized Logical Plan ==
CommandResult [col_name#4242, data_type#4243, comment#4244], 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#4242, data_type#4243, comment#4244]

== Physical Plan ==
CommandResult [col_name#4242, data_type#4243, comment#4244]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#4242, data_type#4243, comment#4244]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5592, data_type#5593, comment#5594]
+- '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#5592, data_type#5593, comment#5594]

== Optimized Logical Plan ==
CommandResult [col_name#5592, data_type#5593, comment#5594], 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#5592, data_type#5593, comment#5594]

== Physical Plan ==
CommandResult [col_name#5592, data_type#5593, comment#5594]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5592, data_type#5593, comment#5594]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5615, data_type#5616, comment#5617]
+- '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#5615, data_type#5616, comment#5617]

== Optimized Logical Plan ==
CommandResult [col_name#5615, data_type#5616, comment#5617], 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#5615, data_type#5616, comment#5617]

== Physical Plan ==
CommandResult [col_name#5615, data_type#5616, comment#5617]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5615, data_type#5616, comment#5617]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#5448, data_type#5449, comment#5450]
+- '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#5448, data_type#5449, comment#5450]

== Optimized Logical Plan ==
CommandResult [col_name#5448, data_type#5449, comment#5450], 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#5448, data_type#5449, comment#5450]

== Physical Plan ==
CommandResult [col_name#5448, data_type#5449, comment#5450]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`airports`, false, [col_name#5448, data_type#5449, comment#5450]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3128, data_type#3129, comment#3130]
+- 'UnresolvedTableOrView [default, AllTypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3128, data_type#3129, comment#3130]

== Optimized Logical Plan ==
CommandResult [col_name#3128, data_type#3129, comment#3130], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3128, data_type#3129, comment#3130]

== Physical Plan ==
CommandResult [col_name#3128, data_type#3129, comment#3130]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3128, data_type#3129, comment#3130]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#2348, data_type#2349, comment#2350]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2348, data_type#2349, comment#2350]

== Optimized Logical Plan ==
CommandResult [col_name#2348, data_type#2349, comment#2350], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2348, data_type#2349, comment#2350]

== Physical Plan ==
CommandResult [col_name#2348, data_type#2349, comment#2350]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#2348, data_type#2349, comment#2350]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4361, data_type#4362, comment#4363]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4361, data_type#4362, comment#4363]

== Optimized Logical Plan ==
CommandResult [col_name#4361, data_type#4362, comment#4363], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4361, data_type#4362, comment#4363]

== Physical Plan ==
CommandResult [col_name#4361, data_type#4362, comment#4363]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4361, data_type#4362, comment#4363]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#4388, data_type#4389, comment#4390]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4388, data_type#4389, comment#4390]

== Optimized Logical Plan ==
CommandResult [col_name#4388, data_type#4389, comment#4390], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4388, data_type#4389, comment#4390]

== Physical Plan ==
CommandResult [col_name#4388, data_type#4389, comment#4390]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#4388, data_type#4389, comment#4390]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3487, data_type#3488, comment#3489]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3487, data_type#3488, comment#3489]

== Optimized Logical Plan ==
CommandResult [col_name#3487, data_type#3488, comment#3489], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3487, data_type#3488, comment#3489]

== Physical Plan ==
CommandResult [col_name#3487, data_type#3488, comment#3489]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3487, data_type#3488, comment#3489]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3155, data_type#3156, comment#3157]
+- 'UnresolvedTableOrView [default, AllTypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3155, data_type#3156, comment#3157]

== Optimized Logical Plan ==
CommandResult [col_name#3155, data_type#3156, comment#3157], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3155, data_type#3156, comment#3157]

== Physical Plan ==
CommandResult [col_name#3155, data_type#3156, comment#3157]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3155, data_type#3156, comment#3157]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3952, data_type#3953, comment#3954]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3952, data_type#3953, comment#3954]

== Optimized Logical Plan ==
CommandResult [col_name#3952, data_type#3953, comment#3954], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3952, data_type#3953, comment#3954]

== Physical Plan ==
CommandResult [col_name#3952, data_type#3953, comment#3954]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3952, data_type#3953, comment#3954]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3209, data_type#3210, comment#3211]
+- 'UnresolvedTableOrView [default, AllTypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3209, data_type#3210, comment#3211]

== Optimized Logical Plan ==
CommandResult [col_name#3209, data_type#3210, comment#3211], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3209, data_type#3210, comment#3211]

== Physical Plan ==
CommandResult [col_name#3209, data_type#3210, comment#3211]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3209, data_type#3210, comment#3211]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3674, data_type#3675, comment#3676]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3674, data_type#3675, comment#3676]

== Optimized Logical Plan ==
CommandResult [col_name#3674, data_type#3675, comment#3676], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3674, data_type#3675, comment#3676]

== Physical Plan ==
CommandResult [col_name#3674, data_type#3675, comment#3676]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3674, data_type#3675, comment#3676]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3593, data_type#3594, comment#3595]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3593, data_type#3594, comment#3595]

== Optimized Logical Plan ==
CommandResult [col_name#3593, data_type#3594, comment#3595], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3593, data_type#3594, comment#3595]

== Physical Plan ==
CommandResult [col_name#3593, data_type#3594, comment#3595]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3593, data_type#3594, comment#3595]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3701, data_type#3702, comment#3703]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3701, data_type#3702, comment#3703]

== Optimized Logical Plan ==
CommandResult [col_name#3701, data_type#3702, comment#3703], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3701, data_type#3702, comment#3703]

== Physical Plan ==
CommandResult [col_name#3701, data_type#3702, comment#3703]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3701, data_type#3702, comment#3703]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3979, data_type#3980, comment#3981]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3979, data_type#3980, comment#3981]

== Optimized Logical Plan ==
CommandResult [col_name#3979, data_type#3980, comment#3981], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3979, data_type#3980, comment#3981]

== Physical Plan ==
CommandResult [col_name#3979, data_type#3980, comment#3981]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3979, data_type#3980, comment#3981]

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3647, data_type#3648, comment#3649]
+- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true

== Analyzed Logical Plan ==
col_name: string, data_type: string, comment: string
DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3647, data_type#3648, comment#3649]

== Optimized Logical Plan ==
CommandResult [col_name#3647, data_type#3648, comment#3649], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]]
   +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3647, data_type#3648, comment#3649]

== Physical Plan ==
CommandResult [col_name#3647, data_type#3648, comment#3649]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3647, data_type#3648, comment#3649]