https://eelsupernova.pages.dev/posts/hive-join-subquery-tutorial-with-examples1240499/