Adjustments for hive query