Create databases and tables

Originally published at: http://www.itversity.com/topic/bde-hive-create-databases-and-tables/

Introduction As part of this topic, let us understand how we can create tables Accessing official hive documentation Create Databases Managed tables External tables Defining Delimiters Specifying location Loading data into hive tables Create Databases Let us see what are databases and how they are created In Hive, database is nothing but a directory under hive.metastore.warehouse.dir By…