== Parsed Logical Plan ==
GlobalLimit 11
+- LocalLimit 11
+- Project [cast(number#16 as string) AS number#189, cast(hash#17 as string) AS hash#190, cast(parent_hash#18 as string) AS parent_hash#191, cast(nonce#19 as string) AS nonce#192, cast(sha3_uncles#20 as string) AS sha3_uncles#193, cast(logs_bloom#21 as string) AS logs_bloom#194, cast(transactions_root#22 as string) AS transactions_root#195, cast(state_root#23 as string) AS state_root#196, cast(receipts_root#24 as string) AS receipts_root#197, cast(miner#25 as string) AS miner#198, cast(difficulty#26L as string) AS difficulty#199, cast(total_difficulty#27 as string) AS total_difficulty#200, cast(size#28 as string) AS size#201, cast(extra_data#29 as string) AS extra_data#202, cast(gas_limit#30 as string) AS gas_limit#203, cast(gas_used#31 as string) AS gas_used#204, cast(timestamp#32 as string) AS timestamp#205, cast(transaction_count#33 as string) AS transaction_count#206, cast(base_fee_per_gas#34 as string) AS base_fee_per_gas#207, cast(formatted_date#136 as string) AS formatted_date#208]
+- Project [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, from_unixtime(cast(timestamp#32 as bigint), yyyy-MM-dd, Some(GMT)) AS formatted_date#136]
+- 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 ==
number: string, hash: string, parent_hash: string, nonce: string, sha3_uncles: string, logs_bloom: string, transactions_root: string, state_root: string, receipts_root: string, miner: string, difficulty: string, total_difficulty: string, size: string, extra_data: string, gas_limit: string, gas_used: string, timestamp: string, transaction_count: string, base_fee_per_gas: string, formatted_date: string
GlobalLimit 11
+- LocalLimit 11
+- Project [cast(number#16 as string) AS number#189, cast(hash#17 as string) AS hash#190, cast(parent_hash#18 as string) AS parent_hash#191, cast(nonce#19 as string) AS nonce#192, cast(sha3_uncles#20 as string) AS sha3_uncles#193, cast(logs_bloom#21 as string) AS logs_bloom#194, cast(transactions_root#22 as string) AS transactions_root#195, cast(state_root#23 as string) AS state_root#196, cast(receipts_root#24 as string) AS receipts_root#197, cast(miner#25 as string) AS miner#198, cast(difficulty#26L as string) AS difficulty#199, cast(total_difficulty#27 as string) AS total_difficulty#200, cast(size#28 as string) AS size#201, cast(extra_data#29 as string) AS extra_data#202, cast(gas_limit#30 as string) AS gas_limit#203, cast(gas_used#31 as string) AS gas_used#204, cast(timestamp#32 as string) AS timestamp#205, cast(transaction_count#33 as string) AS transaction_count#206, cast(base_fee_per_gas#34 as string) AS base_fee_per_gas#207, cast(formatted_date#136 as string) AS formatted_date#208]
+- Project [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, from_unixtime(cast(timestamp#32 as bigint), yyyy-MM-dd, Some(GMT)) AS formatted_date#136]
+- 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 ==
GlobalLimit 11
+- LocalLimit 11
+- Project [cast(number#16 as string) AS number#189, hash#17, parent_hash#18, nonce#19, sha3_uncles#20, logs_bloom#21, transactions_root#22, state_root#23, receipts_root#24, miner#25, cast(difficulty#26L as string) AS difficulty#199, cast(total_difficulty#27 as string) AS total_difficulty#200, cast(size#28 as string) AS size#201, extra_data#29, cast(gas_limit#30 as string) AS gas_limit#203, cast(gas_used#31 as string) AS gas_used#204, cast(timestamp#32 as string) AS timestamp#205, cast(transaction_count#33 as string) AS transaction_count#206, base_fee_per_gas#34, from_unixtime(cast(timestamp#32 as bigint), yyyy-MM-dd, Some(GMT)) AS formatted_date#208]
+- 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 ==
CollectLimit 11
+- *(1) Project [cast(number#16 as string) AS number#189, hash#17, parent_hash#18, nonce#19, sha3_uncles#20, logs_bloom#21, transactions_root#22, state_root#23, receipts_root#24, miner#25, cast(difficulty#26L as string) AS difficulty#199, cast(total_difficulty#27 as string) AS total_difficulty#200, cast(size#28 as string) AS size#201, extra_data#29, cast(gas_limit#30 as string) AS gas_limit#203, cast(gas_used#31 as string) AS gas_used#204, cast(timestamp#32 as string) AS timestamp#205, cast(transaction_count#33 as string) AS transaction_count#206, base_fee_per_gas#34, from_unixtime(cast(timestamp#32 as bigint), yyyy-MM-dd, Some(GMT)) AS formatted_date#208]
+- FileScan csv [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] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex[s3a://data-repository-bkt/ECS765/ethereum/blocks.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<number:int,hash:string,parent_hash:string,nonce:string,sha3_uncles:string,logs_bloom:strin...
