要在Hive中創(chuàng)建表并添加數(shù)據(jù),可以按照以下步驟操作:
打開Hive命令行界面。
創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)(可選):
CREATE DATABASE dbname;
USE dbname;
CREATE TABLE tablename (
column1 datatype,
column2 datatype,
...
);
例如,創(chuàng)建一個(gè)名為employee
的表,包含id
和name
兩個(gè)列:
CREATE TABLE employee (
id INT,
name STRING
);
STORED AS
和ROW FORMAT DELIMITED
:CREATE TABLE tablename (
column1 datatype,
column2 datatype,
...
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE;
INSERT INTO tablename VALUES (value1, value2, ...);
例如,往employee
表中插入一行數(shù)據(jù):
INSERT INTO employee VALUES (1, 'Alice');
SELECT * FROM tablename;
這樣就可以在Hive中創(chuàng)建表并添加數(shù)據(jù)了。