user: Question: Who is the successor for Massachusetts 8th?
Columns: ['District', 'Vacator', 'Reason for change', 'Successor', 'Date successor seated']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Virginia 2nd', 'George Dromgoole ( D )', 'Died April 27, 1847', 'Richard K. Meade ( D )', 'Seated August 5, 1847']
SQL:

assistant: SELECT "Successor" FROM "Table" WHERE "District" = 'Massachusetts 8th';