Yes @databaron
about your query, it's already answered in the post, we've provided full details above.
It mostly comes from snap as far as I recall.
You should try hivesuite
Have a good day