Hive LOAD Local File system Data


Hive LOAD Data from Local Directory into a Hive table.

If you have huge amount data i.e Big Data on your Local Laptop/PC filesystem then you can use the following load the data from you local file system directory to HDFS on hive CLI(command line interface).

here LOCAL INPATH keywords states that we are loading the data from local file system.

Before Loading the Data into Hive table, we need to ensure whether the Hive table has been created or not
if it is not created then we need to create the table first.

Let us assume that we have already created a table something like this.

How to Load the DATA from our Local PC/Laptop file system to Hive Table?

Let us Load the Data using the following HiveQL.

Let us check by selecting the data from STUDENT TABLE.

Leave a comment

Your email address will not be published. Required fields are marked *

2 thoughts on “Hive LOAD Local File system Data”