How to load data files into a hive table?

2 years ago
Jackson Davis
1 minute

You can load data files into a Hive table by following these steps:

  1. To create a table: Begin by using HiveQL statements to create a data table, defining the table’s structure and fields.
CREATE TABLE table_name (
  column1 data_type,
  column2 data_type,
  ...
)
  1. Load data file: Upload the data file to HDFS or the local file system, and use HiveQL statements to load the data file into the data table.

Load data files from the local file system.

LOAD DATA LOCAL INPATH 'local_path_to_data_file' INTO TABLE table_name;

b. Load data files from HDFS.

LOAD DATA INPATH 'hdfs_path_to_data_file' INTO TABLE table_name;
  1. Check the data: Use a SELECT statement to query the data in the table and ensure that the data has been loaded successfully.
SELECT * FROM table_name;

By following the above steps, you can successfully load the data file into a Hive data table.

bannerAds