fix for hive syntax error