== Parsed Logical Plan ==
GlobalLimit 21
+- LocalLimit 21
+- Project [cast(src#185 as string) AS src#231, cast(dst#186 as string) AS dst#232, cast(Trip Miles#21 as string) AS Trip Miles#233, cast(Trip Seconds#20 as string) AS Trip Seconds#234, cast(Fare#26 as string) AS Fare#235]
+- GlobalLimit 5
+- LocalLimit 5
+- Project [Pickup Community Area#24 AS src#185, Dropoff Community Area#25 AS dst#186, Trip Miles#21, Trip Seconds#20, Fare#26]
+- Relation[Trip ID#16,Taxi ID#17,Trip Start Timestamp#18,Trip End Timestamp#19,Trip Seconds#20,Trip Miles#21,Pickup Census Tract#22,Dropoff Census Tract#23,Pickup Community Area#24,Dropoff Community Area#25,Fare#26,Tips#27,Tolls#28,Extras#29,Trip Total#30,Payment Type#31,Company#32,Pickup Centroid Latitude#33,Pickup Centroid Longitude#34,Pickup Centroid Location#35,Dropoff Centroid Latitude#36,Dropoff Centroid Longitude#37,Dropoff Centroid Location#38] csv
== Analyzed Logical Plan ==
src: string, dst: string, Trip Miles: string, Trip Seconds: string, Fare: string
GlobalLimit 21
+- LocalLimit 21
+- Project [cast(src#185 as string) AS src#231, cast(dst#186 as string) AS dst#232, cast(Trip Miles#21 as string) AS Trip Miles#233, cast(Trip Seconds#20 as string) AS Trip Seconds#234, cast(Fare#26 as string) AS Fare#235]
+- GlobalLimit 5
+- LocalLimit 5
+- Project [Pickup Community Area#24 AS src#185, Dropoff Community Area#25 AS dst#186, Trip Miles#21, Trip Seconds#20, Fare#26]
+- Relation[Trip ID#16,Taxi ID#17,Trip Start Timestamp#18,Trip End Timestamp#19,Trip Seconds#20,Trip Miles#21,Pickup Census Tract#22,Dropoff Census Tract#23,Pickup Community Area#24,Dropoff Community Area#25,Fare#26,Tips#27,Tolls#28,Extras#29,Trip Total#30,Payment Type#31,Company#32,Pickup Centroid Latitude#33,Pickup Centroid Longitude#34,Pickup Centroid Location#35,Dropoff Centroid Latitude#36,Dropoff Centroid Longitude#37,Dropoff Centroid Location#38] csv
== Optimized Logical Plan ==
GlobalLimit 5
+- LocalLimit 5
+- Project [Pickup Community Area#24 AS src#185, Dropoff Community Area#25 AS dst#186, Trip Miles#21, Trip Seconds#20, Fare#26]
+- Relation[Trip ID#16,Taxi ID#17,Trip Start Timestamp#18,Trip End Timestamp#19,Trip Seconds#20,Trip Miles#21,Pickup Census Tract#22,Dropoff Census Tract#23,Pickup Community Area#24,Dropoff Community Area#25,Fare#26,Tips#27,Tolls#28,Extras#29,Trip Total#30,Payment Type#31,Company#32,Pickup Centroid Latitude#33,Pickup Centroid Longitude#34,Pickup Centroid Location#35,Dropoff Centroid Latitude#36,Dropoff Centroid Longitude#37,Dropoff Centroid Location#38] csv
== Physical Plan ==
CollectLimit 5
+- *(1) Project [Pickup Community Area#24 AS src#185, Dropoff Community Area#25 AS dst#186, Trip Miles#21, Trip Seconds#20, Fare#26]
+- FileScan csv [Trip Seconds#20,Trip Miles#21,Pickup Community Area#24,Dropoff Community Area#25,Fare#26] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[s3a://data-repository-bkt/ECS765/Chicago_Taxitrips/chicago_taxi_trips.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Trip Seconds:string,Trip Miles:string,Pickup Community Area:string,Dropoff Community Area:...
