udpate hive scripts to correct case
create partitions automatically