Dear all, I prepared a small Serde to analyze Bitcoin blockchain data with Hive: https://snippetessay.wordpress.com/2016/04/28/hive-bitcoin-analytics-on-blockchain-data-with-sql/
There are some example queries, but I will add some in the future. Additionally, more unit tests will be added. Let me know if this is useful for you and of course please report bugs ;) Thank you. Cheers