== Parsed Logical Plan ==
GlobalLimit 6
+- LocalLimit 6
+- Project [cast(id#80 as string) AS id#93, cast(Borough#73 as string) AS Borough#94, cast(Zone#74 as string) AS Zone#95, cast(service_zone#75 as string) AS service_zone#96]
+- Project [LocationID#72 AS id#80, Borough#73, Zone#74, service_zone#75]
+- Relation[LocationID#72,Borough#73,Zone#74,service_zone#75] csv
== Analyzed Logical Plan ==
id: string, Borough: string, Zone: string, service_zone: string
GlobalLimit 6
+- LocalLimit 6
+- Project [cast(id#80 as string) AS id#93, cast(Borough#73 as string) AS Borough#94, cast(Zone#74 as string) AS Zone#95, cast(service_zone#75 as string) AS service_zone#96]
+- Project [LocationID#72 AS id#80, Borough#73, Zone#74, service_zone#75]
+- Relation[LocationID#72,Borough#73,Zone#74,service_zone#75] csv
== Optimized Logical Plan ==
GlobalLimit 6
+- LocalLimit 6
+- Project [cast(LocationID#72 as string) AS id#93, Borough#73, Zone#74, service_zone#75]
+- Relation[LocationID#72,Borough#73,Zone#74,service_zone#75] csv
== Physical Plan ==
CollectLimit 6
+- *(1) Project [cast(LocationID#72 as string) AS id#93, Borough#73, Zone#74, service_zone#75]
+- FileScan csv [LocationID#72,Borough#73,Zone#74,service_zone#75] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[s3a://data-repository-bkt/ECS765/nyc_taxi/taxi_zone_lookup.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<LocationID:int,Borough:string,Zone:string,service_zone:string>