== Parsed Logical Plan ==
GlobalLimit 6
+- LocalLimit 6
+- Project [cast(tpep_pickup_datetime#70 as string) AS tpep_pickup_datetime#139, cast(tpep_dropoff_datetime#71 as string) AS tpep_dropoff_datetime#140, cast(passenger_count#72 as string) AS passenger_count#141, cast(trip_distance#73 as string) AS trip_distance#142, cast(PULocationID#74 as string) AS PULocationID#143, cast(DOLocationID#75 as string) AS DOLocationID#144, cast(payment_type#76 as string) AS payment_type#145, cast(fare_amount#77 as string) AS fare_amount#146, cast(extra#78 as string) AS extra#147, cast(mta_tax#79 as string) AS mta_tax#148, cast(tip_amount#80 as string) AS tip_amount#149, cast(tolls_amount#81 as string) AS tolls_amount#150, cast(total_amount#82 as string) AS total_amount#151, cast(congestion_surcharge#83 as string) AS congestion_surcharge#152, cast(airport_fee#84 as string) AS airport_fee#153, cast(taxi_type#85 as string) AS taxi_type#154]
+- Relation[tpep_pickup_datetime#70,tpep_dropoff_datetime#71,passenger_count#72,trip_distance#73,PULocationID#74,DOLocationID#75,payment_type#76,fare_amount#77,extra#78,mta_tax#79,tip_amount#80,tolls_amount#81,total_amount#82,congestion_surcharge#83,airport_fee#84,taxi_type#85] csv
== Analyzed Logical Plan ==
tpep_pickup_datetime: string, tpep_dropoff_datetime: string, passenger_count: string, trip_distance: string, PULocationID: string, DOLocationID: string, payment_type: string, fare_amount: string, extra: string, mta_tax: string, tip_amount: string, tolls_amount: string, total_amount: string, congestion_surcharge: string, airport_fee: string, taxi_type: string
GlobalLimit 6
+- LocalLimit 6
+- Project [cast(tpep_pickup_datetime#70 as string) AS tpep_pickup_datetime#139, cast(tpep_dropoff_datetime#71 as string) AS tpep_dropoff_datetime#140, cast(passenger_count#72 as string) AS passenger_count#141, cast(trip_distance#73 as string) AS trip_distance#142, cast(PULocationID#74 as string) AS PULocationID#143, cast(DOLocationID#75 as string) AS DOLocationID#144, cast(payment_type#76 as string) AS payment_type#145, cast(fare_amount#77 as string) AS fare_amount#146, cast(extra#78 as string) AS extra#147, cast(mta_tax#79 as string) AS mta_tax#148, cast(tip_amount#80 as string) AS tip_amount#149, cast(tolls_amount#81 as string) AS tolls_amount#150, cast(total_amount#82 as string) AS total_amount#151, cast(congestion_surcharge#83 as string) AS congestion_surcharge#152, cast(airport_fee#84 as string) AS airport_fee#153, cast(taxi_type#85 as string) AS taxi_type#154]
+- Relation[tpep_pickup_datetime#70,tpep_dropoff_datetime#71,passenger_count#72,trip_distance#73,PULocationID#74,DOLocationID#75,payment_type#76,fare_amount#77,extra#78,mta_tax#79,tip_amount#80,tolls_amount#81,total_amount#82,congestion_surcharge#83,airport_fee#84,taxi_type#85] csv
== Optimized Logical Plan ==
GlobalLimit 6
+- LocalLimit 6
+- Relation[tpep_pickup_datetime#70,tpep_dropoff_datetime#71,passenger_count#72,trip_distance#73,PULocationID#74,DOLocationID#75,payment_type#76,fare_amount#77,extra#78,mta_tax#79,tip_amount#80,tolls_amount#81,total_amount#82,congestion_surcharge#83,airport_fee#84,taxi_type#85] csv
== Physical Plan ==
CollectLimit 6
+- FileScan csv [tpep_pickup_datetime#70,tpep_dropoff_datetime#71,passenger_count#72,trip_distance#73,PULocationID#74,DOLocationID#75,payment_type#76,fare_amount#77,extra#78,mta_tax#79,tip_amount#80,tolls_amount#81,total_amount#82,congestion_surcharge#83,airport_fee#84,taxi_type#85] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[s3a://data-repository-bkt/ECS765/nyc_taxi/yellow_tripdata/2023], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<tpep_pickup_datetime:string,tpep_dropoff_datetime:string,passenger_count:string,trip_dista...
