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

Reply via email to