adding scratch query to cdh hive