user: Question: Who is the vacator when South Carolina 4th is the district?
Columns: ['District', 'Vacator', 'Reason for change', 'Successor', 'Date successor seated']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Kentucky 7th', 'George Robertson (DR)', 'resigned before Congress met', 'John S. Smith (DR)', 'Seated December 3, 1821']
SQL:

assistant: SELECT "Vacator" FROM "Table" WHERE "District" = 'South Carolina 4th';