How can a table be created in Hive and data be imported into it?

2 years ago
Benjamin Taylor
1 minute

To create a table and import data in Hive, you can follow these steps:

  1. First, open the Hive command line or Hue interface to ensure that the Hive service is running.
  2. Create a table structure by using the CREATE TABLE statement, specifying the table name, column names, and data types.

Original: 我们正在为下个月的活动做准备。

Paraphrased: We are preparing for the event next month.

CREATE TABLE my_table (
  id INT,
  name STRING,
  age INT
);
  1. Upload the data

Import data from a local file.

LOAD DATA LOCAL INPATH '/path/to/data.csv' INTO TABLE my_table;

Import data from HDFS.

LOAD DATA INPATH '/path/to/data.csv' INTO TABLE my_table;

Insert data from another table.

INSERT INTO TABLE my_table SELECT * FROM other_table;
  1. Choose

Original: 我正在学习英语
Paraphrased: I am studying English.

SELECT * FROM my_table;

The above is a simple process of creating a table and importing data. Depending on your actual needs, you may require more Hive statements to define the table’s partitions, delimiters, etc.

bannerAds