A disgruntled employee who fatally shot one person and held another hostage on Thursday at a restaurant in downtown Charleston, South Carolina, was shot by police, the city's mayor said.