update mr job and redshift schema for hover event