digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
}
3 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 6<br>number of files read: 51<br>metadata time: 1 ms<br>size of files read: 8.1 GiB"];
2->0;
3->2;
}
4
CollectLimit 6
Project [toprettystring(ride_id#127, Some(Etc/UTC)) AS toprettystring(ride_id)#166, toprettystring(rideable_type#128, Some(Etc/UTC)) AS toprettystring(rideable_type)#167, toprettystring(started_at#129, Some(Etc/UTC)) AS toprettystring(started_at)#168, toprettystring(ended_at#130, Some(Etc/UTC)) AS toprettystring(ended_at)#169, toprettystring(start_station_name#131, Some(Etc/UTC)) AS toprettystring(start_station_name)#170, toprettystring(start_station_id#132, Some(Etc/UTC)) AS toprettystring(start_station_id)#171, toprettystring(end_station_name#133, Some(Etc/UTC)) AS toprettystring(end_station_name)#172, toprettystring(end_station_id#134, Some(Etc/UTC)) AS toprettystring(end_station_id)#173, toprettystring(start_lat#135, Some(Etc/UTC)) AS toprettystring(start_lat)#174, toprettystring(start_lng#136, Some(Etc/UTC)) AS toprettystring(start_lng)#175, toprettystring(end_lat#137, Some(Etc/UTC)) AS toprettystring(end_lat)#176, toprettystring(end_lng#138, Some(Etc/UTC)) AS toprettystring(end_lng)#177, toprettystring(member_casual#139, Some(Etc/UTC)) AS toprettystring(member_casual)#178]
WholeStageCodegen (1)
FileScan csv [ride_id#127,rideable_type#128,started_at#129,ended_at#130,start_station_name#131,start_station_id#132,end_station_name#133,end_station_id#134,start_lat#135,start_lng#136,end_lat#137,end_lng#138,member_casual#139] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(51 paths)[s3a://rzvde-g8-cheremisin-daniil/raw/citibike_data/202503/202503-citi..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ride_id:string,rideable_type:string,started_at:timestamp,ended_at:timestamp,start_station_...
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- Scan csv (1)
(1) Scan csv
Output [13]: [ride_id#127, rideable_type#128, started_at#129, ended_at#130, start_station_name#131, start_station_id#132, end_station_name#133, end_station_id#134, start_lat#135, start_lng#136, end_lat#137, end_lng#138, member_casual#139]
Batched: false
Location: InMemoryFileIndex [s3a://rzvde-g8-cheremisin-daniil/raw/citibike_data/202503/202503-citibike-tripdata_1.csv, ... 50 entries]
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) Project [codegen id : 1]
Output [13]: [toprettystring(ride_id#127, Some(Etc/UTC)) AS toprettystring(ride_id)#166, toprettystring(rideable_type#128, Some(Etc/UTC)) AS toprettystring(rideable_type)#167, toprettystring(started_at#129, Some(Etc/UTC)) AS toprettystring(started_at)#168, toprettystring(ended_at#130, Some(Etc/UTC)) AS toprettystring(ended_at)#169, toprettystring(start_station_name#131, Some(Etc/UTC)) AS toprettystring(start_station_name)#170, toprettystring(start_station_id#132, Some(Etc/UTC)) AS toprettystring(start_station_id)#171, toprettystring(end_station_name#133, Some(Etc/UTC)) AS toprettystring(end_station_name)#172, toprettystring(end_station_id#134, Some(Etc/UTC)) AS toprettystring(end_station_id)#173, toprettystring(start_lat#135, Some(Etc/UTC)) AS toprettystring(start_lat)#174, toprettystring(start_lng#136, Some(Etc/UTC)) AS toprettystring(start_lng)#175, toprettystring(end_lat#137, Some(Etc/UTC)) AS toprettystring(end_lat)#176, toprettystring(end_lng#138, Some(Etc/UTC)) AS toprettystring(end_lng)#177, toprettystring(member_casual#139, Some(Etc/UTC)) AS toprettystring(member_casual)#178]
Input [13]: [ride_id#127, rideable_type#128, started_at#129, ended_at#130, start_station_name#131, start_station_id#132, end_station_name#133, end_station_id#134, start_lat#135, start_lng#136, end_lat#137, end_lng#138, member_casual#139]
(3) CollectLimit
Input [13]: [toprettystring(ride_id)#166, toprettystring(rideable_type)#167, toprettystring(started_at)#168, toprettystring(ended_at)#169, toprettystring(start_station_name)#170, toprettystring(start_station_id)#171, toprettystring(end_station_name)#172, toprettystring(end_station_id)#173, toprettystring(start_lat)#174, toprettystring(start_lng)#175, toprettystring(end_lat)#176, toprettystring(end_lng)#177, toprettystring(member_casual)#178]
Arguments: 6