Question: what is the difference between local metastore and embedded metastore?
Answer: Embedded Metastore: By default Derby database is there which supports one one user, so only one shell you can open. ... In Local mode, the Hive metastore service runs in the same process as the main HiveServer process, but the metastore database runs in a separate process, and can be on a separate host.