Unleash the Power of Presto Interactive SQL Querying on Ethereum Blockchain
Presto is a powerful interactive querying engine that enables running SQL queries on anything -- be it MySQL, HDFS, local file, Kafka -- as long as there exist a connector to the source.
This is a Presto connector to the Ethereum blockchain data. With this connector, one can get hands on with Ethereum blockchain analytics work without having to know how to play with the nitty gritty Javascript API.
Showing all the tables available
Schema of the block table
Schema of the transaction table
Get the top miners based on blocks mined within a block range
Get the top accounts based on values going out within a block range
- Have an Ethereum client(Geth, Parity) running locally. TODO: Infura support coming soon
- Install Presto
- Clone this repo and run
mvn clean installto build the plugin jar - Load the plugin to Presto