updated Hive commands for batch view