Database created is not visible in warehouse folder

  1. Created a database with the command -

create database if not exists cards_sp;

  1. dfs -ls /user/hive/warehouse/cards_sp;

dfs -ls /user/hive/warehouse/cards_sp.db;
ls: `/user/hive/warehouse/cards_sp.db’: No such file or directory
Command failed with exit code = 1
Query returned non-zero code: 1, cause: null

It shows that the database created does not exist, please let me know where the issue is and how to resolve the same.


For hive warehouse directory correct path is:

dfs -ls /apps/hive/warehouse/cards_sp.db;