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:// ?