- 最新
- 最多得票
- 最多評論
Hello,
As far as I know, you need default database in glue data catalog as a default database and deleting it might cause issues. In AWS Glue job’s catalog integration, AWS Glue always tries to check whether default database exists or not using AWS Glue GetDatabase API. When the DESCRIBE Lake Formation permission is not granted, or GetDatabase IAM permission is granted, then the job fails when verifying existence of the default database.
"default" database is the one that hive uses by default which can not be changed or set to other dbs. However,
To see the tables belonging to your "user_created_database": run,
show tables from user_created_database;
Then, to run your queries, you can either specify the full table name using the notion database.table:
select * from user_created_database.your_table
or you can change database (i.e., USE statement) and then run your queries:
use user_created_database; show tables;
相關內容
- AWS 官方已更新 1 年前