pulls related hive data