documentation and additional hive queries