CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.] table_name

[(col_name data_type [COMMENT col_comment], ...)]
[COMMENT table_comment]
[ROW FORMAT row_format]
[STORED AS file_format]

创建一个用户信息表

CREATE external TABLE IF NOT EXISTS user_info ( name String, age int )
COMMENT '用户信息 details'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\\t'
LINES TERMINATED BY '\\n'
STORED AS TEXTFILE ;

• 执行导入语句

hive> LOAD DATA LOCAL INPATH '/Users/huajiejun/ewell/hadoop/demo/demo.txt' INTO TABLE user_info;