Changing the Hive table type using the DDL statement does not work

You can change properties like this but the actual data/folder location will not change and can cause confusion. Hive will show you whatever DDL you will apply and it wont change table properties from external to internal. Clean and better way is to recreate table like below.

create table mymanagedtable as select * from mytable;
drop table mytable;