latest versions of hive queries to prepare interim tables