== Parsed Logical Plan ==
InsertIntoHadoopFsRelationCommand s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56, false, CSV, Map(header -> true, path -> s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56), ErrorIfExists, [miner, total_size]
+- GlobalLimit 10
+- LocalLimit 10
+- Project [miner#25, size#28 AS total_size#100]
+- Sort [size#28 DESC NULLS LAST], true
+- Relation[number#16,hash#17,parent_hash#18,nonce#19,sha3_uncles#20,logs_bloom#21,transactions_root#22,state_root#23,receipts_root#24,miner#25,difficulty#26L,total_difficulty#27,size#28,extra_data#29,gas_limit#30,gas_used#31,timestamp#32,transaction_count#33,base_fee_per_gas#34] csv
== Analyzed Logical Plan ==
InsertIntoHadoopFsRelationCommand s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56, false, CSV, Map(header -> true, path -> s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56), ErrorIfExists, [miner, total_size]
+- GlobalLimit 10
+- LocalLimit 10
+- Project [miner#25, size#28 AS total_size#100]
+- Sort [size#28 DESC NULLS LAST], true
+- Relation[number#16,hash#17,parent_hash#18,nonce#19,sha3_uncles#20,logs_bloom#21,transactions_root#22,state_root#23,receipts_root#24,miner#25,difficulty#26L,total_difficulty#27,size#28,extra_data#29,gas_limit#30,gas_used#31,timestamp#32,transaction_count#33,base_fee_per_gas#34] csv
== Optimized Logical Plan ==
InsertIntoHadoopFsRelationCommand s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56, false, CSV, Map(header -> true, path -> s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56), ErrorIfExists, [miner, total_size]
+- GlobalLimit 10
+- LocalLimit 10
+- Project [miner#25, size#28 AS total_size#100]
+- Sort [size#28 DESC NULLS LAST], true
+- Project [miner#25, size#28]
+- Relation[number#16,hash#17,parent_hash#18,nonce#19,sha3_uncles#20,logs_bloom#21,transactions_root#22,state_root#23,receipts_root#24,miner#25,difficulty#26L,total_difficulty#27,size#28,extra_data#29,gas_limit#30,gas_used#31,timestamp#32,transaction_count#33,base_fee_per_gas#34] csv
== Physical Plan ==
Execute InsertIntoHadoopFsRelationCommand s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56, false, CSV, Map(header -> true, path -> s3a://object-bucket-ec24134-2051494c-a79b-467c-8cc6-85a4b996b509/ethereum_results/top10_blocks_21-12-2024_16:51:56), ErrorIfExists, [miner, total_size]
+- TakeOrderedAndProject(limit=10, orderBy=[size#28 DESC NULLS LAST], output=[miner#25,total_size#100])
+- FileScan csv [miner#25,size#28] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[s3a://data-repository-bkt/ECS765/ethereum/blocks.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<miner:string,size:int>
