A judge in Cincinnati has dismissed charges against a white police officer who fatally shot an unarmed black motorist, after a prosecutor declined to pursue a third murder trial.