Hive Database Creation & Usage

In this video we are discussing database creation and its usage

So, we shall show you that what are the commands to be issued to create one database and

how to use that one. So, how to create database? So, in height there is a default database

And we can create a new database using the command that is a create database and then

database name. Then we can put one semicolon after that. So create database database name semicolon

with help of which you can create a new database, otherwise also you can work with the default one

To switch to the database from the default to the newly created database, the command will be used

and that very database name which was used while creating the database

So the command will be used database name and semicolon. And obviously, these commands are to be executed

So start Hadoop first to run all these commands, then only the commands will be executed

So let us go for one practical. demonstration to show you that how to create and use these databases in practical At first we shall start Hadoop So control altered T to initiate one new terminal here

So to start Hadoop, we should type dollar Hadoop underscore install all in capital letters slash has been slash start hyphen

slash start hyphen all dot sH so this is a shell program which are which is supposed to get

executed to start Hadoop on our system now to check whether Hadoop is executing properly

or not we are executing the command JPS and you can find that node manager name node

resource manager secondary name node and data node all the processes are executing now

we shall initiate our GUI interface of Hadoop so we are opening our browser in the URL we are typing local host local host colon 50070 slash

You see the name node related information is coming here. All the name node related information they are coming

So Hadobe is operating fine. You can go for utilities, you can go for browse the file system and all the default folders

files are coming here so that indicates that my Hadoop is executing perfectly it

has got loaded and initiated into the memory now at first we shall initiate

one terminal so we are pressing here we are using control alter and T so one

terminal will be opened and here to load this hive so we shall go for HIV so

you give writing this hive here so you can find that the HIP

prompt will be coming here so we shall go for creation of a new database in this hype environment and you see the hype prompt has come and we shall create a new database and the name of the database will be my database so in that case we shall issue the command there is a create database there is a create database my

database okay so I've given this one and at the end of the command I should

give the semicolon so you see the database has got created so

now I shall go for use database name so my database if I press enter give the

semicolon here here you see we have we have logged into this particular my

database we're using this one so now if you create any table if you issue any

commands here now it will be operating on this my database so in this

demonstration we have shown you that how to create one database so here the

database name is my database database and how to use it so the next time when you shall go for any table creation

insertion of records and all and that will be done on this my database only

thanks for watching this video