Police have fatally shot a knife-wielding man on a cable of New York City's Brooklyn Bridge after he ignored orders to drop the weapon and came within feet of an officer.