I'm using the hive docker-compose quickstart with 4.0.1 I've created a schema:
CREATE SCHEMA mydb MANAGEDLOCATION 's3a://datastore/mydb'; But when I DESCRIBE it, I see the following: +----------+----------+-----------------------------------------+-----------------------------------------+-------------+-------------+-----------------+----------------+ | db_name | comment | location | managedlocation | owner_name | owner_type | connector_name | remote_dbname | +----------+----------+-----------------------------------------+-----------------------------------------+-------------+-------------+-----------------+----------------+ | mydb | | file:/opt/hive/data/warehouse/mydb.db | file:/opt/hive/data/warehouse/mydb.db | hive | USER | | | +----------+----------+-----------------------------------------+-----------------------------------------+-------------+-------------+-----------------+----------------+ 0: jdbc:hive2://localhost:10000/> use mydb; 0: jdbc:hive2://localhost:10000/> create table test (col1 int); org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:file:/opt/hive/data/warehouse/mydb.db/test is not a directory or unable to create one) Any ideas? Should the managedlocation in DESCRIBE show s3a:// ?