Since I can understand the efforts in your post! I rarely give discoveryit, but here u go........

!discovery

also, an invitation to read my recent data driven and coding post cause u can see some outputs or either give me new coding challenges and may just reuse my codes to improve your own calculations about hive.