added hive queries