szymon_dybczak
Esteemed Contributor III

Hi @YOUKE ,

As @MuthuLakshmi  pointed out, managed tables in Hive metastore are always created in the storage location of the containing schema. So, if you don’t provide a location when creating schema in hive_metastore, the default location user/hive/warehouse/schema-name is used. This location is on the DBFS root, which is not recommended for storing any production data.