digraph G {
0 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
1 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 31,257<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 5.8 MiB"];
1->0;
}
2
TakeOrderedAndProject(limit=6, orderBy=[ride_id#9482 ASC NULLS FIRST], output=[toprettystring(ride_id)#9631,toprettystring(rideable_type)#9632,toprettystring(started_at)#9633,toprettystring(ended_at)#9634,toprettystring(start_station_name)#9635,toprettystring(start_station_id)#9636,toprettystring(end_station_name)#9637,toprettystring(end_station_id)#9638,toprettystring(start_lat)#9639,toprettystring(start_lng)#9640,toprettystring(end_lat)#9641,toprettystring(end_lng)#9642,toprettystring(member_casual)#9643])
FileScan csv [ride_id#9482,rideable_type#9483,started_at#9484,ended_at#9485,start_station_name#9486,start_station_id#9487,end_station_name#9488,end_station_id#9489,start_lat#9490,start_lng#9491,end_lat#9492,end_lng#9493,member_casual#9494] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[s3a://rzvde-g8-kirsanov-dmitry/raw/citibike_data/202502/202502-citibik..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ride_id:string,rideable_type:string,started_at:timestamp,ended_at:timestamp,start_station_...
== Physical Plan ==
TakeOrderedAndProject (2)
+- Scan csv (1)
(1) Scan csv
Output [13]: [ride_id#9482, rideable_type#9483, started_at#9484, ended_at#9485, start_station_name#9486, start_station_id#9487, end_station_name#9488, end_station_id#9489, start_lat#9490, start_lng#9491, end_lat#9492, end_lng#9493, member_casual#9494]
Batched: false
Location: InMemoryFileIndex [s3a://rzvde-g8-kirsanov-dmitry/raw/citibike_data/202502/202502-citibike-tripdata-part00.csv]
ReadSchema: struct<ride_id:string,rideable_type:string,started_at:timestamp,ended_at:timestamp,start_station_name:string,start_station_id:string,end_station_name:string,end_station_id:string,start_lat:double,start_lng:double,end_lat:double,end_lng:double,member_casual:string>
(2) TakeOrderedAndProject
Input [13]: [ride_id#9482, rideable_type#9483, started_at#9484, ended_at#9485, start_station_name#9486, start_station_id#9487, end_station_name#9488, end_station_id#9489, start_lat#9490, start_lng#9491, end_lat#9492, end_lng#9493, member_casual#9494]
Arguments: 6, [ride_id#9482 ASC NULLS FIRST], [toprettystring(ride_id#9482, Some(Etc/UTC)) AS toprettystring(ride_id)#9631, toprettystring(rideable_type#9483, Some(Etc/UTC)) AS toprettystring(rideable_type)#9632, toprettystring(started_at#9484, Some(Etc/UTC)) AS toprettystring(started_at)#9633, toprettystring(ended_at#9485, Some(Etc/UTC)) AS toprettystring(ended_at)#9634, toprettystring(start_station_name#9486, Some(Etc/UTC)) AS toprettystring(start_station_name)#9635, toprettystring(start_station_id#9487, Some(Etc/UTC)) AS toprettystring(start_station_id)#9636, toprettystring(end_station_name#9488, Some(Etc/UTC)) AS toprettystring(end_station_name)#9637, toprettystring(end_station_id#9489, Some(Etc/UTC)) AS toprettystring(end_station_id)#9638, toprettystring(start_lat#9490, Some(Etc/UTC)) AS toprettystring(start_lat)#9639, toprettystring(start_lng#9491, Some(Etc/UTC)) AS toprettystring(start_lng)#9640, toprettystring(end_lat#9492, Some(Etc/UTC)) AS toprettystring(end_lat)#9641, toprettystring(end_lng#9493, Some(Etc/UTC)) AS toprettystring(end_lng)#9642, toprettystring(member_casual#9494, Some(Etc/UTC)) AS toprettystring(member_casual)#9643]