Data insertion into Hive Table

In this video we are discussing data insertion into a table

In the previous videos we have shown you that how to create a database and how to create

one table. Now we shall discuss that how to insert data onto those created tables

Data insertion on the table can be done in two different ways, either directly issuing

the insert command where we'll be passing our data so that data can get inserted into

the table. And another way is that from the data file we can fetch data to insert it in the data

as the records in the table. So we shall be discussing both of them

So let us discuss one by one. At first, we are starting with that how to insert data into hype table

So we are starting with that we can add data from a file

So how to fetch data from the file so that my data will get inserted in the hype

So we can add data from a file stored in the HDFS directory

And the syntax will be like this, that is load data in path

path has to be mentioned into table then the table name has to be mentioned here

So the command is load data in path. The path will be mentioned where we can find the file containing the data and then into table and then table name and semicolon We should remember that the fields terminated by type must be matched with the fields terminated

delimited in an actual data file. That means, whatever the terminators were using here and they should match with each other

Otherwise, the data insertion may not be successful. So now let us go for another type of insertion

is we can also insert data without using a file. That means this insertion syntax is very

similar with the RDBMS insert query syntax. So, syntax will be insert into table, then table

name values, then within first brackets, val 1 comma val 2 comma dot dot dot, then we can have the

valend and then we'll be having the closing fast bracket. So we have seen that there are two ways

to insert data onto the height table. One is from the data file and another

the one is using our insert query. When you are going for the data file insertion, that is

the data file content will be inserted onto the hype, in that case the delimiter should match

That means the data file must have the data separated by some delimiters maybe comma or some other characters and that delimiter must be matching So otherwise the data insertion will be unsuccessful and in case of directly inserting data onto the high table

the query syntax is very similar with the rdbMS insert query syntax so let us go for one

practical demonstration for the better understanding on this query executions in this demonstration

we shall insert data from the sdfs file so here we are selecting

one file so it is our sdfs route and then we're having this one as had do my files if you click

here we're having one file that is a student underscore info c sb so let me at first check the

current content of this file so i shall go for this control alter t so one new terminal has got

opened so let me check what is the current content of the file that is the student underscore

info c sb residing under the the residing under the folder that is the Hadoop my files so here the command is

HDFS then DFS then minus CAT then Hadoop root then you shall go for Hadoop my

files then we shall go for Hadoop my files and then we shall go for student I need not to type the full one I can also put the wild card character

So the file content is this is a file content. You can find that this file content

We can easily access this file content. That is Amit Electronics, Kolkata. So then Dinesh, Computer Science, Chennai, Kusol, Fedix, Kolkata, Roctim, Computer

Science, Delhi and Tapos, Electronics, Mumbai. So from this file that is a student high underscore info c sb I want to load my data onto my

onto my database that is a hype database whatever you have created so let us go for the same

So here our our table name is our stood so in this stood I'm going to put that one so how to do so we shall go for this one as load

then data then in path then within single code I'm supposed to write the

full thing so that is our my that is the hardup my files so remember that hard of

was written in the capital letters M and F so how do ing files so m and f

should be in capital letters