Unable to find .db file in /user/hive/warehouse path


#1

I have created a database with name “rajiv_hv” in hive. But I am unable to find its corresponding .db file in path : /user/hive/warehouse. I also tried to give my path using LOCATION clause but still its not created. PFB syntax used:
create database rajiv_hv COMMENT ‘Hive learning data’ LOCATION ‘/user/hive/warehouse’ with DBPROPERTIES (‘creator’ = ‘rajiv mishra’ , ‘dateyy’ =‘30-Dec-2018’);


Practice hive on state of the art Big Data cluster - https://labs.itversity.com



#2

@RAJIV_KUMAR_MISHRA
Look at the location /apps/hive/warehouse to find your .db file.