Adding the clustername in the ALTER table statement seems to solve it in my case: So create table seems to work without cluster name, but ALTER TABLE requires the clustername in the SET LOCATION. ... View more

I' am facing exactly the same problem. Changing location (ALTER TABLE ... SET LOCATION) to an exisiting (renamed directory) allows me to run "SELECT * FROM [table]" but attaching an "ORDER BY" fails with "cannot find dir" (location pointing to a file, not directory). Dropping the external table and creating with the new location works fine. Any hint on this would be highly appreciated, if anyone already found the cause or a solution/ workaround . ... View more