Amazon EMR
Amazon EMR Release Guide

Metastore Manager Restrictions

The Metastore Manager default database exists in HDFS. You cannot import a table from Amazon S3 using a database stored in HDFS. To import a table from Amazon S3, create a new database, change the default location of the database to Amazon S3, create a table in the database, and then import your table from Amazon S3.