Quick question, after apply the ALTER TABLE SET LOCATION mentioned above , should I run something else before query the table? after the alter I'm unable to fetch data from the table

In previous lives I have had to run msck repair table for it to show up again.