HVIE、HDFS常用操作

建库

create database ods;

建表

create table ods.employee (
eud int,
name String,
salary String,
destination String
) COMMENT 'Employee table'
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

从local上传到HIVE

load data local inpath '/home/hadoop/data/employees.txt' into table employee;

上传数据到HDFS

hadoop fs -mkdir /data
hadoop fs -put ./data.txt /data

从HDFS上传到HIVE

load data inpath '/data/data.txt' into table employee1;

遍历HDFS数据

hadoop fs -ls -r /user/