added scratch query for hive