Database created is not visible in warehouse folder


#1
  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.


#2

For hive warehouse directory correct path is:

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