Table Creation in Hive

In this video we are discussing table creation in Hybe

In the previous video we have shown you that how to create one database and how to use that one

So let us go for table creation in Hype. So how to create table in Hype

So create table is a statement used to create a table in Hype and the syntax and examples

will be as follows. So create table name, attribute types, then we will

going for row format then row format has to be mentioned then fields terminated by delimiter

so fields terminated by delimiter and then one semicolon so this is a this is a total

command to create one table with the respective table name and other details we can use some

other attributes related to the table also so to see the table description after creation

you can see the description of the table use the command described then

table name and then one semicolon after that So let us go for one practical demonstration to show you that how these tables can get created and how to use the describe command

In this demonstration, we shall create one table. The name of the table will be student

and this table will be created under the database, that is the My database which you created in the earlier video

So already we have used the command, that is the Use My database

So whenever I shall create this table, the name of the table will be stood and that will be under this my database only so how to

create a database how to create a table under this database my database and here the table name

will be stood and it will have three fields so first one is the name then the major and the last

one it will be the city and all of them will be of the type of string so I'm going to issue

the command so I shall go for this create then table I shall go for create table

the table name is stood and then i shall go for this name of the type of string say major of the type of string then we shall go for your city of the type of string bracket

closing then we shall go for row format delimited so row format delimited

fields terminated by comma so terminated by comma so comma should be kept within the single

quotes here and then we shall go for stored as text file so here you see the

command is our create table stood name of the type of string measure of the

type of string city of the type of string so the first bracket will get

ended here row format delimited fields terminated by comma and here and here

here we having this one as stored as text file so the table has got created now so we can use we can see the table description using the command describe You can go for this described stude You can see that the table description will be obtained

You shall go for describe. So I think the previous comment was having some error

I shall go for this describe stood. You can find the description here

You can get the description. That is our name of the field is name

of the type of string. Next field is our major of the type of string and city of the type of string

So if you type this, describe stood, you see, we have written this describe in the capital

letters, then also the command will get executed. So here the command is case insensitive

You can write these commands either in the lowercase or in the uppercase letters and both

will behave the same. So in this way, in this particular demonstration we have shown you that how to create a

table, here the table name was stood and how to see the respective description of this

table using the command described. Thanks for watching this